cancel
Showing results for 
Search instead for 
Did you mean: 

New oracle package parameter not in report

Former Member
0 Kudos

I'm using Crystal XI rel 2 and trying to add a new parameter to an existing report that's based on an Oracle package. But the report does not pull in the new parameter. Does anyone know how to "update" the report to see the new parameter? Thanks....

Accepted Solutions (1)

Accepted Solutions (1)

0 Kudos

You should be able to simply open the report and then click on Database... Verify and it should find the new parameter.

What happens if you create a new report off that updated SP, do you see the parameter?

Thanks

Don

Answers (3)

Answers (3)

Former Member
0 Kudos

The main issue of adding the parameter to the existing report still exists. My work around is to create a new report, which pulls in the new parameter, and then rebuild the report based on the old one. Not pretty and probably a bug somewhere. But my question regarding what steps should be taken in Crystal to add the new parameter have been answered. I appreciate the help!

0 Kudos

There were others reporting if after verifying the DB, Save the report and then close the Designer down and reopen the report.

Verifying should update the info, try using F5 to refresh the connection also.

Thanks again

Don

Former Member
0 Kudos

Thanks for the responses. Yes to both, I've gone through the database verify steps, but the new parameter is not pulled in. To make sure the function was working, I added a column to the ref cursor and it came in fine after doing the database verify. If I base a new report on the package, the parameter shows up correctly.

Thanks....

0 Kudos

Great,

Please mark as answered.

Thank you

Don

former_member292966
Active Contributor
0 Kudos

Hi,

When you open the report in Crystal, go to Database | Verify Database. This will have the report go out and check the structure of your table or Stored Procedure and see the new changes you made.

Thanks,

Brian