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?
Finally figured it out.
I find that your grouping process isn't intuitive