Hi all,
I want to extract all the data of table (multiple table) and export to excel and generate report and then email. we don't have CDT we use record type. please help me how to extract data from record type or database and export to excel, generate report & email.
What i have tried: I used Export SQL to Excel plug in with sql query and Jndi name which is my data source but it is throwing me error as "The following error was raised by the Export to Excel function: null".
Please help me to resolve this issue or if there is any other way let me know.
Thanks
Discussion posts and replies are publicly visible
Create database view that consolidates data from multiple tables, then export it using Export Data Store Entity to Excel smart service and email the file.
Export data store entity to excel smart service won't work because we don't have Data store and data type. we have only record type.
Are you using community edition?