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?

 

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

 

-Dell

 

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.

 

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