Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mldardy
Starting Member
13 Posts |
 Posted - 2012-04-20 : 01:36:50
|
| 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
52326 Posts |
Posted - 2012-04-20 : 15:43:05
|
| 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 MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
Reporting Services questions for a beginner