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?
devmastersAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mlmccCommented:
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
0
devmastersAuthor Commented:
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.
0
mlmccCommented:
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
0
Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

devmastersAuthor Commented:
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
0
mlmccCommented:
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
0
devmastersAuthor Commented:
Thanks for the inputs...Do yo mean the SDK code needs to be modified?
0
mlmccCommented:
The code that generates the web service needs to be changed.

mlmcc
0
devmastersAuthor Commented:
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?
0
mlmccCommented:
I have not implemented anything like that.

I have not worked with a web service as a datasource so I don't know what you can change.  Can you change the code used to call the report or that affects the filters on the web service?

The code that needs to change is the code that build the filters for the data source.

mlmcc
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.