CSV output removing prompt generated values

[andershedin]

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

[MFGF]

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.

[andershedin]

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

[MFGF]

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.