Display Continued Message When Group Spans Multiple Pages

Display Continued Message When Group Spans Multiple Pages

Posted by: dklingman on 6 January 2020, 11:06 am EST

• 

  dklingman

  • Post Options:
  • Link
    Copy

  Posted 6 January 2020, 11:06 am EST

  Is there a way to display a message in a group header such as, (continued…), when the group spans across multiple pages in either an RDL or Page report?

  I know it can be done with section reports. However, we use Active Reports Server and will be transitioning over to the new Wyn Enterprise which will not support section reports. We need to be able to do this with RDL’s and/or Page Reports.

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 7 January 2020, 3:21 am EST

  Hello Derek,

  You need to use the following expression to show the (continued…) in the group header if it spans across multiple pages.

  ="Employee ID:" & IIF (Globals!PageNumberInSection=Globals!TotalPagesInSection,ReportItems!TextBox10.Value,ReportItems!TextBox10.Value & "(continued...)")
  

  In AR12, there is a limitation that you cannot use the fields with Page number expression. So as a workaround, you need to bind the value with some textbox in the group header and use the value of textbox in the expression as shown in the above expression.

  Also, please refer to the attached report to implement the same.

  Thanks,
  
  Mohit
  
  rpt_Group.zip
  
  rpt_group.zip