| Author |
Topic |
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
 Posted - 2005-04-20 : 03:09:54
|
| I'm not a developer in the sense that I'm not that familiar with VS and don't know ASP.NET. (Though I did occasionally use VB's 4-6 some time ago) and I don't have access to a developer.In addition I need to get reporting services up and running as our current reporting system is appaling.What are my best options for getting up to speed with this. Training (if so which training), books (if so which), hire a developer (probably cost far too much), anything else? Essentially it's down to me and another team member. Would we be best off doing the same courses or different ones and sharing knowledge?thankssteveA sarcasm detector, what a great idea. |
|
|
jhermiz
3564 Posts |
Posted - 2005-04-20 : 10:31:50
|
I really learned it by playing around with it. Books didnt help much, much of it is the same stuff over and over.Microsoft's site should get you up and running, installation isn't too difficult. If you are not comfortable with VS and .netthan it might be a bit tricky, but really learning comes by doing.
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]Imperfection living for perfection -- [url]http://jhermiz.blogspot.com/[/url] |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-04-20 : 11:27:07
|
| I was going to suggest that elwoos flew you over and bought you a few beers!Kristen |
|
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2005-04-20 : 13:43:29
|
| Steve,I have a copy of The Rational Guide to SQL Reporting Services, which is a small, $10 book and gets things started. Not sure that it covers anything that's not already available online through MSDN, but maybe in a more friendly way. We also have here a copy of the Hitchhiker's Guide to SQL Server 2000 Reporting Services, which has served as a decent reference for a few questions I've had. You don't need to understand .NET programming to do SSRS, but you do have to have a 2003 or later version of the Visual Studio IDE (or there's probably a free spin-off IDE out there somewhere). And of course there are a couple blogs on the subject you might want to browse.-----------------------------------------------------------------------------------------------Emerald City Domains: Great deals on Domain Registration, Web Hosting, Custom Email, and more! |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-04-20 : 13:47:47
|
| I've been using RS for about a year now. Prior to that, I'd never even done any reporting or worked inside Visual Studio. It took me a couple of days to get up to speed. I just created a few reports using the wizard to get myself started, took a look at the sample reports provided by MS, then started creating the reports from scratch (without the wizard). I've now got several complex reports in production. 4 of them call .NET assemblies, a few of them have embedded code, all of them use expressions galore and stored procedures, etc... Just dig into it and you'll see that you should be able to get up to speed quickly. There isn't a lot of useful information on the Internet yet as not to many people are using it, but you can ask questions here and we should be able to help you out. Also, don't get too upset about the lack of documentation inside BOL for RS. It sucks!Tara |
|
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2005-04-20 : 19:11:28
|
| Tara, I have to agree that I have been less than impressed by the BOL content. Just to make sure everyone knows, Reporting Services has its own BOL, but it's not quite up to the standards of SQL BOL. Download/Update it here.-----------------------------------------------------------------------------------------------Emerald City Domains: Great deals on Domain Registration, Web Hosting, Custom Email, and more! |
|
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2005-04-21 : 02:55:36
|
| OK thanks for that guys.What about installation and configuration, I take it that there is nothing in there that's rocket science. I suppose that one of my biggest concerns would be about security. Is that handled by a combination of IIS and SQL Server? SteveA sarcasm detector, what a great idea. |
|
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2005-04-21 : 14:00:18
|
| What part of security? Within the Report Manager you can setup permissions to run reports based on RS roles and Windows logins/groups. As for data access, each report has to have a Data Source, either internally or referencing a Shared Data Source (which I highly recommend). That data source can connect to SQL Server or whatever source system in the usual ways with all the security issues that go along with any database connection.---------------------------EmeraldCityDomains.com |
|
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2005-04-22 : 03:08:03
|
| I suppose what I was getting at is this. The reports would be on the company intranet but I only want users from within one department to use them(sounds from what you say as though that is done in report manager)A sarcasm detector, what a great idea. |
|
|
|
jhermiz
3564 Posts |
Posted - 2005-04-22 : 08:38:40
|
You can create groups much like windows nt authentication. You assign people from your domain to specific groups..or you can do individuals per report.It's all in report manager you are correct.
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]Imperfection living for perfection -- [url]http://jhermiz.blogspot.com/[/url] |
|
|
|
|
well developed