XL-Reporter : User Signature field

[Former Member]

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.

[Former Member · Accepted solution]

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]

Hi Meera

You will have to use the 'Get other Data' function and do a vlookup from there.

Regards

Daan

[Former Member]

S Dann i m getting the user sign as u said,

but how can i achieve in getting those documents under some conditions like current date n all?

i used FIG( PO_DocDate = "CurrentDate" ) but i got some error like,

<b>An error occured while setting Excel formula!

=ixGetData("manager","yYhL", "OPCH", "UserSign", "FIG( PO_DocDate="CurrentDate")")</b>

How to add conditions?

Also can we be able to use such fields for grouping too?

Meera.