I have a table with value column. Already I have implemented download link in my report based on the table.
I need to add a new column with formatted value, front end I have done this, but download part, how can I manage(I dnt want to change backend table)
Discussion posts and replies are publicly visible
The Export Data Store Entity to Excel smart service does not allow you to format a data.
Two ways you can try,
1. Using the Export Record List functionality as that allows you to export the same format you see on the record list itself.
2. Use Export CDT to Excel smart(deprecated) If its already in your environment. (The only way of getting this would be to get an old version (2.0.0 or earlier) of the Excel Tools plug-in)https://community.appian.com/discussions/f/general/17467/feature-request-update-the-export-data-store-entity-to-excel-smart-service-to-accept-an-excel-base-templatecommunity.appian.com/.../export-cdt-to-excel
Hello kathirm0790,
You can use the export SQL to excel smart service to do this.
Create an expression rule that will contain the select statement and all the columns that you need in the excel sheet.
Call this rule in the SQL statement of the Smart service.
I hope this explanation is understandable.
You may try using Custom Cell Positions and Custom Cell Values using Export Data Store Entity to Excel Smart Service.