Limit the fields sent to CSV from BAQ Report Designer

shobdy · November 4, 2020, 10:13pm

Hello,

How do you limit what fields go to CSV file when you preview CSV for a BAQ Report Designer?

Right now it brings over all the fields that have an expression.

Thanks,

Shawn

shobdy · November 5, 2020, 2:10pm

Does anyone have any ideas?

ckrusen · November 5, 2020, 3:40pm

You would need to make a duplicate BAQ but with only the columns you want exported.

If your BAQ needs calculated fields to function properly, but you don’t want to see them, then make the top level query an inner sub-query, and make a new query for the top level. The new top level would just contain the inner sub-query, and only the fields you want to be visible.