XL-Reporter : User Signature field
Hi ! in XL-Reporter how to get the user signature of a document.
i need to get the user who hav created a document ( eg. Purchase Inv )
i tried in composer, by taking 'Document Owner', but it displays as 'n.a'.
how to get the user in XL-Reporter.
Thanking in advance,
Daan Posthumus replied
Your 'Get other Data' will have to be something like this - =ixGetData("manager","yYhL", "OPCH", "DocNum","UserSign"). That will give you 2 columns - the document no and the user sign. In your expanding row (Report Designer) you will use the document no in the row to do a vlookup in the 'Get other Data' columns, to populate the user for that document. The vlookup formula will expand with the rows when you run the report.