Bursting Multiple Reports

[mbrassfi]

I send out a set of 4 reports, broken down by department, to the same budget manager once a month.  Each report pulls from a different package.  I would like to keep all four reports grouped so that they can easily be passed on to the end user.

Currently I have each of the reports in a folder with a job attatched to all of them.  I manually change the dates in each report before I run the job itself.  Arduous, tedious and boring.  Would like to know how I can speed this process up.  They all go to the same email, so that should cut down on the complexity a little bit.

[MFGF]

Hi,

What dates do you need to modify?  Is this something you are filtering on that can be derived by an expression rather than a hard-coded date?

When you say:

I would like to keep all four reports grouped so that they can easily be passed on to the end user.

are you referring to the grouping being done within each report, or that you would like them to be run as a group via a job?

Is the end user you refer to the Budget Manager, or does he then pass the reports to others?

Sorry - lots of questions...

Regards,

MF.

[mbrassfi]

The date issue I am trying to fix using my previous post "Prior Periods" http://www.cognoise.com/community/index.php/topic,8779.0.html which has been touched on, and I am currently testing.

Currently this is how the folder is set up:

Job     100_Communications and Marketing Roll Up     
Report BudgettoActualByFund_100     
Report BudgettoActual_100             
Report Org4ActivitybyFund_100
Report Org5ActivitybyFund_100 

There are 34 different departments (100, 102, 105, 200, 202.....) which is what I would like the emails to break on.  They all go to the budget manager who reviews and then distributes to the end user.  I would like to keep all of the reports grouped together to ease the budget managers job.

Its possible that the best solution is going to be hard code the department code in each folder, and then use a "Prior Month" coding so that when the report runs it always pulls the month just prior.

[MFGF]

OK - makes sense.  I have replied to your other post re finding the current period, if that helps.

You can enable bursting within a report written in Report Studio if it helps - in your case you would need to group the report on department.  Your challenge will be how to define your target email addresses in the report - do you have them as a report item you can bring in, or are they a set format that you could generate with a calculation, or are the users' email addresses already part of their login record or... ?

MF.