When I use 'add command' in my sub report, my dynamic parameter list shrinks.
Posted on 2008-10-20
I added the following command as a left outter join to my sub report:
SELECT Min([Date]) "Date", [customer id] "Customer Id"
GROUP BY [customer id]
Inside my subreport I have a dynamic parameter which gets its values from a table (not the command). Before I added the command, the list of values (as presented when you refresh the report) was over 300. Now that I have the add command in the sub report, it only shows me like 15 values.
Has anyone else had this happen before? If so any ideas what would cause it?