Print Page | Close Window

The first and the last row on a page

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=10952
Printed Date: 08 May 2024 at 12:16am


Topic: The first and the last row on a page
Posted By: bienmaixanh
Subject: The first and the last row on a page
Date Posted: 24 Aug 2010 at 10:32pm
I have a report to display Item name, quantity
I need report like that

First page
---------------------------
Item Name, Quantity
A                     5
B                     6
C                     7
Continuous...
----------------------------
next page
-----------------------------
Item Name, Quantity
Continued previous page.......
D 5
C 5
D 3

Please help me to do that. Thanks in advance

< id="gwProxy" ="">< ="jsCall();" id="jsProxy" ="">


Replies:
Posted By: Senthil Raj
Date Posted: 25 Aug 2010 at 1:12am

that will come automatically when record is more

do u have any constrains in number of records per page or any else

 

Posted By: bienmaixanh
Date Posted: 25 Aug 2010 at 4:41pm
How to display text "Continuous..." on last row of a page
and on the first row of the next page "Continued previous page......."
< id="gwProxy" ="">< ="jsCall();" id="jsProxy" ="">
< id="gwProxy" ="">< ="jsCall();" id="jsProxy" ="">

Posted By: Senthil Raj
Date Posted: 25 Aug 2010 at 8:03pm
you create 2 formula field
 
1. cont_head
 
if (not onfirstrecord)=true then
"Continued previous page......."
and place this field in Page Header
 

2.cont_foot

if (not onlastrecord )=true then
"Continuous..."
and place this field in Page Footer

 

this wil help You

Posted By: bienmaixanh
Date Posted: 25 Aug 2010 at 9:33pm
Thank for your help but.
 I have to put Continuous... and "Continued previous page......."in the detail section because this note will be an Item Name except two cases.
So I do it as follow. I add one formula
I tell my Formula that
if you on the last row of a page and this report has next page you will be "Continuous..."
If you on the first row of a page and this report has previous page, you will be "Continued previous page......."
else you will be Item name
The problem I do not know when the record is on the first or the last row of a page
Please help me.
< id="gwProxy" ="">< ="jsCall();" id="jsProxy" ="">

Posted By: Senthil Raj
Date Posted: 26 Aug 2010 at 9:00pm
Fine..
if  you want to use it in detail section then you have 1 option that , you can restrict number of rows in detail section as 20 or 25 and using the count you can use the formula if that count=20 or 25 then like that

Posted By: bienmaixanh
Date Posted: 27 Aug 2010 at 3:30pm
Thanks very much member_profile.asp?PF=10645&FID=7 - Senthil Raj  


< id="gwProxy" ="">< ="jsCall();" id="jsProxy" ="">


Print Page | Close Window