Skip to main content

I am fairly new to Report Designer and I have a requirement where they want the total of a column in the header section, this should print only on the first page and values consideredshould be where page index = page count, how can I fulfill this?

Hi @TharidhiP if I understand correctly, you wanted to sum the grid column value and display it in the Header section.

If yes, I have created a sample example in Sales Order report. Please find the details below.

Ex: I’m displaying the sum of Grid Qty and showing in the Header section.

  • Create a variable, where you wanted to display this Sum of the Qty value (Header Section)
  • ValueExpr for the variable will be like Sum(Qty)
  • Create a new textbox field in the Header section.
  • Assign the variable to the newly created textbox.

Please find the screenshots for reference.

 

@Naveen B  thanks, I will try this approach.

Reply


Terms & ConditionsCookie settings