CE10 Parameter Prompt

[BillBrosius]

I have created a report that requires a parameter. When developing the report the parameter "prompt" screen allow you to add supporting text to describe to the user what the prompt is regarding. For example, "Please enter order number."

After publishing to CE10 for distribution I noticed at first that when viewing the report it would not prompt the user for the order number. It would just pull up the report with the data used when last saved by the developer (Me). I then found that you can set CE10 Object properties to enable the prompt. However, I don't see how to add supporting text to describe to the user what the prompt is for. The prompt come up with the following:

"The report you requested requires further information."
"Crystal Parameter Field(s)"
@1
Discrete Value
________________
|________________|

How is the user supposed to know what to enter? Am I missing something?

Thanks for any guidence.

 

[mdwyer]

After publishing the report to CE, go to the Crystal Management Console (CMC). Select Objects or Folders and navigate to the report. When you click on the report name, you will be on a page with five tabs. Click the Process tab and then the Parameters sub-tab. Your designer's value will be displayed. (I believe you can avoid this by not saving data with the report in the designer.)

Click on the parameter value. On the new page you can enter or clear a default value. You can also elect to prompt the users again if they rerun the report from the viewer. This page should display both the parameter name and the prompt string from the designer under the text "Set the initial value for this parameter." Be sure to clcik the Submit button after making your changes.

If you have correctly cleared the prompt, you will see the word "[EMPTY]" as a parameter value. The Parameters tab of the Schedule dialogue will show an empty box for the parameter, labelled with the same parameter name and prompt string seen in the CMC.

 

[BillBrosius]

That has all been done, but still have same result. I must add that the report's data source is a stored procedure with a variable. It all works great from the "developers" view, but I noticed that when I close and reopen the report the "text label" for the parameter is blank. It doesn't retain the text I type for the prompt after saving.

Is this a stored procedures thing? I am going to create a simple test report using a direct link to a table in my database and try again to see if I get different results. Thanks for any other input.

 

[BillBrosius]

Well, did the simple test report with a direct data connection to a table in my database and all worked as you describe it should. Must be the use of the stored procedure.

Is there anything I can do?

Thanks.