I want to perform a calc (see “@Compare” formula below) on Group 4 subtotals. I’d like to sum the result of this calc "@Compare" in the higher groups (Group 1, Group2, Group 3).
I am unable to use the Crystal’s Summary function (I assume because the result of “@Compare formula” is in a group section and not in the detail section). Same problem with running total. “@Compare” is not available to summarize.
@Compare formula = If column A> Column B then Column A else Column B
Example Groups and Sections
Column ID: A B C
Group 1 – Job Subtotal Group #1 CC sum of @Compare formula
Group 2 – CSI Subtotal Group #2 CC sum of @Compare formula
Group 3 – CC Subtotal Group #3 CC sum of @Compare formula
Group 4 – Cat Subtotal @Compare formula
Detailed Trans Section
Also - Users want to drill down to the “Detailed Trans” level
Can somebody recommend a direction? My other attempts (in progress):
1. A subreport to summarize the “Detail Trans” section and pass Cat Subtotals from subreport to Main. This will allow my main report’s detail section to be “Cat” thus allowing Crystal summary.
2. A formula in the detail section that summarizes amounts base on Cat value. Link an “On Demand Subreport” if the user needs to drill down to detailed trans level.
Explore all the enhancements in one game-changing release, ScreenConnect 6.0, based on partner feedback. New features include a redesigned UI, app configurations and chat acknowledgement to improve customer engagement!
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples).
Crystal Reports uses a two-pass reporting process to provide greater …
Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8.
We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
The Email Laundry PDF encryption service allows companies to send confidential encrypted emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…