Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Displaying Prompt results on Report

Status
Not open for further replies.

JKas

Programmer
Jan 20, 2005
28
US
Hello,

How can I add the user entered prompts on the report header page? I tried using the Layout Component Reference. However, that just re-displayed the entire Prompt box. I only want to display the prompts as input by the users.

Thanks

Jeff
 
Sorry,

Yes, that is exactly what I mean. It could be dates, numbers, etc.

Thanks

Jeff
 
Which application are you using ?

In Impromptu go to Insert Menu -> More Ibjects -> Prompt variables and select the required prompt or you could create a calculation conatining just the prompt field and add this to the report just as you would any field.

HTH



Gary Parker
MIS Data Analyst
Manchester, England
 
Sorry again,

I am using ReportNet v1.1. But I will try the calculation. Thanks
 
This is simple in reportnet.

1. Drag a new text item to the location in the report (ie header / footer etc) where you want to display the selected prompt values.

2. When the pop-up box appears asking you to enter the text, just click OK without entering anything.

3. It should now appear on your report as a text item that says "Double-click to edit text".

4. Click once on this text item so it is gray, and go to the properties window. There should be a property called 'Report Expression'. Click on the ... next to this to edit the expression.

5. From the window that opens up, click on the parameters tab, and select the parameter that is satisified by the prompt.

6. The expression that is generated in the right hand pane should be something like "ParamDisplayValue(parametername)"

7. Click OK and run the report, and voila!

Cheers
J
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top