Print Page | Close Window

Page break when date changes.

Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22905
Printed Date: 24 Apr 2024 at 3:09pm


Topic: Page break when date changes.
Posted By: JRCharlie
Subject: Page break when date changes.
Date Posted: 09 Oct 2020 at 3:32pm
Hi all
I'm using Crystal report in VS2019
I currently have a main report with 4 subreports in the page header.
These reports conatin all orders for a current week, each subreport organizes orders by category.
Subreport1 category1 and so on.
Now what I would like to do is when the date changes a new page is displayed with the orders that belong in that day.



Replies:
Posted By: lockwelle
Date Posted: 12 Oct 2020 at 10:45am
Since it is in the page header, you do not have an option that I can see.

What I would do, and hopefully this makes sense for the report, is to create a group based on the date.

Put all of your subreports into the group header. Now, on the first group header (I am assuming that there are multiple group headers, 1 for each subreport) you can either check the box in the Section Expert for a New Page Before or you can put this code in the formula for that option: Not OnFirstRecord

The code just saves the first page from being blank.

HTH


Posted By: JRCharlie
Date Posted: 14 Oct 2020 at 4:59pm
Thanks Lockwelle for your reply.
I have the page break working by grouping they date in the subreport and then under the page will print Ichoosed for each day, and in option Iplaced acheck mark in new page after 1 visable group.
This seam to work.



Print Page | Close Window