Home > SSRS > Multiple Tablix Reports in Main Report, Show Particular Report(Tablix) based on Reportname input parameter

Multiple Tablix Reports in Main Report, Show Particular Report(Tablix) based on Reportname input parameter

Create one Report, Add Three Tablix into the report

Create three Datasets for each Tablix.

Add ReportName as Column having the report name value in each dataset.

I have created three Datasets as described below:-

1)      Dataset FruitDS :-

Select * from

(

select 1 id,’Apple’ Fruit,’FruitReport’ ReportName

)t

where t.ReportName=@ReportName

 

  • Dataset ObjectDS :-

 

select * from

(

select 1 id,’Computer’ Object,’ObjectReport’ ReportName

)t

where t.ReportName=@ReportName

  • Dataset CountryDS:-

 

select * from

(

Select 1 id, ‘India’ Country,’CountryReport’ ReportName

)t

where t.ReportName=@ReportName

 

Create one more Dataset having All Report Names as given below:-

 

 

Select   ‘FruitReport’   ReportName

union

Select   ‘ObjectReport’   ReportName

Union

Select   ‘CountryReport’   ReportName

 

 

 

In First Tablix visiblity condition write below expression:-

=iif(Parameters!ReportName.Value=”FruitReport”,False,True)

VisibilityCondition

Do same for rest three tablix

 

 

 

 

Run the Report as CountryReport selected

CountryReport

 

Run the Report as FruitReport selected

FruitReport

RDL:- MulipleReport

Thanks
Prasad

Learn Different BI Tools
Subscribe my YouTube Channel : BI Tools

Advertisements
Categories: SSRS Tags:
  1. VJReddy
    February 24, 2015 at 3:25 pm

    till 5 th or 6th tablix you may not get much blank space,but when u still have more say 20th tablix you will observe blank space to seek 20th tablix.

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: