NAV / BC - Hide Purchase Order Header based on Page Count - Only show header on first page
- There is no way to get the page numbers from SSRS
- We have to put a line counter in the Purchase Order Report Code to calculate the number of lines per page
- then we use SSRS functions on the lines to hide based on the value of the Line Count
- We reset the line count for every PO
- Create Pagecount Global variable
- Added to Data source to make it available to the report
- Added Pagecount := 0 in Copyloop Onpredataitem after Purchase Header
- Added Pagecount := Pagecount + 1 in Roundloop Onaftergetrecord after Purchase Line
- Our count ended up being max 18 records on the first page
- Added visibility function on SSRS row
- IIF(Pagecount <10,false,true)
No comments:
Post a Comment