Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: How display last record Post Reply Post New Topic
Author Message
vinayak
Newbie
Newbie
Avatar

Joined: 29 Dec 2008
Location: India
Online Status: Offline
Posts: 8
Quote vinayak Replybullet Topic: How display last record
    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
IP IP Logged
rahulwalawalkar
Senior Member
Senior Member
Avatar

Joined: 08 Jun 2007
Location: United Kingdom
Online Status: Offline
Posts: 731
Quote rahulwalawalkar Replybullet 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
IP IP Logged
vinayak
Newbie
Newbie
Avatar

Joined: 29 Dec 2008
Location: India
Online Status: Offline
Posts: 8
Quote vinayak Replybullet 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
IP IP Logged
rahulwalawalkar
Senior Member
Senior Member
Avatar

Joined: 08 Jun 2007
Location: United Kingdom
Online Status: Offline
Posts: 731
Quote rahulwalawalkar Replybullet 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
IP IP Logged
vinayak
Newbie
Newbie
Avatar

Joined: 29 Dec 2008
Location: India
Online Status: Offline
Posts: 8
Quote vinayak Replybullet 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
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.