Schedule to run through all possible parameters w/o Visual Cut

[hansdebadde]

I work in a large org and getting something like visual cut software approved is never going to happen. I am using CR XI SR2 to write the reports and i have Enterprise as well to post/schedule if needed. The datasource is Excel. I have a report that needs to run with all possible choices for a field value. Right now i am limited to using a parameter to select a value, run it, and then export to pdf. The report is slow (2mins) and there are hundreds of reports to run. Is there a way to set it up to run on a schedule every 4 minutes or so and pole through each value for a day or so?

 

[Turkbear]

Hi,
Please explain further what you mkean by:
"to run with all possible choices for a field value".
and
"pole through each value for a day or so"

Do you mean a separate report for each possible value?

If you need to have a separate report for ech value try not specifying any value in the selection criteria ( and therefore no need for a parameter) - group the report on the field in question and set a new page before and after the group..That way you can have a 'separate' report for each value and it should export to PDF as separate pages..





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[hansdebadde]

That might just work, I will have to splice them all out into separate documents but it may be faster then my other options. Sorry to not be clear. I need to run the report for a list of people, and i need it run for everyone in no particular order. For example, Bob, Mary, Sue. In my dream world i hoped to have enterprise run every five minutes and i would have a formula that would set the value for the person (ie. bob or mary etc.) based on the time, I think i can do this but i am having trouble getting the report to run in enterprise right now.

 

[hansdebadde]

I figured out how to get it to run on a schedule for each of the values in a field: DIRDESC
In select expert i put a formula like:
if (minute(currenttime))= 01 then {Sheet1_.DIRDESC} = "Guy #1"
else if (minute(currenttime))= 02 then {Sheet1_.DIRDESC} = "Guy #2"
else if (minute(currenttime))= 03 then {Sheet1_.DIRDESC} = "Guy #2"

The formula looks like a lot of work but it wasn't bad. I exported all possible values (209) and then did a replace of the " with the formula bits.
I then scheduled the report to run every 11 minutes and it started dropping off all the reports.
I just wish i could dynamically change the title.