I inherited an ssrs report that calls two stored procedures,
The first proc executes and returns a value called book_type.
The second proc executes with the value assigned to book_type. So, if book type = autobiography, the second proc returns all the autobiography titles.
The rdl currently includes a Subreports that displays the results of the 2nd proc.
Is there a way to include a second table and dataset instead of a Subreports?
When I tried this, I was always prompted to enter the book_type...it never displayed the result of the first proc.
What I have tried:
Msdn search, Google search, adding a second dataset