Seperate paramaters for 3 tablix in Same report

  • Hi All,.

    I have a report with 3 different table in one Report.I would like to add parameters to each table.

    I want to add separate parameters for each table.Is that possible in SSRS...? If so how can I implement it..?

    When I download to excel,I want each table in 3 different tabs in excel. Is that possible.? If so how ..?

    Thanks for your help.

  • Parameter Question. a parameter does not have to apply to any tablix in a report, so you could have parameter 1 filter only tablix 1, and then parameter 2 only filter tablix 2, and parameter 3 only filter tablix 3. Just create your parameters, and then add a filter to each tablix (alternately, if each tablix comes from a different dataset, you could filter the datasets).

    For the Excel Worksheets / tabs item, please see:

    http://blogs.msdn.com/b/robertbruckner/archive/2010/05/16/report-design-naming-excel-worksheets.aspx

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply