Load Collection in reportviewer

unknown

Hi I am having issues loading an IDO collection for a report form. 1) This IDO has 2 tables po_mst and whse_mst joined by whse.whse and site_ref. I ran it in IdoDataViewer and runs fine. I then check if it will run in DataViews Setup, it will run without the addr##1 property from the whse_mst table. If I add the addr##1 from the whse_mst table I get an "There was an error generating the XML document." error. The other properties from whse_mst table works but I need that proprty as well.

So... When I add a LoadCollectionRequestData to the form to call the IDO it will only run when I use properties from the po_mst table and the filter will only work if its harcoded values but not when its a string function like: PoNumRequest.Filter = String.Format("po_num = {0} AND site_ref = {1}", PoNum, Site)

Im checking the count of rows by: ThisForm.Variables("WhseNoData").Value = PoNumResponse.Items.Count().ToString()

Dim PoNumRequest As LoadCollectionRequestData = New LoadCollectionRequestData()
Dim PoNumResponse As LoadCollectionResponseData

'ThisForm.Variables("WhseNoData").Value = "Before Load Properties"

PoNumRequest.IDOName = "ue_WarehouseIDOreport"
PoNumRequest.PropertyList.SetProperties("po_num, site_ref, whse")
'PoNumRequest.Filter = String.Format("po_num = {0} AND site_ref = {1}", PoNum, Site)
'PoNumRequest.Filter = String.Format("site_ref = {0}", Site)
'PoNumRequest.Filter = "site_ref = 'DALS' AND po_num = 'DP00000041'"
PoNumRequest.Filter = ""
PoNumRequest.OrderBy = ""
PoNumRequest.RecordCap = 0
PoNumResponse = IDOClient.LoadCollection(PoNumRequest)

Im at a loss, I have been using this Load IDO collection for quite some time now and all of a sudden it doesnt work anymore

Rees Howel

I appreciate this is an old thread....

I've been building a query for IDM in formscript to link up some documents from Syteline until the long awaited bundling feature is finally released.  I normally use the overloaded syntax for LoadCollection but it seems that doesn't allow the Distinct keyword, so I needed some example code (because the IDO Development Guide isn't always clear).

The code I used (which works) expresses the filter syntax differently - yours is analogous to AES syntax. So thought I'd post in case it's any help.

   'get DISTINCT Items on PO

   sPoNum = ThisForm.Variables("EQ_PoNumVar").Value

   Dim PoItemRequest As LoadCollectionRequestData = New LoadCollectionRequestData()

   Dim PoItemResponse As LoadCollectionResponseData

   PoItemRequest.IDOName = "SLPoItems"

   PoItemRequest.PropertyList.SetProperties("Item")

   PoItemRequest.Filter = "PoNum = '" & sPoNum & "'"

   PoItemRequest.RecordCap = 0

   PoItemRequest.Distinct = True

   PoItemResponse = IDOClient.LoadCollection(PoItemRequest)