I have a layout that contains a Reports table in a portal. This Reports table includes additional unique IDs, such as the following:
For the Region IDs, I have an additional "Regions" table that list the IDs and corresponding values (names):
The Reports table (top one) is viewed as a portal from another layout that provides controls for filtering the portal data. I would like to export the report table as seen in the portal (ie, filtered, sorted, etc.) to a CSV file, such that the CSV includes looked-up features like the following:
When using exporting options, I get the top-most table as the output (ie, with Region ID number values) instead of the bottom one with corresponding names. Is it possible to create an export routine that does this lookup and generates the CSV with the text names instead of the ID data that is in the table? I could do this with SQL queries, but the ExecuteSQL option doesn't appear to work on local tables, and only does so on external ODBC data sources.