Skip to Content

Crystal Reports with WCF webservice as datasource

Jan 10, 2017 at 04:15 PM


avatar image
Former Member

I have two following objects: Assignment and Billing

In SAP crystal reports i am using a WCF service as a datasource. In the WCF i have two methods GetAssignments which returns a list of assignments. And the other method is GetBillingByAssignmentId which takes a List of assignmentIds as parameter. In Sap crystal reports i show data for all the Assignments and its all fine but the problem is that for every Assignment i want to get the Billings information too from the webservice apparently its not that easy.

I have get it to work with one assignment. I can get the Billing information if I only have one Assignment, but cant get it to work with list of assignments. The "Allow multiple Values" for GetBillingByAssignmentId parameter is greyed out even if my WCF service is taking a list as parameter.

I just cant figure it out if its even doable? Hope u guys can point me to the right direction.

untitled.png (23.1 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
avatar image
Former Member Jan 19, 2017 at 11:56 AM

No feedback recieved so I came up with a work around to midigate my Problem. Its not an elegant solution but it works.

First I concatenated The Assignment and the Billing Objects into one Master object so that all information is contained in one object called Assignment.

Secondly I changed the parameter of the GetAssignments method to take a string and not List of integers. And then from Crystal reports viewer when user is prompted for a value the user can type comma seperated list of Assignment Ids. The web service splits the Assignmend Ids and returns the List of Assignment objects.

10 |10000 characters needed characters left characters exceeded