forum.venkateswarlu.net
      Register      Login
How to Display multiple queries in a single SSRS report

3 replies to this topic

Kalyan Suman #1
Member
150 Points
 Posted on 09 Sep 2015 07:36 PM IST

I want to display single report with multiple quries

My Task is I have Dropdown : EMP, STUDENT,DEPT these are dropdown select values

if i choose EMP  related  employee report will be appear

eg: select * from EMp

if i choose DEPT department report will display

pls suggest me how to design this report

Thanks in Advance
Kalyan

 
SSRS     1078 views     Reply to this topic
Jahnavi N #2
Member
164 Points
 Replied on 10 Sep 2015 02:55 AM IST I think you cannot change the report structure dynamically to show different tables data based on selection.

Instead of, you can do one thing...
By default add all the Tables in Report, change Visibility property of the Table to Expression for all tables (EMP, STUD, DEP)

Visibility (ex. for displaying only EMP table)
= IFF(DropdowncontrolID.Value=="EMP",true,false)

Hope this may give some idea for you.
 
Reply to this topic
Kalyan Suman #3
Member
150 Points
 Replied on 10 Sep 2015 05:09 PM IST

Thanks for ur suggestion


even this method i try but its coming error

 
Reply to this topic
Kamalesh Kumar #4
Member
30 Points
 Replied on 18 Feb 2016 01:13 PM IST SQL Server news Services 2008 R2 has introduced a replacement operate known as “LOOKUP”. operation operate is employed to retrieve the worth from multiple datasets supported one to one mapping. for instance if we've got 2 datasets and each the datasets have EmpID thus supported the EmpID mapping, we are able to retrieve the info from each the datasets. 
Reply to this topic