cancel
Showing results for 
Search instead for 
Did you mean: 

CR 8.5, how can I find a Parameter Field on my report?

Former Member
0 Kudos

Our business system vendor created a number of reports for us.

They have a Parameter Field called @Ad_Parameter1 and I can't find it.

I've exported the "Report Definition" and searched and it's not in the file.

I've checked in the "Record Selection Formual", it's not there.

I've checked in the "Group Selection Formula", it's not there.

I've searched on the report, it's not there.

I also checked under "Format Section" to see if there was a formual using this field. There are no formuals for any of the sections.

Any other ideas on how to find where this is being used.

I'm using Crystal Report 8.5.

The Parameter is being passed to the report via a stored procedure...

Any help would be appreciated!

Kelvin

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Change the type of the parameter - something will break.

If you haven't found it in any of the regular formulas, it's probably in a Print Suppression formula or a field formatting formula.

Former Member
0 Kudos

Thanks for the reply...

When I try and edit the Parameter it's all grayed out and won't let me change any of the values, nore can I delete is since it is being used.

The Parameter is being passed from the business system so when the report is opened from the BS it opens the report for the current record in the application. ie if I'm in customer XYZ it bring up the report for the same customer. It seems to me that it has to be setup as a filter somewhere...

If you think of any other place I could look, please let me know...

Thanks

Kelvin

former_member292966
Active Contributor
0 Kudos

Hi Kelvin,

If the parameter is greyed out that means the report is based on a Stored Procedure and that parameter is from the Stored Procedure itself.

There is no way in the report to change this, it's set in the code from the database.

Brian

Former Member
0 Kudos

Thanks for your help!

Now I see how the pieces fit together....

Kelvin

Answers (0)