Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Data grouping/filtering Post Reply Post New Topic
Author Message
Zuzanna
Groupie
Groupie


Joined: 10 Sep 2010
Location: Canada
Online Status: Offline
Posts: 56
Quote Zuzanna Replybullet Topic: Data grouping/filtering
    Posted: 10 Sep 2010 at 10:05am
I am a new Crystal 9 user.
I have a report grouped by employee number showing number of fields for each employee one of them being effective date. One of the employees appears twice on the report. All field values showing on the line are the same as his previous line except the effective date is different (that's why he appears on the report). I want to hide this row since all information except the effective date is the same. Can this be done and how?
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 10 Sep 2010 at 11:17am
you can conditionally suppress the detail row using a formula
Next(employeeid)=employeeID and NExt(datefield)<>datefield
IP IP Logged
Zuzanna
Groupie
Groupie


Joined: 10 Sep 2010
Location: Canada
Online Status: Offline
Posts: 56
Quote Zuzanna Replybullet Posted: 13 Sep 2010 at 5:52am
Thanks, I created the following statement
 

NOT((Next({SJ000174.EMPLID}) =  {SJ000174.EMPLID}  And

Next({SJ000174.LAST_NAME})  = {SJ000174.LAST_NAME} And

Next({SJ000174.FIRST_NAME}) = {SJ000174.FIRST_NAME} And

Next({SJ000174.NATIONAL_ID}) = {SJ000174.NATIONAL_ID}  And

Next({SJ000174.LHS_DEPT_DESCR}) = {SJ000174.LHS_DEPT_DESCR} And

Next({SJ000174.LOCATION}) = {SJ000174.LOCATION} And

Next({SJ000174.REG_TEMP}) = {SJ000174.REG_TEMP}  And

Next({SJ000174.FULL_PART_TIME}) = {SJ000174.FULL_PART_TIME} And

Next({SJ000174.LHS_CONTRACT_DESCR}) ={SJ000174.LHS_CONTRACT_DESCR} And

Next({@POSITION TITLE}) = {@POSITION TITLE} And

Next({SJ000174.BUSINESS_UNIT}) = {SJ000174.BUSINESS_UNIT} And

Next({SJ000174.DEPTID}) = {SJ000174.DEPTID} And

Next({SJ000174.UNION_CD}) = {SJ000174.UNION_CD})

I am trying to select only rows where any of the field values are different. If all values are the same, exclude the row from the report. Being new to Crystal, I don't know how to set up the Selection Expert with this statement.

 

IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 13 Sep 2010 at 6:11am
you cannot use this in the select expert as NEXT() function runs after the data is selected. You can use it do to conditional suppression of the detail section.
In the section expert, select the detail section and click on the formul button nect to the suppress no drill down option.
Insert your formula there but get rid of your leading NOT as this suppresses based on a TRUE return from your formula so you want it to suppress when all those items are equal.
IP IP Logged
godwing
Newbie
Newbie


Joined: 13 Sep 2010
Online Status: Offline
Posts: 3
Quote godwing Replybullet Posted: 13 Sep 2010 at 5:28pm
Hi,

You may try to check your link fields. Incorrect link fields will result in duplicating fields.

regards,
IP IP Logged
Zuzanna
Groupie
Groupie


Joined: 10 Sep 2010
Location: Canada
Online Status: Offline
Posts: 56
Quote Zuzanna Replybullet Posted: 21 Sep 2010 at 7:05am
Thanks so much it worked. If you could look at my other Grouping problems I logged. I would greatly appreciate it.l
IP IP Logged
godwing
Newbie
Newbie


Joined: 13 Sep 2010
Online Status: Offline
Posts: 3
Quote godwing Replybullet Posted: 26 Sep 2010 at 9:27pm
Hi,

May I know what's your main objective here?

thanks,
IP IP Logged
Zuzanna
Groupie
Groupie


Joined: 10 Sep 2010
Location: Canada
Online Status: Offline
Posts: 56
Quote Zuzanna Replybullet Posted: 27 Sep 2010 at 3:40am
To eliminate duplicate rows from the report, where all field values except the eff date are the same.
Background info - I created a PeopleSoft query to select everyone who had a change of data on the name record. The user wants to see previous and new changed data on the crystal report. When the user enters the changes, they insert a new row with a new eff date. The name record  includes other fields beside the ones I am selecting. I hope this answers your question.
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.016 seconds.