Software Engineer
asked on
Crystal Reports Not Letting You Summarize a Formula
Hi!
After two hours in a support call, I could not figure out how to do something that every tech support article in cyberspace outlines to do in Crystal Reports, when you have to summarize a formula. (Crystal won't let you do so, conventionally.)
I tried the variables where you conduct "x:= while printing records" but to no avail.
If anyone out there has had a challenge with this, please tell me what you did to overcome it.
As best as I can tell you and as best as I can remember from the support call, there is a formula in Group Footer #1 - not in Details - and I need to have a subtotal for this appear in Group Footer #2.
I created several "variable" formulas, I put them in this header, that header, this footer, that footer, the Report Footer, the Report Header, etc.
I did everything to the letter, but I still could not get a simple subtotal to appear.
Please help.
Thanks!
John
After two hours in a support call, I could not figure out how to do something that every tech support article in cyberspace outlines to do in Crystal Reports, when you have to summarize a formula. (Crystal won't let you do so, conventionally.)
I tried the variables where you conduct "x:= while printing records" but to no avail.
If anyone out there has had a challenge with this, please tell me what you did to overcome it.
As best as I can tell you and as best as I can remember from the support call, there is a formula in Group Footer #1 - not in Details - and I need to have a subtotal for this appear in Group Footer #2.
I created several "variable" formulas, I put them in this header, that header, this footer, that footer, the Report Footer, the Report Header, etc.
I did everything to the letter, but I still could not get a simple subtotal to appear.
Please help.
Thanks!
John
This is the kind of report for which I do all my calculations from a stored proc or from .Net code and push the dataset containing all aggregates I need to the report.
Have a look at https://www.emoreau.com/Entries/Articles/2016/10/Crystal-Reports-for-Net-revisited-10-years-later.aspx
Have a look at https://www.emoreau.com/Entries/Articles/2016/10/Crystal-Reports-for-Net-revisited-10-years-later.aspx
ASKER
Hi Mike:
Attached is the report. Out of the ten columns containing dollar or numeric values, I have been able to subtotal seven of those columns.
The other three columns that do not have the subtotaling are the ones where I'm having this issue. These columns are, mainly, on the far right of the report.
Would you mind please taking a look and giving me some "pointers"?
Thank you, Mike!
John
Detail-Lincoln-Executive.rpt
Attached is the report. Out of the ten columns containing dollar or numeric values, I have been able to subtotal seven of those columns.
The other three columns that do not have the subtotaling are the ones where I'm having this issue. These columns are, mainly, on the far right of the report.
Would you mind please taking a look and giving me some "pointers"?
Thank you, Mike!
John
Detail-Lincoln-Executive.rpt
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
This worked! Thank you, Mike!
John
John
Can you upload the report or verify where the formulas are?
mlmcc