Repeating entire report

Question

Repeating entire report

maxx.flavin

SSC Rookie

Points: 40
More actions
October 5, 2010 at 11:32 am

#387939

I have a report parameter where the user enters in the employee ID they wish to generate a report on. When they do this, the report generates just fine. I want to change this Employee ID parameter to a multi-value enabled, and have the report repeat itself in entirety for each EmployeeID selected, including several text boxes I have at the top of the report for each employee, which aren't part of the data displayed in the main table data for that employee. I can't figure out how to get it working for multiple though - it may be a fundamental flaw in the way I've got things set up, or I may just be stuck in a rut of thought I fear :\
Some of my text boxes near the top are using data from a different dataset than the table, but still basing it off the employeeID as entered by the user. Is this doable for multiple employeeIDs given at the report level - can ssrs intelligently cross reference them somehow? Or should I be repeating a data region somehow (I'm not familiar with how to do so).. Or do I just need to come up with a single DataSet joining all the data together and then present just that to ssrs, leaving the data I use in the textboxes out of the table when displayed? I guess this may just be a question of best practices 🙂 Thanks!
maxx

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

getoffmyfoot Hall of Fame Points: 3338 More actions · Answer 1

I think you will have the best success by writing the report for a single employee id, then "wrapping" the report by making it a subreport of another report's tablix that calls the subreport for every employee id. The outer report simply gets a list of employee id's that you want to run the subreport for.

The final rendered result will behave in the manner you described.

maxx.flavin SSC Rookie Points: 40 More actions · Answer 2

Already having the report created and working for a single EmployeeID, is it possible to add an outer report at this point to wrap the current one in? Or do I need to start all over again and create a subreport right away to build my report within? I've not worked with sub-reports at all yet, I'll do some googling too - thanks!

maxx

veeren4urs SSCrazy Points: 2763 More actions · Answer 3

Hi,

Add a new dataset which have the employeeid to the report and use that data set to show parameter which have multiple values by changing the properties in the parameter.

And for the main report dataset and text boxs which are using a different dataset add a filter in the dataset which will be equals to the your employeeid values i think it will solve ur problem.

Thanks,

Veeren.

Thanks & Regards,
Veeren.
Ignore this if you feel i am Wrong. 😉

getoffmyfoot Hall of Fame Points: 3338 More actions · Answer 4

maxx.flavin (10/5/2010)
Already having the report created and working for a single EmployeeID, is it possible to add an outer report at this point to wrap the current one in? Or do I need to start all over again and create a subreport right away to build my report within? I've not worked with sub-reports at all yet, I'll do some googling too - thanks!
maxx

Yea if you already have a report working for a single employee id, just "wrap" it by calling it as a subreport from within the cell of the tablix grouped by employee id.