I had done something like this years ago and I have in my notes:
Header can not be suppressed based on a formula that has not been calculated yet. So any formula that uses
whileprintingrecords;
will not work for suppressing the group header. You can create a formula on the detail line that says
if {field}=x then y
right click on the field and insert summary and summaries by the group. This will allow the header to have the summary as well as the detail.
Not very detailed but I think it is saying if you create a formula and do a sum of it that it will be available to the header.
------------------------------
Todd Martin
MBA Business Software (https://www.mbabsi.com)
------------------------------
Original Message:
Sent: 09-01-2021 15:51
From: Lourdes Sobrino
Subject: Condition a message on Crystal
OK...maybe I did not explain myself correcty it is not a SUMMARY field ...its a RUNNING TOTAL that they want to print conditioned on the header.
If there are items with a specific CAT included in the invoice....then the message appears...
------------------------------
Lourdes Sobrino
LU² DSD Puerto Rico
Guaynabo Puerto Rico
787.485.9638
------------------------------
Original Message:
Sent: 09-01-2021 15:19
From: Brett Zimmerman
Subject: Condition a message on Crystal
Attached is a quick sample...
------------------------------
Brett Zimmerman
Net at Work
Greater Boston Area
Original Message:
Sent: 09-01-2021 15:13
From: Kevin Moyes
Subject: Condition a message on Crystal
Running Total / shared variables: no. Those are calculated during the line by line processing of output.
A "sum" of a simple data field: yes. That is available in group header sections for sure. Page headers... possibly, but may not be reliable depending on the new page per group logic. Create a formula field for the sum and display that where you want the suppression logic applied to make sure it is calculating correctly before using it.
------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
Toronto ON