unable to publish a report with a cascading dynamic prompt

[eoggb]

(CR XI, Oracle 9i, XP Pro)

Hi,
I have a command I created and I am using 2 fields from there to assign to a cascading parameter. When I run the report it prompts me as usual for my parameters and the report runs with no errors and bring back the correct data.

(I want the parameter to populate the desired Rig numbers according to the Contractor I chose)

When I created the parameter I selected:
List of values: Dynamic
Choose a Data Source: New
Insert: I selected the field Contractor from the Command
Insert: I selected the RigNo field from the same command
and created the parameter as the RigNo

In the selection formula:
{Command.RIGNO} in {?Contractor/RigNo - RIGNO}

No issues, no errors, but when I try to save the report to the enterprise I get the following error:

Fail to read data from report file....Reason:
Failed to read parameter object

When I remove the parameter the report can save to the enterprise, but I need this cascading parameter.

Any thoughts as to what I am doing wrong?.........

 

[synapsevampire]

Is the same connectivity available on the server?

What did you use?
If you use the natiove connectivity, which is suggested, it shouldn't be an issue, although I often have strange things happen with dynamic parameters and command objects.

Eventually I get them to work, but there's a bit of voodoo there...

-k

 

[eoggb]

yes, the connectivity is there if i take out the parameter it can be published on the enterprise and runs with no errors.so this puzzels me and the fields are being used in the report as well and all i'm doing is assigning them in a cascading parameter.

go figure eh.

 

[MJRBIM]

Take a look at this thread...

http://www.tek-tips.com/viewthread.cfm?qid=1356363&page=1

 

[synapsevampire]

I've had the same thing occur.

I generally find that something is amiss with the parameter though, which caused the failure.

For instance if you try to display the parameter inappropriately it will error in CE/CRS.

-k

 

[Turkbear]

Hi,
Since Dynamic Parameters are stored in the repository, your user account must have permission to edit the Cascading and Dynamic prompts section of the repository.
Use the Business view manager to see/set permissions..





To Paraphrase:"The Help you get is proportional to the Help you give.."