problem with master/detail and distinct

rbuser

Report Builder Enterprise 11.03, Delphi 2007

Hi,

I have a report with two linked queries on the data tab. The master query
has duplicate values.
When I toggle "distinct" in the tables tab of the master query, I get the
following results in the preview:

master query (without DISTINCT):
A
A
A

detail query:
A(A)
A(A)
A(A)
B(A)
B(A)
B(A)

That's OK.

master query (with DISTINCT):
A

detail query:
A(A)
A(A)
A(A)
B(A)
B(A)
B(A)

But I expected, that the result set of the detail query should look like
this:
A(A)
B(A)

Any ideas?



Lars Hirthe

nicocizik

Hi Lars,

ReportBuilder simply uses the data that is returned by the query generated.
Try setting Distinct for the detail dataset as well to limit the number of
records returned.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com