Our app has around 60 questions in each case and the requirement is to generate an excel report which contains a list of cases resolved in the last 7 days along with all the questions and responses. The problem here is that for almost 30 questions, we have configured the source as data page and the display text on ui is different from the value stored in clipboard/database.
When we export data of cases to excel, the standard values would only be exported and not the display text/prompt value. For all the questions, I have to explicitly add code to retrieve the prompt values from the table using a data page and this might take a hit on the performance since the report contains hundreds of cases. Is there a simpler way to export the prompt values to excel?