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

rupakj

A Score Level 1

over 9 years ago

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. .Any help would be appreciated.
Regards,
Rupak Jha

Discussion posts and replies are publicly visible

Parents

0 Tom Ryan
Appian Employee
over 9 years ago

It looks like you are now getting the expected result. To format your output, you will need to use a rule to map the user and group names to string values (as discussed in your last post here forum.appian.com/.../e-154326 ). Since this is a portal report, you will need to do this inside the process and store the string result as a process variable. Then, include the process variable as column of type 'Normal Text' in the report.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Tom Ryan
Appian Employee
over 9 years ago

It looks like you are now getting the expected result. To format your output, you will need to use a rule to map the user and group names to string values (as discussed in your last post here forum.appian.com/.../e-154326 ). Since this is a portal report, you will need to do this inside the process and store the string result as a process variable. Then, include the process variable as column of type 'Normal Text' in the report.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data