run rpt with 150 different parameters?

[LMCRYER]

We have one master report that needs to be run using different parameters (about 150 different ones, actually) and then save the instances...or better yet, throw them in a file or something...

The way this was originally set up (before I got here, mind you!) they created dups of the original rpt and set each one up by itself.

Needless to say, now every time I want to modify that report - you guessed it - I'm modifying 150 versions of the darn thing!

I am going to use Rpt Inspector to make the changes for now so taht the change carries to all of the reports, but ideally we only need one report - just need it to run with all the different parameters..

Whats the best way to do this???

LMC cryerlisa@hotmail.com

select * from Management where proj_mgmt_skills <> NULL

0 records returned

 

[Turkbear]

Hi,
150 Parameters?????
Maybe a redesign is needed ( maybe of the underlying data source as well).

Well, you can dynamically pass parameters for on-demand reports but not scheduled ones, AFAIK..Perhaps a third-party tool can do that ( or a custom VB app run on a scheduler,maybe).

 

[LMCRYER]

A bit more info here --

I can probably do this another way, by letting it run for all of them and then busting it out, but then I run into the issue of - well...let me back up.

We have a report that has to run for every active project.
There are 150 projects right now. Every time a new one is created we have to make a new copy of the report, and put the parameter out on it, and then...blah blah blah..

Maybe running it as one big report -- with separate pages...but then I need it saved separately..

I know there has to be a better way to do this! We shouldnt need 150 copies of this report just to get it to run for 150 different projects...



LMC cryerlisa@hotmail.com

select * from Management where proj_mgmt_skills <> NULL

0 records returned