Hi We are using Export Report Data to Excel v2 (Export SQL and Report Data

Can you try converting the names to a string using "toString" just to check if that populates the data?

Hi Sathya
After converting the names to toString [=tostring(pv!assigneeCompletions_UserGroup)], it changes to userId/GroupId. Yes it is populating the userid/groupid to excel report not User Name /Group Name. for eg. It is populating 'rupakj' not 'Rupak Jha'. Please find enclsoed screenshot.
Regards,
Rupak Jha

Groups are held as numbers & names are held as user_name string. That's what you are seeing here when you convert the value to a string.

Thanks for the quick response..
Yes, that is correct but we need to populate the names and group names to excel report to make it meaningful. Any idea how to achieve this.

Regards,
Rupak Jha

You can write an expression rule that
1) Checks to see if the first character in the returned string is a "["
2a) If yes, uses the group() function to get the group name
2b) if no, uses the user() function to get the the first or last name of the user
3) Use apply() to iterate this rule over your list of Users or Groups

Hi Andrew,
I have created an expression rule - rule!GLOB_getUserOrGroupNameFromString and using the apply in Column definition to iterate it "=apply(rule!GLOB_getUserOrGroupNameFromString(_),{tostring(pv!assigneeCompletions_UserGroup)})". but it is returning blank column. I have already tested the expression rule and it is returning name/group name as required but getting blank column while using it in report.

The user() and group() functions are part of the Appian Scripting functions category (forum.appian.com/.../Appian_Functions.html that aren't to be called in portal reports. You'll need to store the report data in process variables before applying your display formatting / inserting it into the excel file.