This is a migrated thread and some comments may be shown as answers.

Toggle Visibility for Master and Sub Report?

2 Answers 110 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Martin
Top achievements
Rank 1
Martin asked on 16 Nov 2016, 04:02 PM

Hi there,

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?

Kind Regards,
Martin.

2 Answers, 1 is accepted

Sort by
0
Martin
Top achievements
Rank 1
answered on 16 Nov 2016, 04:37 PM

OK - so I've found a way of doing it with Report Parameters. I have a boolean report parameter in both the master and detail report, which is then linked to the conditional formatting of the columns in question.

This does the job, though obviously you have the spin up the report each time you change the parameter - I would like the toggle visibility function to work across the reports if that's possible...

0
Katia
Telerik team
answered on 17 Nov 2016, 03:41 PM
Hi Martin,

Each time you change report parameter value and click Preview button the report will be refreshed. Additionally, you can set Autorefresh=True in report parameter's settings to automatically refresh the report.

For toggling the visibility of the report items, you can also use ToggleVisibilityAction. In this case, the report item that you use for the toggle visibility action must be in a containing scope that controls the item that you want to show or hide (for example, parent/child groups in the table).


Regards,
Katia
Telerik by Progress
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Tags
General Discussions
Asked by
Martin
Top achievements
Rank 1
Answers by
Martin
Top achievements
Rank 1
Katia
Telerik team
Share this question
or