Suppress Printing of Repeated Values in Report Detail Band

  • Thread starter Thread starter Mike Thomas
  • Start date Start date
M

Mike Thomas

I have a query which joins 2 tables to produce the following recordset.

Receipt.ID Receipt.Quantity Po.ID PO.Quantity
1 10 6 3
1 10 7 4
1 10 8 3
2 15 11 5
2 15 12 6
2 15 13 4

These rows form the detail band of a report. I want the detail lines to
appear as below. Eg, I want to suppress the Receipt.Quantity in lines 2,3,
5 and 7. I don't want to use grouping - I want the report to appear as
below:

Receipt.ID Receipt.Quantity Po.ID PO.Quantity
1 10 6 3
1 7 4
1 8 3
2 15 11 5
2 12 6
2 13 4

Something needs to be done in the detail band's format event. What is a
sound way to test whether the current detail record's receipt.ID is
different from the previous detail record's Receipt.ID?

Thanks
Mike Thomas
 
Hi Mike.
You cna achieve this by setting the hide duplicate value
property to yes. This is a property of the textbox.
Hope this helps.
Fons
 
Thanks Fons - that approach can cause problems - sometimes values which
appear to be duplicates are really valid values - what if the quantity on
one line was 100, and the next line's quantity were also 100, even though
the ID key had changed? The second 100 would not print, even though it
should print.

Thanks
Mike Thomas
 
The way to prevent this is set the underlying query to
unique values only, this way if any field within the data
line changes the record will be displayed.
Take care.
Fons
 
Back
Top