Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSRS List with a permanent group value Expand / Collapse
Author
Message
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.

Data
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
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, June 6, 2014 7:41 AM
Points: 41, Visits: 165
Hi

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