Hello,
I did post the same question at three different place and I'll ask it here too.
I was doing a report with XL Reporter and it was almost everything I need. But one information is missing and there is no way to show it with the report composer. My report was made with the Financial Tab dimensions and fields. But I need to show the comments field that is in the Purchasing A/P tab.
So I tried to use the ixGetData functions to reach the comments. But I need to specify to which record the report must take the value from a cell on each line.
Examples :
=ixGetData("ixadmin", "B5kGHP!", "[dbo].[OPCH]", "comments","DocNum = O11")
=ixGetData("ixadmin", "B5kGHP!", "[dbo].[OPCH]", "comments","DocNum="+O11)
=ixGetData("ixadmin", "B5kGHP!", "[dbo].[OPCH]", "comments","DocNum = '$O$11'")
=ixGetData("ixadmin", "B5kGHP!", "[dbo].[OPCH]", "comments","DocNum = 'O11'")
=ixGetData("ixadmin", "B5kGHP!", "[dbo].[OPCH]", "comments","DocNum=" + =ixGet("JDT1_SourceID"))
=ixGetData("ixadmin", "B5kGHP!", "[dbo].[OPCH]", "comments","DocNum=" + ixGet("JDT1_SourceID"))
=ixGetData("ixadmin", "B5kGHP!", "[dbo].[OPCH]", "comments","DocNum= = ixGet("JDT1_SourceID")")
The biggest problem is that I can't take the value of cell O11 and concat it with the critary string. I get always the same boring errors. 'can't convert varchar to int' when I put it as a String or 'O11 is an invalid column name".without tje quotation marks.
I can't do a nice looking report if I do it with an SQL query and I'm missing the comment field with XL Reporter. I don't know what to do, any suggestions ?