Comparing and Suppressing the records 1

[cdnamm]

Hi all,
I need to suppress the records if the Dates of Service in the detail line are not the same. Could anyone help me?
Thanks!

 

[LV]

Right-click on &quot;Details&quot; section, Format Section...click on the pencil button next to &quot;Suppress (No Drill-Down)&quot; label. In the Format Formula Editor enter: table.date1 <> table.date2
This will suppress detail section when dates are not equal.

 

[cdnamm]

Hi LV,
The Date1 and Date2 as you referred are actually one field (Date of service (DOS)). Since, I can have multiple DOS on the detail line and I want to suppress the detail records with different DOS. Therefore, I can't use your suggestion.
Do you have any other suggestion for me? Thank you in advance!
cdnamm

 

[LV]

You mean, you want to compare a previous value to a current one? Otherwise, how do you get multiple values of the same field displayed on the same detail line item?

 

[cdnamm]

Hi LV,
Yes, I want to compare the previous to the current.
Thanks!

 

[synapsevampire]

Try posting sample data and desired output.

If you mean that you want only the first date for a group of rows, try something like the following in the suppress formula for the detail:

previous({MyTable.ServiceDate}) <> {MyTable.ServiceDate}

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[cdnamm]

Hi,
Here is an example of the data

Group by Claim Number
200000190902 (Claim Number)
DOS copay
08/11/2002 $10.00
08/11/2002 $10.00

200000184543
DOS copay
09/12/2002 $5.00
11/05/2002 $9.00

I wanted to suppress the group header where the DOSs are different.
Thanks

 

[heppme]

Add a distinct count total on the date field. Then go into Format Section on the group header and add a formula like this:
if DistinctCount ({table_name.dos}, {group}) > 1 then true
else false
Hope this helps.

 

[cdnamm]

Hi slizzo,
I tried your way and it worked!
Thanks!
cdnamm