Solved

line counter page brake - crystal report

Posted on 2011-03-15
18
526 Views
Last Modified: 2012-05-11
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
Comment
Question by:mercybthomas74
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 10
  • 8
18 Comments
 

Author Comment

by:mercybthomas74
ID: 35138868
Added the above formula in the Detail - section expert  under New page After, did not work
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 35138979
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
 

Author Comment

by:mercybthomas74
ID: 35139214
I only want print the last student to print only when the total is forced to the next page

0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
LVL 101

Expert Comment

by:mlmcc
ID: 35139361
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
 

Author Comment

by:mercybthomas74
ID: 35141028
the total is printing on Group Footer, I changed it to 32 still no change
Detail-Section---GF.docx
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 35141466
Can you upload the report itself?

mlmcc
0
 

Author Comment

by:mercybthomas74
ID: 35141558
here is the report...

Participant-Extract.rpt
0
 

Author Comment

by:mercybthomas74
ID: 35141728
any luck...
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 35143470
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
 

Author Comment

by:mercybthomas74
ID: 35146920
attached is the rpt with data, school 039 is one good example...
ReportExecution-test.pdf
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 35150154
Can you attach the RPT file with saved data?

mlmcc
0
 

Author Comment

by:mercybthomas74
ID: 35150329
I send you the rpt with data in a pdf format....
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 35150466
I can read it but not manipulate the formulas.

mlmcc
0
 

Author Comment

by:mercybthomas74
ID: 35151590
i have the report attached above see... 03/15/11 02:28 PM, ID: 35141558
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 35151756
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
 

Author Comment

by:mercybthomas74
ID: 35232039
rpt with data
Participant-Extract.rpt
0
 
LVL 101

Accepted Solution

by:
mlmcc earned 500 total points
ID: 35307876
Check the attached report

mlmcc
Participant-ExtractRev.rpt
0
 

Author Closing Comment

by:mercybthomas74
ID: 35418081
partially
0

Featured Post

Enroll in June's Course of the Month

June’s Course of the Month is now available! Experts Exchange’s Premium Members, Team Accounts, and Qualified Experts have access to a complimentary course each month as part of their membership—an extra way to sharpen your skills and increase training.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
This video Micro Tutorial shows how to password-protect PDF files with free software. Many software products can do this, such as Adobe Acrobat (but not Adobe Reader), Nuance PaperPort, and Nuance Power PDF, but they are not free products. This vide…
There's a multitude of different network monitoring solutions out there, and you're probably wondering what makes NetCrunch so special. It's completely agentless, but does let you create an agent, if you desire. It offers powerful scalability …

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question