Joined: 01 May 2008
Location: United States
Online Status: Offline
Posts: 6
Topic: Adding "Continued" to Page Footer across subreport Posted: 04 Dec 2009 at 7:35am
I have a tricky requirement to print "Continued" at the bottom of a page if the subreport is going to print across multiple pages.
I know there is no page footer in a subreport, so obviously I need to use the page footer on the main report.
My idea is to use shared variables, and what I have setup seems to work, but I'm not getting the results I expected.
Here's are the formulas I have setup, and where they are placed within the reports.
Please note
- all these formulas are basic syntax).
- The subreport is in a details section of my main report
Report Header of Main Report WhilePrintingRecords
Shared PrintingSecurities as Boolean
PrintingSecurities = false
formula = ""
Report Header of Sub Report WhilePrintingRecords
Shared PrintingSecurities as boolean
PrintingSecurities = true
formula = ""
Report Footer of Sub Report WhilePrintingRecords
Shared PrintingSecurities as boolean
PrintingSecurities = false
formula = ""
Page Footer of Main Report WhilePrintingRecords
Shared PrintingSecurities as boolean
formula = PrintingSecurities
I'd just be happy to see "True" at the bottom of the page for now, so I will know this shared variable setup works, however unfortunately I only see false in all of the page footers.
I've also created a debug display formula that looks just like the Page Footer formula, and put that in the subreport details sections, and I can clearly see "True" being printed as the value, even across a page break, but right smack in the middle of that printing, the page footer prints false.
Any ideas on what could be wrong here? I'd appreciate any help, or maybe another idea!
Joined: 01 May 2008
Location: United States
Online Status: Offline
Posts: 6
Posted: 04 Dec 2009 at 2:33pm
I finally figured it out,
The fix is to set the "PrintingSecurities" value to True in the main report, in the same section the subreport is located in. Everything else stays the same!
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum