GotTheBlues
Programmer
- Jun 3, 2003
- 5
Crystal reports 8.5, SQL Server 2000 database
I need to be able to prompt the user to enter a value for a parameter for an on-demand subreport, but only upon the opening of that subreport, NOT at the opening of the main report.
The link for the subreport is at the detail level of the main report, and displays the results of "What-If" calculations based on the data contained on that specific detail line. However, different values will be sent to the subreport each time the user opens it.
Currently, the user will be prompted for the value to send to the subreport when they enter the parameter values for the main report.
I have tried to send a value of Zero to the subreport upon opening the main report, and then have the user refresh the subreport when they open it. They will be prompted to enter the new "What-If" values, and the subreport will perform all calculations correctly. However, upon closing the subreport, the Main report will have to refresh it's data. Considering that the main report can have upwards of 400+ pages of data, this additional refresh time is something that I'd like to avoid.
As always, any help or pointers in the right direction is greatly appreciated!!
I need to be able to prompt the user to enter a value for a parameter for an on-demand subreport, but only upon the opening of that subreport, NOT at the opening of the main report.
The link for the subreport is at the detail level of the main report, and displays the results of "What-If" calculations based on the data contained on that specific detail line. However, different values will be sent to the subreport each time the user opens it.
Currently, the user will be prompted for the value to send to the subreport when they enter the parameter values for the main report.
I have tried to send a value of Zero to the subreport upon opening the main report, and then have the user refresh the subreport when they open it. They will be prompted to enter the new "What-If" values, and the subreport will perform all calculations correctly. However, upon closing the subreport, the Main report will have to refresh it's data. Considering that the main report can have upwards of 400+ pages of data, this additional refresh time is something that I'd like to avoid.
As always, any help or pointers in the right direction is greatly appreciated!!