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,
Meera.
Hi Meera
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.
Regards
Daan
Former Member replied