Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: If Else returns correct value but multiple records Post Reply Post New Topic
<< Prev Page  of 2
Author Message
RRushing
Newbie
Newbie
Avatar

Joined: 10 Jan 2011
Location: United States
Online Status: Offline
Posts: 14
Quote RRushing Replybullet Posted: 15 Feb 2011 at 5:34am
hey DB
 
 
no
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 15 Feb 2011 at 5:36am
maybe I am not undersatnding what you want.
can you post a few smaple data rows and explain what you want to include and exclude and why?
IP IP Logged
RRushing
Newbie
Newbie
Avatar

Joined: 10 Jan 2011
Location: United States
Online Status: Offline
Posts: 14
Quote RRushing Replybullet Posted: 15 Feb 2011 at 5:44am
Hey DB
 
not a problem
 
I want to show all equipment numbers whether there is a XREF# or not.
 
I can show all equipment numbers but since the UserDefinedSeq field hold 2 seq #'s for Alpha info, I get 2 rows for those pieces of equipment with a XREF#.
 
the 2 seq codes are "000016" and "000070". The data stored in the Alpha field contains "assigned to" data and xref data. I just want to see xref data.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 15 Feb 2011 at 5:50am
so you want this
EQ#        Seq#        XREF#
1000       000018
1000       000070    3056
to look like ?
EQ#          XREF#
1000          3056
IP IP Logged
RRushing
Newbie
Newbie
Avatar

Joined: 10 Jan 2011
Location: United States
Online Status: Offline
Posts: 14
Quote RRushing Replybullet Posted: 15 Feb 2011 at 5:52am
hey DB
 
 
yes but also list those equipment #'s that do not have a xref#
 
 
Rick
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 15 Feb 2011 at 5:55am

forget the select statement

group on EQ
assuming you only have one xref value per eq that you want to display insert a summary (sigman sign) of the xref value as a MAXIMUM at the EQ group level. move that value from the group footer to the group header
suppress detail section completely
IP IP Logged
RRushing
Newbie
Newbie
Avatar

Joined: 10 Jan 2011
Location: United States
Online Status: Offline
Posts: 14
Quote RRushing Replybullet Posted: 15 Feb 2011 at 6:02am
hey DB
 
BINGO!
 
 
thanks a bunch. Learned a new trick here.
 
 
sincerely
 
Rick
IP IP Logged
<< Prev Page  of 2
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.