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 SSAS 2005....

Hi,

I will be very happy if anyone can suggest me a very good book (preferably microsoft press book) on SQL Server Analysis Services 2005 (SSAS 2005). I mean hard copy. I want to know the in and out of SSAS 2005......so i will be thankful if im suggested some good book on it.

Expecting your reply soon!!!!!

TIA,

Shaun Michael

Hi Shaun,

I'm currently reading the following books and I think they are pretty good.

- Applied Microsoft Analysis Services 2005

- Delivering Business Intelligence with Microsoft SQL Server 2005

Those books cover the whole Microsoft BI Platform (SQL,SSAS,SSIS and RS) and not only SSAS.

HTH,

Eric

|||

Hi Shaun,

Chris Webb has compiled a list of AS 2005-related books on his blog - some of which may not yet be available:

http://spaces.msn.com/cwebbbi/Blog/cns!1pi7ETChsJ1un_2s41jm9Iyg!322.entry

|||

I think these books sound good.

Thanks a lot Eric & Deepak.

sql

book samples

Hi

Does someone have the booksamples for the book: analysis services 2005 step by step

Thank

Avecinna

All the samples should be on the disk that comes with the book.

Bryan

book samples

Hi

Does someone have the booksamples for the book: analysis services 2005 step by step

Thank

Avecinna

All the samples should be on the disk that comes with the book.

Bryan

Blocking in Analysis Services

We have a report in Reporting Services that connects to a Cube. The report has 4 input parameters that are also derived from the same cube. If the report is running and another user tries to select the drop downs for the report or runs just the query portion in report designer, the query will not return until the report has finished. It looks like the report is creating some type of wait. Has anyone ran across something like this?You are in the wrong forum. Moving to Reporting Services forum first.