For Programmers: Free Programming Magazines  


Home > Archive > Visual Basic Crystal Reports > March 2006 > Is this possible









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Is this possible
Danny M

2006-03-15, 7:58 am

I am new with crystal reports
I am using CR11

Now my question is this possible:
I am using a database like this:
ndA, sdTitelA, ndType, ndTotal

Now i want a report like this:

sdTitelA

ndTotal (from record where ndType
= 0 and ndA = X >is only 1 record)
ndTotal (from all records where
ndType = 1 - and ndA = X 1-5 records)
------------ +
total (total from all ndTotal
above)
ndTotal (from all records where
ndType = 2 and ndA = X 1-5 records)
------------- +
total (another sub total)
ndTotal (from record where
ndType = 3 and ndA = X >is only 1 record)
------------ -
total (final sub total)



sdTitelA
ndTotal etc......


Is this possible ? , if yes does anyone have an example how to do
this?

PJ

2006-03-16, 7:57 am

I have not used CR11, but it sounds like what you need to do is group the
data and suppress the details.

HTH,
PJ

"Danny M" <dmertens@home.nl> wrote in message
news:1142428598.311750.8870@p10g2000cwp.googlegroups.com...
I am new with crystal reports
I am using CR11

Now my question is this possible:
I am using a database like this:
ndA, sdTitelA, ndType, ndTotal

Now i want a report like this:

sdTitelA

ndTotal (from record where ndType
= 0 and ndA = X >is only 1 record)
ndTotal (from all records where
ndType = 1 - and ndA = X 1-5 records)
------------ +
total (total from all ndTotal
above)
ndTotal (from all records where
ndType = 2 and ndA = X 1-5 records)
------------- +
total (another sub total)
ndTotal (from record where
ndType = 3 and ndA = X >is only 1 record)
------------ -
total (final sub total)



sdTitelA
ndTotal etc......


Is this possible ? , if yes does anyone have an example how to do
this?


Sponsored Links







Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive

Copyright 2008 codecomments.com