Hi guys. I am having issues using CR. I have created my soap web service. I can create the datasource in CR. After pasting in url for wsdl it recognizes the service and port and method. The datasource shows up with all the fields like you would expect in CR. I can select some fields and put them on the report. However when previewing I get an error. It says "Cannot determine the queries necessary to get data for this report. Details: Unexpected error."
I started with CR 2008 and then switched to 2016. I get the same error with both. I tried switching my output parameter in the web service method to a record. That works, I can retrieve one record in crystal. However when I use a record list, i get the error in crystal. Any suggestions?
So i figured out that if I limit the records with a filter it works. I don't know the exact number. Seems to be about 1500 records. Might vary depending on the fields displayed ? Not sure why this is. Is some setting in outsystems or is this a crystal report thing ? Whats the most data anyone has pulled into a crystal report via a web service? The 1500 records load quickly. In about 3 seconds.
Also im using outsystems PaaS cloud if that makes any difference.