Sql Server Reporting service. 1.first query I have given a task of generating reports using sql server reporting service.I need to generate a summary view as below, Fig:1 Jan-08 Feb-08 Mar-08 Bug Trend ECR 3.88 4.06 3.86 Goal 5.00 5.00 5.00 Backlog 70 75 82 Incoming67 71 55 Outgoing62 65 56 Outstanding75 82 81 But in SSRS I am able to generate the view as below, Fig2: ECR Goal Backlog Jan-08 3.88 5 67 Feb-08 4.06 5 75 Mar-08 3.86 5 82 Please let me know if I will be able to generate report as in the Fig1. 2.Second query regarding calculation Set @startdate=’1/1/2008’ Set @lastdate=’3/31/2008’ ---ECR— Select count(component) as ECR from table where resolved_date between @startdate and @lastdate group by month([resolved_date]) ---same query for backlog,incoming,outgoing but with different “where condition”--- --outstanding— Select count(component) as outstanding from table where resolved_date>=@lastdate or resolved_date is null and assign_date<=@lastdate I need the output as Outstanding Jan-08 75 Feb-08 82 Mar-08 81 But getting the output for only one month using a single query,I am able to generate this output using loopingconcept.will it be possible without looping?? As this looping will generate a temporary table,it is not supported in Sql server 2005 reporting service.i need an alternate method to display this output that should be supported in sql server reporting service. Please help me resolving the same.

Software/Hardware used: