Print Page | Close Window

How display last record

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
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=5105
Printed Date: 18 Apr 2024 at 7:17am


Topic: How display last record
Posted By: vinayak
Subject: How display last record
Date Posted: 29 Dec 2008 at 11:28pm
How can I display only last record in crystal report. using crystal report editor.
Plz tel me the formula. 


-------------
Vin


Replies:
Posted By: rahulwalawalkar
Date Posted: 30 Dec 2008 at 1:05am
Hi
 
Go to Details Section,Right Click Select Section Expert then in Common Tab
Suppress(No DrillDown) Click X+2 and enter the Code below
 
Not OnLastRecord
 
Cheers
Rahul

Posted By: vinayak
Date Posted: 30 Dec 2008 at 1:52am
Hi,
 
I am using Version 8.5 of crystal Report. In that there is no option for Expert Section after write click Of Details.
 
I want to show last record of perticular field in report header. I don't want to read all data present in database file.


-------------
Vin

Posted By: rahulwalawalkar
Date Posted: 30 Dec 2008 at 2:32am
Hi
 
There is something called as Format Section..............then common tab then X+2 then enter the code........
 
About not reading  the entire database ,i will use SQL it is for Sql Server 2000
 
select TOP 1 * from table ORDER BY fieldname DESC
 
I am not sure how you add SQL in Crystal 8.5 for version 9 and above we use command object to do that....
 
cheers
Rahul

Posted By: vinayak
Date Posted: 30 Dec 2008 at 3:31am

Hi,

thank's.....

 But Sql query can't write  in this Crystal report. Plz. Tell me how can I show the addition of these last records? 



-------------
Vin


Print Page | Close Window