Can I know if is there a way to set the visibility of the Detail Section’s header to appear on a page without keeping it as ‘Print on every page = True’ if only the Detail Section has been populated in that specific page? Please check the below attachments. It depicts the 2nd page of the report.
Best answer by BenjaminCrisman
View original
+7
Hi
I tried to find a way to accomplish this but no luck so far 😔. My thought was to move the headings into a separate detail section before the line details, increment a variable to keep track of the lines on the each page, and print the heading section only before the first line on each page.
Where I ran into trouble is with resetting the line counter for each page. I cannot get this working in either the page header or footer. It may be a limitation, or perhaps one of my settings is incorrect.
Maybe another expert out there can help to figure this out!
Laura
You can review that report for a better look, but the main idea is to set the group ProcessOrder = Always and then set the visibility to something like [PageIndex] = 1. I’ve never tried it on a header section that involves actual fields, so hard to tell exactly how the ProcessOrder may impact other fields, especially variables, but it may be worth a try.
If that doesn’t work, can you attach your RPX file here to review?
Thank you so much
+4
Hi
If that is the case, then I would recommend to put a visibility condition on the header to specify to only show if the CROpportunityProducts.LineNbr > 0, and set the Process Order to Always.
Here’s how it worked for me:
Then when I check a quote which has no detail lines:
Then if the quote had detail lines:
Let me know if that is along the lines of what you’re looking for.
Thanks!
Thank you so much
As in above i have included few new group footer sections to the report. I have been set the ‘Print on every page = True’ for the Table header of the details sections. But when report gets paginate a issue like below occurs. Please check the below screenshots. That means when the report getting paginate and in the last page of the report, the Detail section’s header appears without the line details on it. As line details are over from the page 4. I just need to appear the Header of the detail section(Line level table headers) up to the page 4 only without appearing it on the last page.
Here with I'm attaching the report rpx file for your further reference. Thank you very much for your great support.
+4
+4
What I did was create a new grouping and set the Reset Group of the $LineNbr variable, to this new group:
Then I print the report:
You can see that the footer details are pushing the last couple lines onto another page, but there is no LineNbr there:
To be honest though, I don’t really know why it works, but it does for me :)
Hope it helps you too
Thank you very much
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
