Crystal 2008 - Parameter not Hidden

[Former Member]

I am using Crystal Reports 2008 (version 12.2.0.290) to pass a parameter from the URL into the report and into an Oracle stored procedure.

The parameter is the USERNAME from an application table of application users.  It will be used in the stored procedure to limit the data returned from the associated view.

The problem is that I do not want the user to be able to change this parameter - so I want it to be HIDDEN - not included on the parameter input for the report.  I have the parameter working - coming in from the URL, passed into the Stored Procedure and limiting the returned view information.  When I edit the parameter, I set the "Show on (Viewer) Panel" to "Do not show" - expecting the parameter to be hidden, but when I run the report, the parameter is listed in the "Enter Values" panel - and is editable by the user running the report - first from the Crystal Reports designer - via "Report -> Refresh Report Data" - and also when I deploy the report to the Business Objects server and use the viewrpt.cwr page - same results - I can see the parameter and still can change it.  It would be OK if the user just saw the parameter and could not change it.

"MyUserName" is passed in this mocked-up URL:

http://www.blankety-blank.com/CrystalReports/viewrpt.cwr?promptex-SUSER_NM_IN=%22MyUserName%22&apspa...

Is this a BUG? Has it been fixed?

Is there any way to get a Parameter to not be shown on the "Edit Values" panel of parameter inputs? Or at least make it read-only?

Am I missing something here?

Thanks,

- Paul J

[former_member247711]

Paul, I may be way off base on this, but could this be as simple as editing the parameter in question and setting the "Show on (Viewer) Panel" option to the "Do not show" setting?

[former_member212381]

Hi Paul,

I know that this was an old post, but i was hoping that you've figured out your issue?

My issue is similar except that i can't figure out how to auto pass the Security Group that a user belongs to (ie. Group A, Group B) to a stored procedure that would then take that information and display data for Group "A" or Group "B" only.

I've been tasked to upgrade our Crystal Enterprise ver 10 server to latest BOBJ 4.1 SP2, and many reports designed this way do not have the hidden vUSERNAME (which in our case passes the Security Group name value) automatically and cannot be edited in our current old version of CE10 using Infoview.  The new versions (both BOE Xi 3.1 SPx and BOBJ 4.1) using  BI Launchpad shows this parameter field editable (after import) which defeats the original purpose - namely to only show data for the group that the user belongs to.

Any idea?

thx!

[former_member247711]

I may be way off base on this, but could this be as simple as editing the parameter in question and setting the "Show on (Viewer) Panel" option to the "Do not show" setting?

[former_member212381]

Hi Richard

Thanks for responding.  I wish it were that simple; however the main issue here is that the value itself is not passing to the parameter so hiding it is not going to do it any good.

So, really, I have to do two things:

1) passing the value from the Security Group to the parameter

2) hiding the parameter (once the value passes).

Message was edited by: Jeff Wei By the way, I just realized that you (Richard) may be responding to the original poster!...

[former_member247711]

Yes I was (responding to the original poster) - sorry!