SSRS Report Hide columns

• PSB

  SSChampion

  Points: 13195

  More actions

  August 27, 2013 at 1:38 pm

  #281725

  Hi All,

  I have a report with 4 columns say CompanyName , AccountNo, Date, Amount

  CompanyName CompanyNumber

  +A1 3000

  +A2 2000

  When I click +A1 or +A2 it should expand like below along with 3 more new columns..(aCCOUNTnO,dATE,aMOUNT). However these 3 columns should be hidden during the first report run. When the user clicks on +A1 , we should be then able to view these columns only.

  Please help.

• Koen Verbeeck

  SSC Guru

  Points: 259115

  More actions

  August 27, 2013 at 1:51 pm

  #1645333

  Here's a quite lengthy article:

  Your First OLAP Report[/url]

  Somewhere at the end, it is explained how you can realize your request.

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP