Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Filtering Report Post Reply Post New Topic
Author Message
gasta83
Newbie
Newbie
Avatar

Joined: 03 Nov 2014
Online Status: Offline
Posts: 1
Quote gasta83 Replybullet Topic: Filtering Report
     Posted: 24 Nov 2014 at 7:11pm
Dears , i'm still new for Crystal report and looking for assistance in how to solve my issue which is:

TID EVSeq Evlg Comment
125 1120 A Txt
125 1121 B Txt
125 1127 B Txt
125 1250 C Txt
125 1370 A Txt
150 1500 G Txt
150 1520 A Txt


I have one table with many records where i Have many "Comment " logged against "TID"  and i want to display only one line for each TID , where the EVSeq is the highest number and EvLg is different than A,
In My table example i want to display this line
1251250CTxt

1501500GTxt


Edited by gasta83 - 24 Nov 2014 at 7:12pm
IP IP Logged
z9962
Senior Member
Senior Member
Avatar

Joined: 04 Jul 2012
Online Status: Offline
Posts: 161
Quote z9962 Replybullet Posted: 25 Nov 2014 at 12:46am
a few ways to do this... one way
1. Create a group on TID
2. Sort by EVSeq in Ascending order
3. In select Expert exclude Evlg<>A
4. put the comment box in the Group Footer
5. Hide the details section
 
IP IP Logged
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