Is it possible to download/export data in Excel with an specific structure/reporting format?

Question

it is required that outcome produce by the app can be extracted with a specific reporting format for regulators?, Excel and PDF for extracted data is expected.
The idea is to avoid any manual manipulation of the output/final report

mikes0011 · Answer

Export DSE to Excel is the current most-supported method of dumping data into an excel (despite its drawbacks, which some would find to be dealbreakers).  Since there's no way of manipulating the data between query from the DB and generation of the Excel file, it's recommended to create a DB View that does any preformatting you want on your data.

Sign up

Login with SSO

Login to the community

Login with SSO