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

bit off topic: street name database US

I'm thinking of doing some basic parsing of address. I want to seprate
out the house number from the street name from the suffix. I have the
suffix's from the USPS, but I cant find a database of US street names.
Anyone come across one or know where I can get one?
TIA
Rob
/end off topic"rcamarda" <rcamarda@.cablespeed.com> wrote in message
news:1127439693.974508.70290@.o13g2000cwo.googlegro ups.com...
> I'm thinking of doing some basic parsing of address. I want to seprate
> out the house number from the street name from the suffix. I have the
> suffix's from the USPS, but I cant find a database of US street names.
> Anyone come across one or know where I can get one?
> TIA
> Rob
> /end off topic

Its probably not in a convenient format, but you could try parsing
streetnames from TIGER data - www.census.gov/geo/www/tiger/index.html. TIGER
data is used by a lot of applications and is free. They might do a separate
street name download, but I couldn't get to the site when I tried just now
to look.

Hope this is useful.
--
Brian Cryer
www.cryer.co.uk/brian|||Brian,
That did the trick, thanks! I found the detail files in Tiger located
here: http://www.census.gov/geo/www/tiger.../tgr2004se.html
I used GETRIGHT to download all the zip files (over 1,600). There is a
ton of data that I dont need, ill just use SQL to keep the unique
street names. I plan to get all the unique street names and all the
street suffixes. If anyone is interested in the data when I'm done,
post and I'll send you the info.

After I get all the text data loaded, my next step will be parse out
the addresses, so I'm sure I'll be posting in this group again!

Cheers,
Rob