Thursday, October 1, 2020

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