Sub Columns under one column

• Raj Deep Alapati

  Ten Centuries

  Points: 1118

  More actions

  July 7, 2006 at 3:40 am

  #169094

  Hi,

  I do need to generate two sub columns under same column.i mean to say some thing like this

  Elapsed_Interval

  Date || Time

  06/06/06 12:00:00

  07/06/06 12:56:56

  Where Date and time are two sub columns which are based on the One column Elapsed_interval.

  How can i do it in the reporting services 2005

  If i write a query ,i can get date and time as two columns

  But i want to generate two column under same column

  Any ideas would be highly appreciated

  Thank you

  Raj Deep.A

• July 10, 2006 at 8:00 am

  This was removed by the editor as SPAM

• Duane Lynch

  Newbie

  Points: 3

  More actions

  July 12, 2006 at 6:34 am

  #648683

  Have you tried using a Matrix table in the report.  That allows you to have 2 columns underneath one column, if I understand your question.  Could look something like this but without the lines..

  Top Column
  Value 1	Value 2

   

  Matrix tables allow you to build reports like this pulling data from a db....hope this helps....

  D

• Peldin Fernandes

  SSC Enthusiast

  Points: 186

  More actions

  July 16, 2006 at 11:18 pm

  #649453

  Hi Rajdeep,

  you can have two columns and then merge the columns in the table header, as a result of which you have two visibly seperate columns just grouped on the header.

   

  Regards,
  Peldin Fernandes