Click here to Skip to main content
15,851,319 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
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 never displayed the result of the first proc.

What I have tried:

Msdn search, Google search, adding a second dataset
Updated 14-Feb-17 0:28am

1 solution

Instead of subreports
you can use two data sets in a report using
LookUp Function

For Example, Here First Data Set(Data Set1) returns the Book Type
Second Data Set : It returns the Title Belongs to the BookType

So, The LookUp function in ssrs should be

Look Up(BookType,BookType,Title,"DataSet2")
Share this answer

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900