Solved

SSRS reporting

Posted on 2010-11-30
7
899 Views
Last Modified: 2012-05-10
I need to create a SSRS Report in Visual Studio 2010. What are the steps to do so. The Wizard does not allow for you to build a query. I had the query pass on to me to create the report. How do I take the already built query (passed to me via email) and create the rdl (report).
Thanks
0
Comment
Question by:newjeep19
  • 4
  • 3
7 Comments
 
LVL 18

Expert Comment

by:x-men
ID: 34239425
For SQL reports use "BIDS" not visual studio.

install the client tools
0
 

Author Comment

by:newjeep19
ID: 34239493
Sorry thats not an option. I wish I could. I wish that I could go back and use VS2005 for ssrs reports,but I can't
0
 

Author Comment

by:newjeep19
ID: 34239545
I don't think that BIDS is avaiable (business intelligence development studio) with VS2010....is it? I have not found it
0
MIM Survival Guide for Service Desk Managers

Major incidents can send mastered service desk processes into disorder. Systems and tools produce the data needed to resolve these incidents, but your challenge is getting that information to the right people fast. Check out the Survival Guide and begin bringing order to chaos.

 
LVL 18

Expert Comment

by:x-men
ID: 34239586
no, you have to install BIDS from the SQl server CD (or what ever source you have).

truste me, "been there, done that".

0
 

Author Comment

by:newjeep19
ID: 34239634
I don't think Bussiness Intelegnece Design Studio is avaiable in VS2010? Is it?
0
 

Author Comment

by:newjeep19
ID: 34239676
OK I trust you.....can I install VS2008 that does support BIDS ..... my issue is I am running everything off my lab top (small shop) and I don't want the full version of SQL 2005 or VS2008. So, can I just run the BIDS off of one of those? Or prehaps use the interpeise version?
Thanks,
-Ryan
0
 
LVL 18

Accepted Solution

by:
x-men earned 500 total points
ID: 34239858
forget Visual Studio.

Load SQL server cd (run setup from net share...) choose the workstation and client tools (or equivalente in 2005 or 2008, cant remenmber the exact name).

you dont have (and cant unless your run Windows server) to install the server itself.
0

Featured Post

How Do You Stack Up Against Your Peers?

With today’s modern enterprise so dependent on digital infrastructures, the impact of major incidents has increased dramatically. Grab the report now to gain insight into how your organization ranks against your peers and learn best-in-class strategies to resolve incidents.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction Earlier I wrote an article about the new lookup functions (http://www.experts-exchange.com/A_3433.html) that ship with SQL Server 2008 R2.  In this article I’m going to show you another new feature of SSRS 2008 R2, this time in the vis…
It is helpful to note: This is a cosmetic update and is not required, but should help your reports look better for your boss.  This issue has manifested itself in SSRS version 3.0 is where I have seen this behavior in.  And this behavior is only see…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

713 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question