Solved

SSRS reporting

Posted on 2010-11-30
7
892 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
Comment Utility
For SQL reports use "BIDS" not visual studio.

install the client tools
0
 

Author Comment

by:newjeep19
Comment Utility
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
Comment Utility
I don't think that BIDS is avaiable (business intelligence development studio) with VS2010....is it? I have not found it
0
What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 
LVL 18

Expert Comment

by:x-men
Comment Utility
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
Comment Utility
I don't think Bussiness Intelegnece Design Studio is avaiable in VS2010? Is it?
0
 

Author Comment

by:newjeep19
Comment Utility
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
Comment Utility
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

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

In this short article I will be talking about two functions in the SQL Server Reporting Services (SSRS) function stack.  Those functions are IIF() and Switch().  And I'll be showing you how easy it is to add an Else part to the Switch function. T…
A recent question popped up and the discussion heated up regarding updating a COMMENTS (TXT) field in a table using SSRS. http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Q_27475269.html?cid=1572#a37227028 (htt…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

763 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

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now