sql reports

5 pts.
Tags:
SQL Server reporting
SQL Server Reporting Services
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.

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following