SQL Server Performance

Tabular format report in SQL 2005

Discussion in 'SQL Server 2005 Reporting Services' started by vinya, Aug 31, 2011.

  1. vinya New Member

    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 ?


    Thanks & Regards,
    vinya
    How to generate this kind report in SSRS 2005 ?


    Thanks & Regards,
    vinya
  2. satya Moderator

Share This Page