Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win


SSRS reporting

Posted on 2010-11-30
Medium Priority
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).
Question by:newjeep19
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
LVL 18

Expert Comment

ID: 34239425
For SQL reports use "BIDS" not visual studio.

install the client tools

Author Comment

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

Author Comment

ID: 34239545
I don't think that BIDS is avaiable (business intelligence development studio) with VS2010....is it? I have not found it
New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

LVL 18

Expert Comment

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".


Author Comment

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

Author Comment

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?
LVL 18

Accepted Solution

x-men earned 2000 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.

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

How to use Variables  and Custom code in SSRS report and Assembly reference to use compile shared code in SSRS. Its big question for all who are working with SSRS. It is easy to create assembly and refer in SSRS report, still there are some steps…
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…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

604 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