on 06-30-2011 5:29 PM
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....
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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....
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.