SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 Reporting Services questions for a beginner		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

mldardy
Starting Member

13 Posts
Posted - 04/20/2012 :  01:36:50  Show Profile  Reply with Quote
I am very new to Reporting Services and have a few questions about it's usage.

I've done some research on using SSRS in VS2010 and getting mixed signals that it can be used in VS2010 is that true?

IF you can use it in 2010 can you use it if you have SQL Server 2005 and how would you get started, is it as simple as starting a New Project and go from there?

THe purpose for these questions is I want to create reports in SSRS and want to know what it's capability are with what I have. The reports I'm creating will go on our website and are user sensitive so is there a way to create these reports based on the users login. Each user has certain areas of the website they can view and other areas they can't. I want to configure these reports the same way but I don't know if that is something that needs to be setup in SSRS when building the reports or if what the users login credentials on the existing site will control the reports once they are on the site.

Hopefully this makes some sense to someone and can assist me with these questions.

Thanks

visakh16
Very Important crosS Applying yaK Herder

India
47173 Posts
Posted - 04/20/2012 :  15:43:05  Show Profile  Reply with Quote
vs 2010 will not support ssrs 2005 reports so if you want to use them in vs 2010 you need to upgrade them first. Also this should rdlc file not rdl as VS 2010 currently supports only local reports (.rdlc) and not reporting project report (rdl) as such. Reason is that the reporting project type is not something native to Visual Studio, but its rather a component of the Business Intelligence Development Studio (BIDS), which is a VS add-on installed by the SQL Server installer - if you choose to install it during SQL Server setup. You will use it to create reports for publishing to a Reporting Services report server or to SharePoint.BIDS for the latest version (SQL Server 2008 R2) still uses VS 2008, and is not compatible with VS 2010. Besides, even if you already have VS 2008, you still won't have those project templates unless you install BIDS specifically from the SQL Server installer.



------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000