Export Default to Visible Columns Only?
I have a query table that aggregates data from several different table. I wish to create multiple reports from this table with different fields visible for different reports. I want to hide different columns in the various reports and then want to be able to export them as PDF's, but I don't want to have to re-check which columns I want to export each time I run the report. Is there a way to accomplish this? I should say that the base query table is already 3 layers deep, so I can't create new queries based on it. I also need to base the reports off of a single query because that query may change and I need to be able to only change it once (vs. in multiple queries). Thank you.