cancel
Showing results for 
Search instead for 
Did you mean: 

Crystal Report: failed to read parameter object

Former Member
0 Kudos

Hello -

I have a report that consists of numerous static parms and one dynamic parm. I can save the report to my desktop but cannot save it to BO 3.1 CMC Personal Folder (or any folder for that matter).

The dynamic parm does not use a LOV based on Business Views. A table associated with the same data source as the stored proc on which the Report itself is based provides two fields - a code field that is used in the Value and a name field which is used in the Description.

The specific error is:

"Failed to read data from report file <file name> Reason: failed to read parameter object".

All the normal things have been checked -

- VERIFied the database

- Ensured 'No Printer' is checked

- Ran the report (successfully) on the desktop (locally)

The data source is Oracle. The report can be saved to the CMC and run without problem if the dynamic parameter is deleted from the report.

The version of Crystal Reports is CR 2008 vers 12.04

I've seen numerous postings regarding LOVs and Business Views, especially surrounding security issues, but I've yet to see a note about a dynamic parameter based on a table....

Thanks

Accepted Solutions (0)

Answers (2)

Answers (2)

DellSC
Active Contributor
0 Kudos

When you publish the report to BO, you need to check the "Enable Repository Refresh" checkbox at the bottom of the Save screen.  This will create the LOV in the BVM.  You'll then need to log in to the BVM, find the connection that the new LOV uses and set the password for it.  This will enable the LOV to work with your report.

There is no way to have a dynamic prompt in a Crystal report in BO without having the LOV in the BVM.

-Dell

Former Member
0 Kudos

Hi!

Thanks for the response....

Re: check the "Enable Repository Refresh" checkbox

The SAVE failed with the Failed to read data from report file error.

When I went to the Bus View mgr, I found the LOV. It was set as a cascading prompt (not what I wanted when I set the parm) and could not edit it. No permissions.

I went back to the report and tried to edit the parm into which I had stuffed the LOV I can't touch in Bus Views, and found I can't open in the report canvas without logging into the repository.... which I did.... and went to edit the parm...can't open in the report canvas without logging into the repository.... which I did.... and went to edit the parm... You get the idea....

What I had WANTED to do is take a table with 2 fields in it - a NAME and a CODE field, create a dynamic parm, use the CODE field as the Value and the NAME field as a description. When I brought in the LOV, it came in as a cascading LOV... I needed to have the Description as the user fronted piece... but I can't seem to get there from here.....

Former Member
0 Kudos

Hi James,

In the crystal report when you creating dynamic parameter you just select the code field under the "Value" and select the name filed under "Description".

Can you attach the screen shot how you created dynamic parameter in crystal?

Did you try directly create a parameter in Business view and that used in crystal?

Please let me know the above information.

--Naga.

DellSC
Active Contributor
0 Kudos

Do you have the Administrator password for your BO system?  If so, log in to BVM as Administrator.  If not, as your administrator to log in to BVM and grant you full control rights so that you can add and update objects there.

From experience - the LOV will not work unless you set the db password for it in the Data Connection in BVM.

-Dell

Former Member
0 Kudos

Hi James,

Even you didn't use the LOV based on Business view, if you created a dynamic parameter in crystal and after saved that report in CMC, internally it will create that LOV in Business view manager.

According to my knowledge i think there is an issue with business view manager. are you able to create any dynamic parameter in Business view manager.

testing purpose can you create a dynamic parameter based on the same table and use that parameter in crystal and try to save the report in CMC.

let know once the testing is complete

--Naga.

Former Member
0 Kudos

Thank you for your quick response!

I did the following:

1. Took the 'problem' Parm and set it to static

2. I had previously created a LOV in Business Views. I used that in a 'test' dynamic parameter

3. Saved to the Desktop - OK

4. Saved to my personal folder on CMC - OK

5. Replaced the original 'problem' - the report failed to save to the CMC

In reference to "internally it will create that LOV in Business view manager.", I did notice a LOV in the repository that was not something I had created in Bus Views. When I tried to build a parm on that  LOV, I received a no permissions to edit error.

Hope this info helps

Thanks