Method Community

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!!

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, ...

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 ...

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 ...

Sorry for the late reply.  Worked perfectly

I am trying to join the PurchaseOrder table with the PurchaseOrderLine table but cannot figure out the syntax to accomplish this in the MethodVBA examples. I thought I could accomplish this somehow with the sSelectFrom variable, but I cannot seem to get this working. Before I lose my hair, is this even possible?

Thanks Paul.  Always a second set of eyes will do the trick. I have been staring at this for at least an hour

Just a quick thanks in advance!! Here is my issue: I am trying to use the VBa example to pull 4 fields from the item table into an excel sheet.  i am not sure where i am off because only the first 2 columns are being populated.  But it seems like ALL the rows are there. I used the Import/Export tool to get the entire table list to make ...

OK, sorry to sound like a newbie, but how to you create a script. I am referrring to your "Assign an action result to store the script." I can't find a create script function.      

I know that we are allowed to use filtering, but it there a way to change it from "AND" to "OR" I have a customer that has a table set up with Part1, Part2, Part 3 and wants to be able to return a report that has a single part number in any of those fields. The way its currently set up is if I put a part number in all of ...