dbabaracus
New member
- Local time
- Today, 07:32
- Joined
- Jul 26, 2017
- Messages
- 4
I was messing around with getting record counts to show up in a Report Header, and found what appeared to be a workaround.
You do the trick of creating an invisible "=1" box in your group (let's call it "GroupBox") and a running sum box in the footer named BoxSUM. Then I found that if you refer to the footer box in a Report Header text box, the value will actually show up. Something like this:
REPORT HEADER:
Name: [HeaderBox]
Output: Report Count - 52
Expression: ="Report Count - "&[BoxSUM]
GROUP HEADER
Name: [GroupBox]
Output: 1
Expression: =1
REPORT FOOTER:
Name: [BoxSUM]
Output: 52
Expression: =[GroupBox]
However, this only works in Report View. When you go to export the report as a text file, the number in the header reverts back to being a 1 (the usual output when you putting a running sum in the header).
Why is that, and is there a way to export what you actually see in the Report View?
You do the trick of creating an invisible "=1" box in your group (let's call it "GroupBox") and a running sum box in the footer named BoxSUM. Then I found that if you refer to the footer box in a Report Header text box, the value will actually show up. Something like this:
REPORT HEADER:
Name: [HeaderBox]
Output: Report Count - 52
Expression: ="Report Count - "&[BoxSUM]
GROUP HEADER
Name: [GroupBox]
Output: 1
Expression: =1
REPORT FOOTER:
Name: [BoxSUM]
Output: 52
Expression: =[GroupBox]
However, this only works in Report View. When you go to export the report as a text file, the number in the header reverts back to being a 1 (the usual output when you putting a running sum in the header).
Why is that, and is there a way to export what you actually see in the Report View?