Toggle or hide/show columns as per drill down based on Group

Posted by hareeshkumarkr-16190 under Sql Server on 8/8/2014 | Points: 10 | Views : 830 | Status : [Member] | Replies : 3
Hi All,


I have requirement to not show all the column on report load. I should show columns only once click on the Group name.

e. g :

initially
+Mysore
Name
sachin
kumar
rama

after Click on Mysore or + I want to show stdcode

+Mysore
Name stdcode
sachin 080
kumar 0821
rama 567

image file has been attached for your reference

Thank you




Responses

Posted by: Bandi on: 8/8/2014 [Member] [MVP] Platinum | Points: 25

Up
0
Down
I guess you have one Row Group on Mysore and so many cities ( Suppose you have Row Group Name as RowGroup1).....

Then Select the Column STDCode Column TextBox -- > Right-Click on that TextBox --> Go to TextBox Properties --> Left Side you will get General, Alignment, Font, Fill and Visibility options --> Choose Visibility Tab --> You will get below options

1. When the report is initially Run
* Show
* Hide
* Some Expression
Here select Hide radio button
2. select checkbox ( Disaply can be toggled by this report item)
in the expression Box, Choose STDCode Column name

And then click on OK


Go ahead with Report Preview

Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif

hareeshkumarkr-16190, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Bandi on: 8/8/2014 [Member] [MVP] Platinum | Points: 25

Up
0
Down
Refer
http://msdn.microsoft.com/en-IN/library/dd220405.aspx
http://www.mssqltips.com/sqlservertip/1329/drill-down-techniques-in-ssrs-with-the-visibility-property/

Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif

hareeshkumarkr-16190, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Bandi on: 8/28/2014 [Member] [MVP] Platinum | Points: 25

Up
0
Down
Mark as Answer if got clear idea/solution...

Post us back the issue/doubts if not resolved the issue

Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif

hareeshkumarkr-16190, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response