I have a report showing a publisher/supplier relationship. The master is a simple table report grouped by publisher. There is a drill down on the table, which then shows a breakdown grouped by supplier. Both master and detail report tables have the same columns.
Want I want to do is have a toggle on the master report that can hide particular columns. I have achieved this on the master report by having a textbox with a toggle visibility action - if it is , certain columns disappear, but of course, if the user drills down to the supplier details, the columns are still displayed in the sub-report.
Is there any way of setting up a toggle visibility option that will affect both the master and detail reports?