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
Welcome to the forums. You could try using PIVOT table type (just my guess), see these links for information http://msdn.microsoft.com/en-us/library/ms167305(v=SQL.90).aspx and http://technet.microsoft.com/en-us/library/aa337432(SQL.90).aspx.