Dynamic parameters: update dropdown list in Cystal Reports XI

[handle1134]

Hi

I've read several posts that say Crystal Reports 10 does not support dynamic parameters, they don't get updated when the database does, and this feature is expected to be implemented in CR XI.

I am using Crystal Reports XI, and i designed a report with a dynamic parameter. But refreshing and running this report from a Java API code, it returns only null ListOfValues for that parameter. The dropdown list is always empty.

Has Crystal Reports XI implemented dynamic parameters and i am doing smth wrong, or not?
Do you have some suggestions how to update the parameter's ListOfValues before running?
10x

Crystal Reports XI
Oracle Server connection.

 

[dgillz]

When you create your parameter field, you define it as static or dynamic.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry

 

[handle1134]

I have defined the parameter as dynamic and also configured the query to select the values for this parameter.
It seems to work fine when running the report from CMC.

The problem is when trying to get the list of values for that parameter using Java Web Services API.
I tried to use PromptInfo.getLOV().getValues() but it does not work. The returned LOV object is null.
Please advise if you have any idea on how to solve this.

Thx

 

[dgillz]

The CMC? What is a CMC? I have been using crystal reports for 10 years and I have never heard of that term.

Is this a Crystal Reports Server or Crystal Enterprise question? If so you are in the wrong forum.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry

 

[handle1134]

CMC is the Central Management Console for the Crystal Reports Server, where you can manipulate (upload, schedule, run, modify settings or delete) a report that is hosted on this server. For example a link to my CMC is:

http://192.168.1.68:8080/businessobjects/enterprise115/admin/en/admin.cwr

When setting a value for the dynamic parameter in the CMC, first it asks for database logon info, then it updates the list of values from my specific field in db, so i can select a valid value.

What should i do when using Java API?

 

[dgillz]

If you run your report in the crystal report designer, does it run as expected?

If so then I think you are in the wrong forum.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry

 

[handle1134]

Yes, it works fine in the designer. However, the application that manages the report, written using the Business Objects Platform Web Services Java API, can not refresh the dynamic parameter list of values from datasource.

Are there some code samples that shows how to handle dynamic parameters?
Should this question be posted on another forum?

 

[dgillz]

I would post it in the crystal enterprise forum or the crystal reports integration forum.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry