Found a Solution
Hi Michael,
Thank you for your help...
Found a solution:
1. Data issue (changed SQL query to hand;e empty string,nulls)
2. Created a dataset for dynamic parameters passed to report
3. Linked new dataset returning report parameters to one main dataset.
4. Changed date type returned from SQL to String
Still could not figure out why the report was failing when it was pulling data when 3 set of parameters were combined. If report was run seperately for each set of parameter...it was fine. Thanks for your support.
regards,
Shirish
|