asked on

how to give a list of values a prompt to BI crystal reports using java webservice

I would like to give list of values as prompts from web service to crystal reports. So that I can choose multiple values from the report. Right now I am using string as a input parameter and asking end user to enter comma separated values as prompt input.

Any help would be really appreciated?

Mike McCracken

How are you prompting?

Are you using a parameter in Crystal?
If so, you can set it to accept multiple values

Edit the parameter
In the list of options at the bottom one of them is for multiple values
Set it to true

mlmcc

devmasters

ASKER

How are you prompting?
Crystal takes web service input parameter as prompts by default.

Are you using a parameter in Crystal?
I am not using any parameter in crystal. I am using webservice as datasource and it has methods with parameters.

Edit the parameter
I have no control to edit the parameter. All I can do is change the parameter to int data type to string.

Mike McCracken

Most databases don't accept multiple parameters. Crystal gets around it by changing the SQL filter to be a sequence of ORs.

The web service will need to be changed to handle a list od parameters or to accept multiple values and handle them correctly.

mlmcc

devmasters

ASKER

I have tried with different parameters as array,list &user defined objects.But crystal considers everything as textbox.When I explore the wsdl , the datatype is string. I am not sure how to modify it.

I am looking for sample wsdl accepting collection of values as input parameter. Also what needs to be done in webservice so that crystal can understand and display listbox instead of textbox

Mike McCracken

Crystal won't be able to understand the listbox. There needs to be code written to convert the multiple selections into a comma separated list.

mlmcc

devmasters

ASKER

Thanks for the inputs...Do yo mean the SDK code needs to be modified?

Mike McCracken

The code that generates the web service needs to be changed.

mlmcc

devmasters

ASKER

Thank you.. I used the following command to generate the wsdl .

wsgen -s src -d build/classes -cp build/classes com.xxx.webservice.xxxClass

I am not sure how to tweak this further. I did check across the web but I was not able to find any sample wsdl which has method input parameter as list/array .

Have you ever implemented this scenario or u r suggesting based on theory?

ASKER CERTIFIED SOLUTION

Mike McCracken

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial