Creating drill down on other specific column when you already have row groups and column group present in report?

• Ritesh_Dev

  Ten Centuries

  Points: 1299

  More actions

  December 1, 2011 at 7:20 am

  #251381

  I have a query in my report like this.

  SELECT T1.A1,T1.A2,T1.A3,T1.A4,T1.A5,T1.A6,T1.A7,T1.A8,T1.A9,T2.B1,T2.B2 FROM T1

  INNER JOIN T2 ON T1.A9 = T2.B3

  LEFT OUTER JOIN T3 ON T1.A10 =T3.C1D

  i have row groups on A2,A3,A4,A5 and column group on A6. Now I have to make drill down on A1(country name) and after trying every technique it's not coming.

  Can some one help in my case.

  Thanks

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  December 1, 2011 at 8:31 am

  #1415310

  Duplicate post. Replies here please: http://www.sqlservercentral.com/Forums/FindPost1214605.aspx

  -- Gianluca Sartori