Tabular format report

• malasamy 62007

  SSC Rookie

  Points: 40

  More actions

  August 31, 2011 at 11:52 pm

  #256462

  Hi ,

  I would like create a Tabular format report.Suppose If I choose a parameter stardate is 1/1/2011 ,end date is 31/3/2011 and the device Id =1 means, based on those parameter ,I need to filter the data and display energy consumption of each day like below

  ------------------------

  Jan

  day1 day2 day3 day4................... day 31 total mon consumption

  value

  -----------

  Feb

  day1 day2 day3 day4................... day 28 total mon consumption

  value

  --------

  Mar

  day1 day2 day3 day4................... day 28 total mon consumption

  value

  ----------------

  Each month data into one table format.That means based on the above parameter I have to see 3 Tables with data.Each Table heading should be the same. How to generate this kind report in SSRS 2005 ?

  How to generate this kind report in SSRS 2005 ?

  Thanks

• Daniel Bowlin

  SSC-Dedicated

  Points: 34566

  More actions

  September 1, 2011 at 2:48 pm

  #1376190

  Sounds to me like you ought to do this in a single matrix

• malasamy 62007

  SSC Rookie

  Points: 40

  More actions

  September 1, 2011 at 8:26 pm

  #1376244

  Hi,

  Thanks .How can I create column headings dynamically? For example jan month means 1 to 31,feb 1to 28 some times 1 to 29.How can I do this?

• durai nagarajan

  SSCoach

  Points: 15778

  More actions

  September 15, 2011 at 7:43 am

  #1381960

  Prepare the data (date wise) in tabular format and add it in matrix automatically it will populate.

  your date fields has to be in row heading and other heading in either column or row.

  hope this helps

  Regards
  Durai Nagarajan