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 Online Updates: are they cumulative?

Does anyone know, please, if BOL 2005 updates are cumulative (like
service packs) or incremental? On a fresh re-install do I need to
install the April update and then the July update, or will the July
update include what's in the April update?They are full nlown installations, you don=B4t need to install them all
incrementally.
HTH, jens K. Suessmeyer.
--
http://www.sqlserver2005.de
--|||Thanks, Jens

books online tutorial - why am i getting an error?

Hi,
I am doing the MSDN Online tutorial "Accessing the Report Server Web Service
Using Visual Basic or Visual C#".
However, when I come to the 3rd step, Accessing the Web Service, and use the
supplied code, I get an error saying
"Namespace or type specified in the Imports
'GetPropertiesSample.ReportService2005' doesn't contain any public member or
cannot be found. Make sure the namespace or the type is defined and contains
at least one public member. Make sure the imported element name doesn't use
any aliases."
and
"Type 'ReportingService2005' is not defined."
This happens when using C# or VB.
What I am doing wrong?
ThanksSorry, I forgot to rename my project to GetPropertiesSample.
Works ok now.
"PacMan" wrote:
> Hi,
> I am doing the MSDN Online tutorial "Accessing the Report Server Web Service
> Using Visual Basic or Visual C#".
> However, when I come to the 3rd step, Accessing the Web Service, and use the
> supplied code, I get an error saying
> "Namespace or type specified in the Imports
> 'GetPropertiesSample.ReportService2005' doesn't contain any public member or
> cannot be found. Make sure the namespace or the type is defined and contains
> at least one public member. Make sure the imported element name doesn't use
> any aliases."
> and
> "Type 'ReportingService2005' is not defined."
> This happens when using C# or VB.
> What I am doing wrong?
> Thanks

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?

Blocked sleeping active connections

Hi

We just installed SQL service pack 4. I am now finding that when doing a sp_who2 active, there are a lot of connections that are blocked by itself. The common factor is they all have a status of 'sleeping'. The strange thing is that even though it shows the connection is blocked, it is in fact not and will still return results. Below is a snapshot of a portion of what the sp_who2 active returns:

SPID Status Login HostName BlkBy DBName
53 sleeping sa TRACKER 53 dbABC
58 sleeping sa TRACKER 58 dbCDE
64 sleeping sa TRACKER 64 dbSTA
66 RUNNABLE User12 PC24 . master
70 sleeping User5 ANALYSIS 70 dbBML
74 sleeping sa TRACKER 74 dbCDE
76 sleeping sa TRACKER 76 dbPTS
83 sleeping User5 ANALYSIS 83 dbANA
86 DORMANT User11 CPTDB . NULL

Has anyone seen this? Is it related to the installation of service pack 4? (We have installed the services pack on many other SQL servers, but have not come accross this before.

Tx,
TessZAThe "self-blocking spid" is a new feature of SP4. In short, it is not actual blocking. If a spid is waiting on a latch, it shows as blocking itself. I have not seen it on this scale, though. Do you happen to know if you are suffering a lot of disk activity around the times that a lot of self-blocking spids are showing up?

Blank space in Folder Name causes web service error

Hello,
When I try to pull a report via the RS web service from a folder
with a space in the name (i.e. "My Folder"), an error stating the
report cannot be found is thrown. If I rename the folder to "MyFolder"
then it works fine. I tried using %20 instead of the space in the path
setting but this does not work. Is there a way to allow having a space
in the folder name? We have many folders and need the ability to name
them with multiple words seperated by spaces.
Thank youTry using a '+' in place of spaces
ie. My+Folder
On Aug 22, 11:19 am, daves...@.hotmail.com wrote:
> Hello,
> When I try to pull a report via the RS web service from a folder
> with a space in the name (i.e. "My Folder"), an error stating the
> report cannot be found is thrown. If I rename the folder to "MyFolder"
> then it works fine. I tried using %20 instead of the space in the path
> setting but this does not work. Is there a way to allow having a space
> in the folder name? We have many folders and need the ability to name
> them with multiple words seperated by spaces.
> Thank you|||On Aug 23, 10:01 am, Jen <jlan...@.gmail.com> wrote:
> Try using a '+' in place of spaces
> ie. My+Folder
> On Aug 22, 11:19 am, daves...@.hotmail.com wrote:
>
> > Hello,
> > When I try to pull a report via the RS web service from a folder
> > with a space in the name (i.e. "My Folder"), an error stating the
> > report cannot be found is thrown. If I rename the folder to "MyFolder"
> > then it works fine. I tried using %20 instead of the space in the path
> > setting but this does not work. Is there a way to allow having a space
> > in the folder name? We have many folders and need the ability to name
> > them with multiple words seperated by spaces.
> > Thank you- Hide quoted text -
> - Show quoted text -
We tried using a + instead of space but still no joy.

BIP Portal

Hi everyone,

I've just installed the BIP portal on an Application Server running Windows 2000 with the latest Service Pack and I choose to install the BIP database on a database Server. I've put my user in the BIP_ADMIN on the Application server's local windows user-group and also in the BIP_USERS role on the database BIP. If I try to browse the URL on the the application server it works well, but when I try to browse from my local machine thorough the network I get the following message: User 'AGFBRASIL\GAVieira' do not currently have access to the database. Please add the user to 'BIP_USERS' user group on SQL server's machine or contact the system administrator.

Anyone could help me?

Thanks in advance,

Genilson from So Paulo, Brazil.Hi Paulo
Try to connect to the database from your local computer without BIP.
Thanks,
Igor

Originally posted by gavieira
Hi everyone,

I've just installed the BIP portal on an Application Server running Windows 2000 with the latest Service Pack and I choose to install the BIP database on a database Server. I've put my user in the BIP_ADMIN on the Application server's local windows user-group and also in the BIP_USERS role on the database BIP. If I try to browse the URL on the the application server it works well, but when I try to browse from my local machine thorough the network I get the following message: User 'AGFBRASIL\GAVieira' do not currently have access to the database. Please add the user to 'BIP_USERS' user group on SQL server's machine or contact the system administrator.

Anyone could help me?

Thanks in advance,

Genilson from So Paulo, Brazil.|||Hi Igor,

Ok, I've already tried and it worked well. I think the problem is with BIP application.

Thanks,

Genilson|||Then ensure the defined user 'AGFBRASIL\GAVieira' has required privilege on SQL side to connect to the database.|||Hello Satya,

Yes. This user is owner of the database.|||May try the BIP site for any information for this behaviour.|||Hello gavieira

I've got the same problem and
thread http://www.dbforums.com/t803897.html
( after translation from German ;)
helped me to solve it partially

I've created login BIPuser on SQL Server with PUBLIC access to
BIP database (it turned out that BIP_USER role membership isn't neccessery in my case)
and modified web.config in BIP directory on IIS

<add key="Authentication" value="SQL" />
<add key="UserID" value="BIPuser" />
<add key="Password" value="password" />

The problem IMHO concerns failed delagation for user logged into application server through IIS to SQl on another server - it tries to connect as nt anonymous

I'll also be greatfull if gurues suggest more appropriate solution|||If you're using nT authentication then ensure IIS is configured to use the same, if not ensure login used has necessary privilege to access SQL from IIS>