Execute report variable number of times? to same Excel workbook?
CURRENT STATE
Discoverer report with 3 parameters:
1. Client ID
2. From Date
3. To Date
The report returns the client's data for the given date range. The report is often run for the same client for multiple, but related date ranges. For example, it is executed 8 times for 8 different quarterly date ranges to get the past 8 quarterly reports for the client. Each report takes several minutes to run.
REQUESTED FUTURE STATE
BI Publisher report with 4 parameters:
1. Client ID
2. From Date
3. To Date
4. Reporting Period (Monthly/Quarterly/Yearly) [NEW]
The customer wants to
-Enter one date range
-Run the report for each reporting period
Discoverer report with 3 parameters:
1. Client ID
2. From Date
3. To Date
The report returns the client's data for the given date range. The report is often run for the same client for multiple, but related date ranges. For example, it is executed 8 times for 8 different quarterly date ranges to get the past 8 quarterly reports for the client. Each report takes several minutes to run.
REQUESTED FUTURE STATE
BI Publisher report with 4 parameters:
1. Client ID
2. From Date
3. To Date
4. Reporting Period (Monthly/Quarterly/Yearly) [NEW]
The customer wants to
-Enter one date range
-Run the report for each reporting period
0