Controlling Page Breaks on Groups

[shelby55]

Hi

I am using Crystal 8.5 accessing a SQL database.

I am grouping on account number and placing data for each account number in the details section.

Only so many records can fit on one report - how do I format so that a new page is inserted where I want? Thanks.

 

[lbass]

Please explain what you want to happen as compared to what is happening. I can't tell what the problem is that you are hoping to address.

-LB

 

[shelby55]

Hi

Sorry. I don't have the data in a sequential line, I have it showing one big area with data elements actually split by a separate detail section per area of demographics, ambulance, triage, service provider and departure.

It looks like this:
DEMOGRAPHICS
Account Number Registration Date
Residence Code Postal Code

AMBULANCE
Admit via Ambulance:
Ambulance arrival date: Ambulance arrival time:

etc.

Based on this format, only 2 account numbers can be on the same page and I want to force a new page after 2. Thanks.

 

[lbass]

If these are separate detail sections, does this mean each acocunt number with all corresponding data is one row in the database? If so, you should be able to force a page break just by formatting the detail section to new page after with this formula:

remainder(recordnumber,2) = 0

-LB

 

[shelby55]

Hi LB

Where do I put this formula - in the group footer? I ask because it's not working.....

 

[lbass]

Go into the section expert->details->new page after->x+2. But this assumes you have one row per account ID. If there are more, you need to explain the report structure->what you are grouping on, etc.

-LB

 

[shelby55]

Hi LB

No, I don't have one line per data in the report. I have as I described above:

DEMOGRAPHICS
Account Number Registration Date
Residence Code Postal Code

AMBULANCE
Admit via Ambulance:
Ambulance arrival date: Ambulance arrival time:

Etc. for the other sections

Each section is a detail section and the above is for a single account number.

Thanks.

 

[lbass]

What do you mean by "each section is a detail section"? If you are using detail_a, detail_b, etc. to arrive at this display, then the information is all coming from the same row.

Please show a sample of how the fields display if you place them all in the same detail section.

-LB

 

[shelby55]

Hi LB

Sorry but I'm not sure what more you require from me to assist - you are correct that I'm using detail_a, detail_b etc. You are also correct that in the database, each line of data is one unique account number.

The format is as I've laid out for you:

DEMOGRAPHICS
Account Number: Registration Date:
Residence Code: Postal Code

AMBULANCE
Admit via Ambulance:
Ambulance arrival date: Ambulance arrival time:

but with data after the colons. Demographics is one detail section, Ambulance is another, etc. for 3 more sections.

Thanks.

 

[lbass]

If there is one row per account ID, then my first formula probably would have worked, but try this instead (assuming you have only one group (on account ID):

In the section expert->group footer->new page after->x+2, enter:

remainder(groupnumber,2) = 0

-LB