Skip to Content
0
May 13, 2010 at 05:29 PM

Results Multiplied When Using Command Data Sources

36 Views

I'm using Dynamic (Non-Cascading) Parameters on two fields, either of which may have a NULL or Empty String. Since I want the user to also be able to select those Null/ES values specifically as well (and they only show up in a "regular" Dynamic parameter prompt as a blank space), I'm using a Command Data Source (CDS) to display the unique field values as well as to substitute "!Unknown" for the Null/ES entries - this works fine in other reports.

When I run the report with the CDS-based parameters, I get multiple records back where there should only be one. When I replace the CDS-based parameters with a "regular" Dynamic parameter based on the same fields, and select Distinct Records Only, I get the correct number of records back. I am unable to select Distinct Records Only when I use the 2 CDS.

I am only (inner) joining 2 tables and not joining the 2 CDS.

Thanks for any assistance 😊