Books, Courses and Training about Reporting Service for dummies

Hi,

We have currently done one data ware house project with MS SQL server, reporting server, analysis server and integration server and the users are very happy with it (especially the speed).

The reports have been developed by a developer. I have years of experience in Visual studio, SQL, reports so I could do it very quickly. The users want to make their own reports so they need training. If I look at the requirements for most books and courses they are pretty hard. You must have some experience in SQL server. Or books are focussed on RS2000. Or the books could elapse the whole spectrum of SQL, ETL, cubes and reports or they go in to securing reports.

I think that is not the information that the users want to know. It should start with what is a cube, what are dimensions and what are facts. Then explain something in how do I get the information in excel. And then make reports in the visual studio environment (not the builder on the report server, but the report designer that comes with the client tools in visual studio). Keep in mind that they are not developers nor database administrators.

Any suggestions,

Constantijn Enders

Can u help to to solve my problem . Please excuse me for asking my doubt to u against ur queries. Becuase many time this question arised in the forum no one answer to me to find out the solution for my problem. So please help

I am using report builder thru LocalHost\Report . I want a drill through report by using Report Builder and cube . I created the report but unfortunatly I cannot create a drill through report using parameters .How can I pass parameter in report1 to jump into report2 .

When I running the report after giving drill through properties in report the following error will occure.

'The 'DrillthroughSourceQuery' parameter is missing a value

How can I create a report using parameter for drill down in report builder

I am expecting one answer from u expertise

Books on Integration Service

Hi,

I am new to integration service. Could anyone recommend a book on this area?

Thanks,

SQLIS.com has a list of SSIS books (http://www.sqlis.com/800.aspx)

There aren't a lot of choices. Both books (Professional SQL Server 2005 Integration Services and Microsoft SQL Server 2005 Integration Services) are good. The Professional book might be easier to start with.

|||

Has anyone read the Expert SQL 2005 Integration Services (Programmer to Programmer) yet? If so, is it any good... Does it teach you anything beyond what you would pick up in the Haselden or Professional books?

What about the Hands-On SQL 2005 Integration Services book? This looks more like a beginners book (which would be good to introduce new team members to SSIS) than anything, but is it any good?

Books on Integration Service

Hi,

I am new to integration service. Could anyone recommend a book on this area?

Thanks,

SQLIS.com has a list of SSIS books (http://www.sqlis.com/800.aspx)

There aren't a lot of choices. Both books (Professional SQL Server 2005 Integration Services and Microsoft SQL Server 2005 Integration Services) are good. The Professional book might be easier to start with.

|||

Has anyone read the Expert SQL 2005 Integration Services (Programmer to Programmer) yet? If so, is it any good... Does it teach you anything beyond what you would pick up in the Haselden or Professional books?

What about the Hands-On SQL 2005 Integration Services book? This looks more like a beginners book (which would be good to introduce new team members to SSIS) than anything, but is it any good?

book

Can you recommend a book on Integration services in sql server 2005?
ThanksProfessional SQL Server 2005 Integration Services (Wrox) Of course I'm biased, I'm a co-author.

Microsoft SQL Server 2005 Integration Services (Sams) It's not out yet but be sure to pick it up when it does come out. Kirk is on the SSIS team at Microsoft.
|||

Jason Gerard wrote:

Microsoft SQL Server 2005 Integration Services (Sams) It's not out yet but be sure to pick it up when it does come out. Kirk is on the SSIS team at Microsoft.

Sorry for digressing slightly. Kirk is no longer on the SSIS team (unfortunately). He's moved to OBA.

-Jamie

|||It seems the wrox version is the only one available at present ?|||

Correct. As Jason said, its not out yet.

-Jamie

|||The updated version of Donald's book The Rational Guide to Scripting SQL Server 2005 Integration Services would be available in a few weeks. The previous version was a Beta Preview.|||

Anjan,

Any idea what the differences are?

-Jamie

|||

>Any idea what the differences are?

Yeh, the code works against RTM. :-)

BTW, when discussing books, don't forget "The Microsoft Data Warehouse Toolkit" by Joy Mundy, Warren Thornthwaite, Ralph Kimball." It covers SSIS very effectively in the context of solving business and data warehouse problems.

Donald