We are in the process of implementing Crystal reports on top of BI. The reports will be sceduled to run on the Enterprise server using date ranges determined by the BW variable user exit. The users require that the dates that are determined by the user exit be displayed on the header of the reports so that they know what date range the report has been executed for. To this point we have not been able to find a way to get the dates that are determined by the user exit back to the Crystal report. Does anyone know of a way to feed the dates that are determined in the BW user exit back to the Crystal report?
Or alternatively, does anyone have any ideas how to calcuate date ranges for reports that are scheduled in the BOBJ Enterprise server without using the BW Variable user exit? Examples of what we need are:
1. Previous week
2. Previous Month
3. Year to date