Sql Server Reporting service.
I have given a task of generating reports using sql server reporting service.I need to generate a summary view as below,
Jan-08 Feb-08 Mar-08
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,
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
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”---
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
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.