Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

SSRS List with a permanent group value Expand / Collapse
Posted Tuesday, May 6, 2014 11:14 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, June 13, 2014 12:25 PM
Points: 2, Visits: 11
Afternoon. I am trying to create a list in SSRS that retains a permanent group value. I created my data to have the independent Employernames and values along with the total for each Case for an employername called BookofBusiness, I am hoping to go through the list of employers names with a graph that always has the Employername = x and the employername= BookofBusiness for each. I thought a list with a graph and some how get the BookofBusiness as a permanent would be the easiest. Process. Help is appreciated and thanks in advance.

Employername Date CaseType Count
ABC Company 1/2014 Registration 65
DEF Company 1/2014 Registration 60
BookOFBusiness 1/2014 Registration 125

1. I created the list grouping on employername
2. Created the graph group on Employername
3. ......
Post #1568104
Posted Friday, May 9, 2014 7:54 AM


Group: General Forum Members
Last Login: Saturday, October 1, 2016 3:04 PM
Points: 156, Visits: 348

Maybe You can add a new column to group the detail data and the summed data
and then use this column as your first grouping in the graph?

Post #1569280
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse