How to align different Tablix in SSRS

reporting-services ssrs-2008 ssrs-2008-r2 ssrs-tablix ssrs-grouping
SqlLearner picture SqlLearner · Jul 10, 2014 · Viewed 10.5k times · Source

I have a SSRS report in which i need to align multiple tablix in same Order as i need to export to EXCEL

The other tablix's is just a copy of the first tablix with only change of data set.But all the tablix will have same Columns.I need to align each column to the respective column in the other tablix. Can anyone help me in this?

After exporting in to excel,column1 of Tablix1 is not in Sync with Column1 of Tablix2,they are created in different Columns in Excel.

Answer

lethaljd picture lethaljd · Jul 10, 2014

I don't think you can do what you are proposing with two separate tablixes. I may be wrong, but I think you would need to change the underlying dataset or query being used to return the data (probably need to do a UNION or something) and display all of the data in the SAME tablix, which shouldn't be a huge problem since you are using the same columns. If you do it this way, you would use your row groupings to effectively section of the tablix so that the data has some separation.

Related questions

How to hide parameter based on another parameter value in SSRS

Hi I have 2 parameters param1 and param2. param1 has values true and false.my requirement is if i select true in param1 then param2 should be hidden and if i select false in param1 then param2 should be visible. can …

Read More
how to display multivalued parameter value in SSRS text box

I am having a multivalued parameter 'client',i have almost 60 values in the client parameter,my requirement is display the selected client values in the header text box but when i select 'SELECT ALL' option in the parameter i should …

Read More
Interactive sorting In SSRS on Values - Matrix report

I want a interactive sorting in SSRS matrix report. From database we are getting 3 columns -PrimaryKey,Columns and Value. We are grouping rows by Primary Key and grouping column by Columns and use Value as data. My Matrix Report - …

Read More