Hi everyone,
I am using CR XI with VS2005. I have a report that gets data from a stored procedure. I added a dynamic parameter to allow users to pick from a list the data they want to see. The data soruce of this parameter is a report field returned by the stored procedure.
The problem is I'm only getting a partial list of data. For example, the stored procedure returns 100 product IDs, and I use this report field as data source for the dynamic parameter, it will only show30 or so in the list.
I tried this on some other reports and sometimes it will return only either a partial list or the first value.
Have anyone encounter this same problem?
Any advice appreciated.
thank you,
ss