Monday, March 19, 2012

How to add summary functions in group footers for report with no database field

Hi,

I use a crystal report that does not have any database fields, only formula fields. I already know how to add a group with the addgroup method, but need to know how are summary fields added?

I need to add a sub total for a money field in each group that has to show at bottom of each group but am unsure as to how this is done. Any help would be very much appreciated.

Again, I don't use any database field and so CR does not allow me to physically add a group section and paste any formulas. It seems this needs to be done by code.

I'm desperate!

Regards,

MikeHi,
U need database fiels in crystal report, it is very important, without having any data what r u gonna show in your report.

Field on which u want to summarize,

In your report detail section, right click the desired field and "Insert" > "Summary". Select "count" and place it in group footer

U will have various options as maximum , minimum, count , Mode etc, select according to your report requirements.

No comments:

Post a Comment