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

rupakj

A Score Level 1

over 10 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 Andrew P Gramann
Certified Lead Developer
over 10 years ago

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

Sign in to reply

Verify Answer

Cancel

Reply

0 Andrew P Gramann
Certified Lead Developer
over 10 years ago

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

Sign in to reply

Verify Answer

Cancel

Children

No Data