Answered by:
export ssrs report in excel in multiple sheets

Question
Answers
-
Hi Dilip,
In order to achieve your requirement, we can use a list to contain the matrix, then add a page break between each instance of the column group. For more details, please refer to the following steps:
- Drag a list to contain the matrix, and the set the dataset of the list to current dataset.
- In the Row Groups pane, right-click the Details group to add a group grouped on the expression below:
=IIF(Fields!column_group_field.Value="LOAN",”LOAN”,”Others”)
- Click the Details group to navigate to Properties Windows.
- Expand the PageBreak group to set the BreakLocation property to Between.
- Use the same expression to set the PageName property:
=IIF(Fields!column_group_field.Value="LOAN",”LOAN”,”Others”)
Then the yellow marked column and green marked columns will be in two sheets in Excel.If there are any other questions, please feel free to ask.
Thanks,
Katherine XiongKatherine Xiong
TechNet Community Support- Marked as answer by Dilip Patil Wednesday, March 26, 2014 11:24 AM
- Unmarked as answer by Dilip Patil Wednesday, March 26, 2014 11:24 AM
- Marked as answer by Dilip Patil Wednesday, March 26, 2014 11:24 AM
- Drag a list to contain the matrix, and the set the dataset of the list to current dataset.
All replies
-
Create multiple tablix for each dataset in the report having a page break between them. With this it will allow you to export in multiple sheet.
I don't think using only one parameter will work, as you have said you do not need as a group. i.e 2 parameters for 2 Excel sheet(1:1). If a single parameter is used to filter multiple tablix then this will much easier and the above option can be apply directly.
Regards, RSingh
-
You can create a dummy grouping based on parameter values and then export to excel. Inside your container add a grouping based on selected parameter values (if its static you can even give values as is) and then you can select property insert page break after
see
http://visakhm.blogspot.in/2013/10/using-ssrs-to-export-sqlserver-data-to.html
Please Mark This As Answer if it helps to solve the issue Visakh ---------------------------- http://visakhm.blogspot.com/ https://www.facebook.com/VmBlogs
-
-
Hi Dilip,
In order to achieve your requirement, we can use a list to contain the matrix, then add a page break between each instance of the column group. For more details, please refer to the following steps:
- Drag a list to contain the matrix, and the set the dataset of the list to current dataset.
- In the Row Groups pane, right-click the Details group to add a group grouped on the expression below:
=IIF(Fields!column_group_field.Value="LOAN",”LOAN”,”Others”)
- Click the Details group to navigate to Properties Windows.
- Expand the PageBreak group to set the BreakLocation property to Between.
- Use the same expression to set the PageName property:
=IIF(Fields!column_group_field.Value="LOAN",”LOAN”,”Others”)
Then the yellow marked column and green marked columns will be in two sheets in Excel.If there are any other questions, please feel free to ask.
Thanks,
Katherine XiongKatherine Xiong
TechNet Community Support- Marked as answer by Dilip Patil Wednesday, March 26, 2014 11:24 AM
- Unmarked as answer by Dilip Patil Wednesday, March 26, 2014 11:24 AM
- Marked as answer by Dilip Patil Wednesday, March 26, 2014 11:24 AM
- Drag a list to contain the matrix, and the set the dataset of the list to current dataset.
-