[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 530
  • Last Modified:

line counter page brake - crystal report

The report I have shows all students in a school with totals, Grouped by School having each school in new page....

Problem: The last student shown as last record for tha school and  the total is printed on the next page

How can the report force to print the last student record for that school to
next page with its total

Hope this makes sense....

I tried :
WhilePrintingRecords;
Shared Numbervar Linecounter;
Linecounter := Linecounter + 1;
If Linecounter = 33 and pagenumber<>totalpagecount and {SchoolCode} <> Next({SchoolCode})
then
(Linecounter :=0; True) Else
False

Did NOT work...
0
mercybthomas74
Asked:
mercybthomas74
  • 10
  • 8
1 Solution
 
mercybthomas74Author Commented:
Added the above formula in the Detail - section expert  under New page After, did not work
0
 
mlmccCommented:
Do you always want the last student to print on the next page or only when the total is forced to the next page?

The NEW PAGE AFTER runs after the detail line is printed.

What result are you getting?

What result do you want?

mlmcc
0
 
mercybthomas74Author Commented:
I only want print the last student to print only when the total is forced to the next page

0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
mlmccCommented:
Where do you print the total?
Which section?

So if there are 33 students there is room on the page for the total, just if there are 34 then you must put 1 student on the next page or if there are 33 students then the total ends up on the next page?

If 33 forces the total to the next page the change it to 32.

mlmcc
0
 
mercybthomas74Author Commented:
the total is printing on Group Footer, I changed it to 32 still no change
Detail-Section---GF.docx
0
 
mlmccCommented:
Can you upload the report itself?

mlmcc
0
 
mercybthomas74Author Commented:
here is the report...

Participant-Extract.rpt
0
 
mercybthomas74Author Commented:
any luck...
0
 
mlmccCommented:
Is that the last page of the report?

Are there 32 lines printed on that page?

Without the data it is hard to see what is going on.

mlmcc
0
 
mercybthomas74Author Commented:
attached is the rpt with data, school 039 is one good example...
ReportExecution-test.pdf
0
 
mlmccCommented:
Can you attach the RPT file with saved data?

mlmcc
0
 
mercybthomas74Author Commented:
I send you the rpt with data in a pdf format....
0
 
mlmccCommented:
I can read it but not manipulate the formulas.

mlmcc
0
 
mercybthomas74Author Commented:
i have the report attached above see... 03/15/11 02:28 PM, ID: 35141558
0
 
mlmccCommented:
I know, but there is no data in it.

You can set a flag to save data with the report
Standalone version is under the FILE menu.

mlmcc
0
 
mercybthomas74Author Commented:
rpt with data
Participant-Extract.rpt
0
 
mlmccCommented:
Check the attached report

mlmcc
Participant-ExtractRev.rpt
0
 
mercybthomas74Author Commented:
partially
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 10
  • 8
Tackle projects and never again get stuck behind a technical roadblock.
Join Now