Method:API Q&A

Re: Using API in Crystal Reports

m.mehr — Wed, 15 Jun 2011 19:56:51 GMT

I am a newbie, and I have no idea what is going on in that SQL Server db, but what about moving the SQL Server data to Method, then creating your reports using Method Report Writer?

Just another idea to chew on!

Re: Using API in Crystal Reports

CDS_Josh — Wed, 15 Jun 2011 19:26:53 GMT

Not exactly the answer I wanted to hear, but it does save me a lot of time trying to figure this out. Thanks for the reply!!

Re: Using API in Crystal Reports

Anonymous — Wed, 15 Jun 2011 14:21:42 GMT

Hi CDS_Josh,

Althought I'm not a developer, I do know that you won't be able to use Crystal Reports with Method even with using the API. You can extract the data you want using the Method API and then use Crystal to create the reports. However, you won't be able to make a direct connection to the Method database throught the API to load the data in Crystal. Not sure that's the answer you wanted to hear. =)

Re: Using API in Crystal Reports

CDS_Josh — Mon, 13 Jun 2011 20:12:24 GMT

Some more information that might help:

Here are the screenshots of the information I have to use to setup the report in Crystal Reports

I am not sure what to put for the schema location but apparently I have to put one in or I get errors

Here are all the Parameter I have to manually put in (the astericks are just for this picture, I put the correct values in). This is pulled from an Excel API that I am currently using successfully.

Here is the error message I receive:

Then if I uncheck the "Specify Schema File" from the first screen above, i get this error:

I was thinking about using a local schema file, but I am still new to the XML stuff.

I hope someone can help me out with this.

Re: Using API in Crystal Reports

CDS_Josh — Mon, 13 Jun 2011 16:57:49 GMT

OK, I just found out that if I leave the User Name and password sections blenk, I now have populated Services, Ports, and Method sections.

However, if I try to choose one of those, I get:

"Logon Failed.

Details: Schema File is invalid

error: TypeArray@http://schemas.xmlsoap.org/soap/encoding not found"

Hope someone can shed light on this matter

Using API in Crystal Reports

CDS_Josh — Mon, 13 Jun 2011 16:33:57 GMT

I have a customer that is using several crystal reports on a custom database in MS SQL. They wanted me to figure out a way to incorporate Metod data into these reports and I think this API is a way to do so, but I just cant figure it out.

Has anyone sucessfully retrieved Method data in Crystal Reports? If so, can you please help me out.

If not, there is an XML Data source reference in Crystal reports, but I am not sure of all the configuration:

1) HTTP WSDL URL (I used: https://www.methodintegration.com/MethodAPI/service.asmx)

2)HTTP(S) Username and Password (I used mine)

3) Service, Port, Method (these are the values I have no idea what to use since they are blank)

Can this be accomplished?

Thanks in advance