Hello all,
I have a report that has 2 columns populated from prompted selection, when i export the report to CSV those 2 columns disappear. I have tried using singleton, and report expressions to no success. Does anyone know how to do this?
Sincerely,
Anders
Quote from: andershedin on 21 Mar 2023 08:01:51 AM
Hello all,
I have a report that has 2 columns populated from prompted selection, when i export the report to CSV those 2 columns disappear. I have tried using singleton, and report expressions to no success. Does anyone know how to do this?
Sincerely,
Anders
Hi,
When you export to csv, you get only the items defined in the first query of the report in your output - not what is defined on the page. Can you add the items you need to the first query?
Cheers!
MF.
Thank you for your reply. These 2 columns are prompt selections. As in "Select Date".
This is a SQL based report, im going to try to move the parameters to the sql query with a prompt macro and see if that does it.
Sincerely,
Anders
Quote from: andershedin on 21 Mar 2023 12:58:27 PM
Thank you for your reply. These 2 columns are prompt selections. As in "Select Date".
This is a SQL based report, im going to try to move the parameters to the sql query with a prompt macro and see if that does it.
Sincerely,
Anders
That ought to work!
MF.