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

rupakj

A Score Level 1

over 9 years ago

Hi
We are using Export Report Data to Excel v2 (Export SQL and Report Data to EXCEL - V2_3.0.6) to transfer portal report to excel.
We are getting blank (no data) for Assignee Column in excel report. All other columns generating correctly. Please find enclosed server logs.
Any help would be appreciated.

Regards,
Rupak Jha

server logs.txt

Discussion posts and replies are publicly visible

Parents

0 rupakj
A Score Level 1
over 9 years ago

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.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 rupakj
A Score Level 1
over 9 years ago

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.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data