CODEWITHSUNDEEP
sql-serverexcelreporting-services
user2671286
user2671286

Reputation: 101

SSRS Report separate data into multiple sheets

I have a stored procedure that produces data for total sales for the month. I want to used the stored procedure to create a ssrs report, that separates each page by sales agents. The ssrs report will produce an excel workbook that with each tab in the book holding data for each rep for that month. How can I do this in SSRS?

Upvotes: 4

Views: 7271

Answers (2)

Doğukan Kazan
Doğukan Kazan

Reputation: 1

You can create pagination according to the parameters you specify by creating Rectangle objects one under the other.

For example, let's say your parameter is xParameter.

You should give visibility settings to your Rectangle objects as =IIf(Parameters!xParameter.Value = "1", False, True).

When you select number 1 in the parameter, you can show only Rectangle object number 1 and eliminate the others.

Upvotes: 0

Kalim
Kalim

Reputation: 485

You need to create a grouping on your tablix by sales agent.

Once you have the grouping follow these steps:

  1. Right click on the grouping
  2. Select Group Properties
  3. Select Page Breaks
  4. Check the "Between each instance of a group" option

This will split the workbook into tabs by sales agent. You can then name the tab after the sales agent as well by editing the Page Name in the Group properties pane. You will need to use a variable for this.

Upvotes: 2

Related Questions