?
Solved

SSRS reporting

Posted on 2010-11-30
7
Medium Priority
?
909 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
[X]
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
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
Enroll in August's Course of the Month

August's CompTIA IT Fundamentals course includes 19 hours of basic computer principle modules and prepares you for the certification exam. It's free for Premium Members, Team Accounts, and Qualified Experts!

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

Featured Post

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

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

Written by Valentino Vranken. A while ago I wrote an article called Chart Optimization Tips (http://www.experts-exchange.com/articles/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Chart-Optimization-Tips.html).  This article explained how …
Introduction As you'll probably know, a data region in a SQL Server Reporting Services report can be linked to only one dataset.  This makes it troublesome when you need to display data from more than one dataset in the same data region.  SQL Serve…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
Suggested Courses

801 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