10 February 2012

Crystal Reprts Page breaks (on filed Values changes from one page to another)

You have a date column in crystal report.  When date values changes those details should display in the next page. To get this effect you keep the check mark in the “New Page After” of Group, but you change the “New Page After” for Group Footer Section  to be a condition formula.  To do that Follow the steps
Step 1: Right click on "GroupFooterSection" and select "Section Expert" as shown below.

Step 2: When click on Section Expert then it will show sections window check the "New Page After" and click on Formula Editor button then it will show a window to write formula.

Step 3: Then drag and drop the field which and write the condition and then click on Save and Close button.


The formula would be:
{Table.date} = Next ( {Table.date} )

The formula says that when date changes it allowed to do the page break as long as the report date differ form one page to another.

No comments:

Post a Comment