Exclude One of Two Report Groups From Appearing in Group Tree

[dede2897234]

Hello,

I am currently using Crystal Reports 8.5. I have a report that has the following two groups:

G1) hospital client number
G2) date

I would like the hospital client numbers to appear in the group tree as well as their footer sections to display the appropriate summary values. On the other hand, I would like the dates to NOT APPEAR in the group tree and their footer sections to display the appropriate summary values. If this is possible to do in Crystal, please post the code below. Thanks.

 

[synapsevampire]

Perhaps you can omit the date group, add a sort by the date, then build running total fields to handle the sums/counts you want by date using reset at change of field {MyTable.MyDate}, and placing the running totals in the details section, and use a suppression on them as in:

next({MyTable.MyDate}) = {MyTable.MyDate}

Now these sums/counts will only show when they are changing.

Inelegant, but effective.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[dede2897234]

synapsevampire,

You're a genius! Your idea worked perfectly. Thank you very much for all your help!