Page number on tabular report

0 Answers 23 Views
Report Designer (standalone)
Taras
Top achievements
Rank 2
Iron
Iron
Veteran
Taras asked on 01 Feb 2022, 06:31 PM

I have a report that's basically an export of a SQL View.

Parameters are passed in to filter the view based on Venue and a range of Event Date (i.e.: EventDate between (@StartDate) and (@EndDate)

The report is rendered correctly, except that I cannot get a page number using

= PageNumber("detailSection1", Fields.Venue) + " of " + PageCount("detailSection1", Fields.Venue)

It appears that this will only work if there is something in detailSection1. Only thing there is the table.

If I add Fields.Venue into detailSection1, I get that page # and count, but the problem is that I get one page for each row in the view since Venue is part of it.

I tried this with no luck = PageNumber("VenueSummaryTable", Fields.Venue) + " of " + PageCount("VenueSummaryTable", Fields.Venue)

So, how do I get the table to only appear once and be able to get the page # and page count?

Taras
Top achievements
Rank 2
Iron
Iron
Veteran
commented on 02 Feb 2022, 09:32 PM

Finally figured it out.

I find that your grouping process isn't intuitive

No answers yet. Maybe you can help?

Tags
Report Designer (standalone)
Asked by
Taras
Top achievements
Rank 2
Iron
Iron
Veteran
Share this question
or