December 6, 2016 at 8:24 am
Hello - I've looked through the questions, and I want to confirm my understanding (mostly because I can't believe I can't do this!). I have multiple datasets, each of which compute metrics of performance for individuals in the office. I need to show those metrics in multiple grids, one page per individual. In my readings here, I have seen two possible solutions, neither optimal. First, create a giant dataset which has all the data points for each individual, and then do something funky with tables stuffed into the cells of some overarching table to create the desired presentation layer; or create a report with multiple sub-reports - and I'm not sure that would yield the desired presentation layer. I'm thinking that the giant dataset is really my only option.
Would you all say that's an accurate assessment? I'm by no means an ssrs expert (although not a complete noob), so it's worthwhile to ask. Thank you for your time!
Donna
December 6, 2016 at 8:43 am
From you initial description, I assume that you've created a separate dataset for each employee? What happens if an Employee leaves, or joins? You'd have to update the report (not ideal!).
Yes, one big dataset is the best option for this. Simply ensure that one of your fields has the name of the employee. You can then insert a table/list item onto your report, and set that to group on your Employee name. In the properties of that grouping, you can also set it to insert a new page at each item.
Then simply put your elements inside the Table/List item, and each page will only show the details for the employee.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
December 6, 2016 at 9:44 am
I created a base view with a parm so that one/multiple employees could be chosen, then each dataset pulls in the specified employee(s) data. So, no changes required when people come and go. I created a separate dataset for each METRIC, not each employee.
I'm in the process of taking each of my metric datasets and left joining them to the base table to create one big dataset and then go from there.
I'm thinking I'll have to create one table and then fool with tables within the cells of the page-size table to get it to show all the grids on one page for each employee.
Y'know, you get these presentation layer spec's created in Excel and it all looks so easy...
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply