Hi All,
Is there a way to prompt the user to enter values for prompts in a Crystal on-demand subreport WHEN user CLICKS on the link for the on-demand subreport. Is there a setting I can change? I am on Crystal Reports XI V 2008.
ajq 
anushajq (BOB member since 2005-02-22)
I found your idea quite novel but try as I might, I could find no solution. No matter how I set Select Expert in the subreport, its parameter always triggered when I ran the main report.
The closest I could get was to save data with the report so when it opened, the parameter would not trigger. Then when I clicked on the hyperlink to launch the subreport, I put a message at the top of the subreport something like: “If you would like to view optional data, press the F5 key and select ‘Prompt for New Parameter Values’, then enter your own values into the parameter.”
Obviously that is not as nice as your idea.
Chamsin 
(BOB member since 2008-06-05)
Hi anushajq,
Did you find any solution or a workaround for this?
Please can you share here.
Thanks,
SenthilM (BOB member since 2013-03-20)
You will need to use OpenDoc to achieve this. Save the sub-report as a report on Enterprise. Create a hyperlink to the report and not provide the values to it. The parameters which are not provided are prompted to the user when the user clicks on the link.
sunny916 (BOB member since 2013-03-13)