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 : 2100 | Status : [Member] | Replies : 3

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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

Attachment

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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

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

0	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

0	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

Latest Posts