Skip to Content
avatar image
Former Member

Crystal Reports with WCF webservice as datasource

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

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.

    Add comment
    10|10000 characters needed characters exceeded