I have 2 datasets. The query in the first dataset is executed and it gives the values to the report parameters. The 2nd dataset uses these parameters to execute the query and then get the data.
The problem is if the first query returns no data, then the report parameters are blank. When I see the preview of the report, it gives me an error saying
"One or more parameters required to run the report have not been specified".
What I want is, if the first query doesn't return any data, then the 2nd query should not be executed.
Can someone please guide me in achieving this?
Regards,
Asim.Rather than not executing the second query, perhaps you could try returning a default value if no rows are returned from the stored procedure?
No comments:
Post a Comment