I have created a report that needs to be run once a week using a combination of variables. I'd like to keep this as scalable as possible, and my challenge is to come up with a solution as there are 330 combinations that I need to account for. This represents running the report using one selection for 'Filter A' and 'Filter B.' In addition, there are 8 different data sources. I'm running 8.4 using a relational package. Any ideas would be greatly appreciated!
Hi,
If you want to run the report with different prompts then the bet way is to create a report view and define the prompt values. Is this what you are looking for?
HTH
Satish
I have the report set up to use the prompts, but my problems are that there are 330 combinations of Filter A and Filter B. I need the report to run every week, and I don't want to create multiple instances of the report. I've thought of using Event Studio, but I would have to set up 330 events to get the desired results. I just wondered if there was a way to do this so to keep it scalable. For example, if the report spec changes, I only want to have to change it in one place. If the desired delivery day changes, then I want to be able to update that in the fewest places. I have a feeling this project is going to grow even larger, so my goal is to make it as managable as possible.
I would try using the burst functionality in order to achieve this. Have a table that includes each possible combination. Stick that table in a page set, with your reports inside that using master/detail, and burst on that table. This should generate an individual report for each row in that table, and if the master/details are set correctly it should be exactly what you need.