Hiding Parameter names being shown in Parameter Page at runtime

[Former Member]

Friends,

I have a report developed in Crystal Report 2008 with various parameters for which i had specifically mentioned the Prompt Text for each in the Parameter Edit.

I would just like to know if this is possible only to show these prompt text and hide the parameter names being displayed in the right corner of each parameter field at run-time.

For example, I have created a parameter named employee and added a Prompt Text "Enter Employee" for the same. When I run the report, it displays the prompt text "Enter Employee" in left corner above the parameter input along with the parameter name employee in the right corner opposite to the prompt text.

I would just want to avoid this parameter name employee getting displayed in the parameter page.

Please let me know the possibilities of the same.

Thanks,

Karthikeyan.G

[DellSC · Accepted solution]

As far as I know, there is no way to do this working with just Crystal.  How are you running your reports?  If you're running them from an application you've written you could have your app gather the parameter values and then pass them into the report prior to viewing it.

-Dell

[Former Member · Accepted solution]

Thanks for the prompt reply.  I am running the reports in the BI server provided for the ERP where I could publish and run the same. I am using crystal parameter page as my BI server provided parameter page does not support dynamic lists.

Karthikeyan.G

[JWiseman · Accepted solution]

hi Karthikeyan.G,

by BI server do you mean cr server or business objects enterprise? if so, why not avoid the parameter / prompt page altogether? cr 2008 and above have a parameter panel available on the reports themselves.

steps to use this:

1) in the report designer, right click on a parameter and choose Edit

2) in Options > Show On Viewer Panel select Editable which will allow this parameter to be shown on the panel

3) repeat 1 & 2 for each parameter you want to expose

4) save the report back to your enterprise environment

5) in boe, you now want to create a new hyperlink to give your end users access to...i.e. you can move the report to a sub-folder and then create the hyperlink in a folder that the end users access

6) this new hyperlink will be an opendocument url and this url will include a dummy value for each parameter...i.e. when they click on it, the report will open but will have no data as the dummy values will not return anything.

7) after opening the report via the url, the parameter panel will be on the left side of the report viewer and the end user will not have to look at that pop-up parameter dialogue again.

if you need to create a sample hyperlink, then you can do this in the crystal reports designer by right clicking on any text object in any report > Format Field > Hyperlink Tab > select A Website on the Internet and then choose Create Enterprise Hyperlink. this will now guide you through creating an opendocument hyperlink which you can copy, remove the paragraph formatting, and then add in to your boe system as the hyperlink.

i hope this helps,

jamie

[Former Member · Accepted solution]

Hi Jamie,

I am working for a product called Lawson in which we have LBI server which is used to publish and maintain various BI reports created in Crystal, Smart Notes, etc.

Actually I am following all the options as you suggested above. I have options in LBI to use either the parameter page from crystal reports or the one provided inside LBI itself.

The thing is when I use the built-in parameter page of LBI , I could not use the dynamic values in the list as it support the parameters only as user inputs.

The crystal parameters are very well working in LBI, the only concern is that it displays the parameter names as labels along with the prompt text defined for the same at run-time which I am exploring for some options to avoid this as I would want only the user-defined prompt text has to be displayed as labels at run-time.

Thanks,

Karthikeyan.G