Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: Duplicate data Post Reply Post New Topic
Author Message
dldatacoord
Newbie
Newbie


Joined: 10 Apr 2007
Location: United States
Online Status: Offline
Posts: 3
Quote dldatacoord Replybullet Topic: Duplicate data
    Posted: 10 Apr 2007 at 9:09am
I have a formula that looks first for values that begin with "ABC" and then looks for value of testing "123" with a timestamp attached to that value.
I am getting duplicate results of the value of "123" due to the fact that I have an "ABC.01" and an "ABC.02".
 
For example:
1.  ABC.01
     a.  4/10/07 10:00am       6.5
     b.  4/10/07 10:00am       6.5
     c.  4/10/07  11:30am      6.8
     d.  4/10/07  11:30am      6.8
 
When I look to the original data file, 1. also has the value of ABC.02
 
My formula is as follows: {...}="123" and {.....} startswith "ABC" and {...timestamp} in DateTime (  ) to DateTime (   )
 
Any ideas on how I can have this show the values of 123 only once?
dls
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3701
Quote hilfy Replybullet Posted: 10 Apr 2007 at 10:42am
Do you want the earliest or latest timestamp for "123"?  Are you grouping on "ABC"?
 
Set up a group on "ABC" (if it doesn't already exist in your report), then either sort (if you don't need further groups) or group on "123" after the "ABC" group.  Set up the new sort or group to be either ascending or descending, depending on whether you want the first or last value.  Then put the information for "123" in an "ABC" group header section instead of in a detail section. 
 
If I understand your problem correctly, this should work.  If not, please post an example of how the data should look and I'll see what I can come up with for you.
 
-Dell
IP IP Logged
dldatacoord
Newbie
Newbie


Joined: 10 Apr 2007
Location: United States
Online Status: Offline
Posts: 3
Quote dldatacoord Replybullet Posted: 10 Apr 2007 at 10:51am
I want one of each, because they have different results attached.  What I don't want is two of each.
dls
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3701
Quote hilfy Replybullet Posted: 10 Apr 2007 at 10:54am

Ok, I've got it....Group on the timestamp after the group on the "ABC".  Put your timestamp data in the timestamp group header.  This should get you just one copy of it.

 
-Dell
IP IP Logged
dldatacoord
Newbie
Newbie


Joined: 10 Apr 2007
Location: United States
Online Status: Offline
Posts: 3
Quote dldatacoord Replybullet Posted: 10 Apr 2007 at 10:57am
I am not grouping on ABC, because I don't want the results of 123 to be separated by ABC.01 and ABC.02.
 
ABC.... is a filter to select which data to look at.
 
The data to be pulled has 4 qualifying pieces.
It first must come from site #1
Second, it must have a qualifier which begins with ABC
Third, I am looking for test 123 to have been run
Fourth, I want the values for test 123 each time that it was run.
dls
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3701
Quote hilfy Replybullet Posted: 10 Apr 2007 at 11:08am
However, you CAN group on a formula:
 
Left({table.qualifier}, 3)
 
This will get you the first three characters of the field - hence your "ABC".  Which would put them all together.
 
However, you may not even need that group since you want them all combined.  In which case, you just group on the timestamp.
 
-Dell
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.