How to collapse/expand columns in subreport for which toggle is on main report header on one of the columns?
Hi All, I have got a strange case in one of my report which has a subreport. I have added a toggle setting for 3 columns, which can expand/cpllapse. The +/- symbol is on 4th columns which controls this collapse/expand. Now I have a subreport in this report which ha same number and identical columns, but values are different. So the problem is when I collapse/expand the three columns in parent report, this toggle is not reflecting to the columns in subreport. I want to collapse columns in subreport, when they are collapsed in parent report. It would really helpful if I get this happen. Please help me. Thanks, Balu
May 13th, 2011 5:16pm

Hi, Generally the visibility toggle state would not be passing to the subreport. However, I noticed the subreport has same number and identical columns. So, please try to merge the dataset of the subreport to the main report if possible, and then you can achieve the requirement without using the subreport. Another workaround is to use parameter to control the column visibility instead of using toggle. We can first add the same parameter to both the main report and subreport. Then, set the Hidden property based on the parameter value, and also pass the parameter value of the main report to the subreport. For more information about Using Parameters to Control Report Appearance, please refer to http://msdn.microsoft.com/en-us/library/aa337155.aspx About How to Add a Subreport and Parameters, please refer to http://msdn.microsoft.com/en-us/library/ms160348.aspx Thanks, Tony Chain Tony Chain [MSFT CSG] | Microsoft Community Support Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Free Windows Admin Tool Kit Click here and download it now
May 19th, 2011 10:27pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics