Page break based on conditions

Page break based on conditions

Posted by: nguyenduyhanlam on 21 November 2019, 5:25 am EST

• 

  nguyenduyhanlam

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 21 November 2019, 5:25 am EST

  Example the data will look like this:
  
  ColA | ColB | ColC
  
  1 a a
  
  2 a b
  
  … … …
  
  28 b a
  
  29 b b
  
  … … …
  
  N z z

  Binding the datasource in the current section report (i do it in report start function):

  
  Me.DataSource = MyDataTable
  
  

  I have create 3 labels (lblA, lblB, lblC) for 3 columns above in detail section (in design). Each label properties i set the DataField to its column in MyDataTable (ex: lblA will have DataField look like this:

  | DataField | ColA |

  The problem is i don’t know to make the report break to the new page if it:

  1. fully has 45 rows/records in one page
  2. OR ColB has changed to the new letter
     
     I am using ActiveReport9J.
     
     Thank you.
• 

  esha.dhir

  

  • Post Options:
  • Link
    Copy

  Posted 25 November 2019, 4:32 am EST

  Hello,

  For (1), please refer the following blog to implement the same requirement:
  
  https://www.grapecity.com/blogs/page-break-after-n-records-section-reports

  For (2), you can set the DataField for grouping, to the value of ColB.
  
  https://help.grapecity.com/activereports/webhelp/AR9/index.html#AddGrouping.html
  
  The conditions may change (and not work as expected) if you apply both of these at the same point.

  Note: Support of AR 9 is not provided now as it is out of the maintenance period.
  
  Regards,
  
  Esha