Hi,

Thank you letting me join the forum. I am having an issue with a table that the two fields that I use to select the needed data, bring back a result for the "reference" field having various kinds of data available. In this example will say I get 2 rows of data were the "reference" field/column has different numbers.

When I use that field into the report, it prints multiple pages because that field alone has more than 1 row of data. Since there is no differentiating factor other than the "reference" field information, how can I have the report just select the first random field to display, then ignore the rest?

company_id    warehouse_id    invoice_number    reference

abc                  USA1                   I8045760             0000528439

abc                   USA1                   I8045760           634966131341215125.7344.3265786@BTKAPPP02

Edited by alfredsf - 07 Aug 2013 at 11:09am

The question that comes to mind is, what is in the details?

For the detail section of the report, do you need to see different data...like part numbers on an invoice, or would the reports for the multiple records be identical?

If they are identical, consider moving the 'report' to a group header or footer, as these only print out once per group, and suppress the detail section.

If you are using a stored proc to gather the data for the report, you could do the final select as a SELECT DISTINCT.

Hope one of these is useful for you.

top 1 won't work if you have 2+ different records that you want to see.

you could also try suppress if duplicated...though I have only used that in the detail section and not the grouping.

Usually, SELECT DISTINCT is the 'simplest' way to go, I would think