Grant Database Access

I am setting up report services after I installed the report server add-ins
on sharepoint 2007.

at first step, Reporting services integration, I put
report server web service URL -- http://ssrsdev1/reportserver
authentication mode -- windows authentication
it went OK.

at second step, Grant Database Access,
I put ssrsdev1 for server name (default instance) and then click OK and then
I put the user name (a member of local admin group on ssrsdev1) and password,
but I always got errors says:
Unable to log on with the given username and password.
what wrong here? what should I check? I am sure the user and password is
right and I can log on to ssrsdev1 physically with admin right without any
problem.
thanks for any thought on this.
zwp

Is SharePoint 2007 also installed on ssrsdev1?

If not, is this member of local admin group on ssrsdev1 a domain user or a local user (on ssrsdev1)?

thanx,
Prash

|||

we installed sharepoint 2007 bianry on ssrsdev1 (report server with sp2). and the user is a domain user and a member of local admin group. Actually, the report server, sql server and sharepoint all run under domain user (also a member of local admin group). When we tried to use user name domain\user and we got a error says: the group name can't find; when we use user or user@.domain.com to connect, we got the error I posted before. We tried to reinstall the sharepoint 2007 and still got same problem.

Thanks in advance for your help.

D.

|||

In you care you should use <domain_name>\<user> format.

In any case, in "Grant Database Access" we essentially try to add the Reporting Services service accounts to the WSS_WPG windows group. The WSS_WPG windows group should have been created when you installed SharePoint.

Can you verfy whether ssrsdev1 has a WSS_WPG windows group?

thanx,
Prash

|||

the windows group are on both report servers (ssrsdev1 and it also is the content database server for sharepoint server) and sharepoint server (spserver). I have manually added the user account into this grouop in both server, but I still get the same error.

Actually, I installed and running everything (report server and its services, sql server, and sharepoint, etc.) with the same domain user which is a member of local admin group on both boxes, therefore, the user should have access to everything, but I don’t understand why I am still have the problem with ‘grant database access’. Is it a bug?

BTW, we use sharepoing 2007 and sp2 December 2006 CTP.

Thanks,

zwp

|||

I just posted a message. Sorry it was my bad. I might mistype something. It works now.

However, when I go to next step:

Set server defaults

I got error message:

Server was unable to process request. > The request failed with HTTP status 401: Unauthorized.

I wonder it comes from sharepoint IIS or report server IIS? the user (again) I used are the local admin on both box, why still "Unauthorized "?

BTW, in sp2 BOL, it says: Verify the installation

use this address:

http://example-server-name:8081/reportserver

the example-server-name is report server name or sharepoint server name? I have tried both but none of them work. Maybe it is the result of HTTP status 401 above or something else

thanks again.

zwp.

|||

http://example-server-name:<port>/reportserver

example-server-name = the server on which Report Server is installed

<port> = the actual TCP port that your web site containing the ReportServer virtual directory is setup for. Note: 8081 is just an example.

Hope this helps.

thanx,
Prash

|||

could someone let me know how to find user :'sharepoint\system' since I can't find it in computer manager. I bet it is a system account used by sharepoint but how to set the permission to it. I got following

The permissions granted to user 'SHAREPOINT\system' are insufficient for performing this operation. > The permissions granted to user 'SHAREPOINT\system' are insufficient for performing this operation.

when I at screen:

Reporting Services Server Defaults

thanks.

|||

Generally you should open another thread for a different issue.

In any case, are you able to upload / view reports in other SharePoint web sites?

Additionally, are you using a built-in machine account, such as Network Service as the identity of the application pool that hosts the SharePoint Central Admin web site?

thanx,
Prash

|||

Hi,

I've experienced the same problem.

In "Grant Database Access" page, when I entered a domain user account e.g. domain-name\paul (with SQL server local admin right), it pop-up:

The group name could not be found

In my SharePoint Server, there is a WSS_WPG windows group which has my domain account e.g. domain-name\paul

My SQL server 2005 with SP 2 is installed in another server.

Any advice?

Paul

|||

The WSS_WPG Windows group needs to also be present on the Report Server machine you specify as the "Server Name" in the "Grant Database Access" web page.

HTH
Prash

|||

Thanks.

Actually, I can setup the SharePoint Integration in a single-box (MOSS+SQL). So, as you said, WSS_WPG is in the same machine. However, as my SQL server is installed in another server. What can I do? (I did create a group called WSS_WPG manually in the SQL server, but still failed)

Any idea?

Paul

|||

Correct if I am wrong, but it looks like Reporting Services is installed on your SQL Server machine. If yes, then you still need to install the SharePoint Object Model on the SQL Server machine.

For a multi-machine setup refer to "How to: Install the Windows SharePoint Services Object Model on a Report Server Computer" in SQL BOL.

HTH
Prash

Grant Database Access

I am setting up report services after I installed the report server add-ins
on sharepoint 2007.

at first step, Reporting services integration, I put
report server web service URL -- http://ssrsdev1/reportserver
authentication mode -- windows authentication
it went OK.

at second step, Grant Database Access,
I put ssrsdev1 for server name (default instance) and then click OK and then
I put the user name (a member of local admin group on ssrsdev1) and password,
but I always got errors says:
Unable to log on with the given username and password.
what wrong here? what should I check? I am sure the user and password is
right and I can log on to ssrsdev1 physically with admin right without any
problem.
thanks for any thought on this.
zwp

Is SharePoint 2007 also installed on ssrsdev1?

If not, is this member of local admin group on ssrsdev1 a domain user or a local user (on ssrsdev1)?

thanx,
Prash

|||

we installed sharepoint 2007 bianry on ssrsdev1 (report server with sp2). and the user is a domain user and a member of local admin group. Actually, the report server, sql server and sharepoint all run under domain user (also a member of local admin group). When we tried to use user name domain\user and we got a error says: the group name can't find; when we use user or user@.domain.com to connect, we got the error I posted before. We tried to reinstall the sharepoint 2007 and still got same problem.

Thanks in advance for your help.

D.

|||

In you care you should use <domain_name>\<user> format.

In any case, in "Grant Database Access" we essentially try to add the Reporting Services service accounts to the WSS_WPG windows group. The WSS_WPG windows group should have been created when you installed SharePoint.

Can you verfy whether ssrsdev1 has a WSS_WPG windows group?

thanx,
Prash

|||

the windows group are on both report servers (ssrsdev1 and it also is the content database server for sharepoint server) and sharepoint server (spserver). I have manually added the user account into this grouop in both server, but I still get the same error.

Actually, I installed and running everything (report server and its services, sql server, and sharepoint, etc.) with the same domain user which is a member of local admin group on both boxes, therefore, the user should have access to everything, but I don’t understand why I am still have the problem with ‘grant database access’. Is it a bug?

BTW, we use sharepoing 2007 and sp2 December 2006 CTP.

Thanks,

zwp

|||

I just posted a message. Sorry it was my bad. I might mistype something. It works now.

However, when I go to next step:

Set server defaults

I got error message:

Server was unable to process request. > The request failed with HTTP status 401: Unauthorized.

I wonder it comes from sharepoint IIS or report server IIS? the user (again) I used are the local admin on both box, why still "Unauthorized "?

BTW, in sp2 BOL, it says: Verify the installation

use this address:

http://example-server-name:8081/reportserver

the example-server-name is report server name or sharepoint server name? I have tried both but none of them work. Maybe it is the result of HTTP status 401 above or something else

thanks again.

zwp.

|||

http://example-server-name:<port>/reportserver

example-server-name = the server on which Report Server is installed

<port> = the actual TCP port that your web site containing the ReportServer virtual directory is setup for. Note: 8081 is just an example.

Hope this helps.

thanx,
Prash

|||

could someone let me know how to find user :'sharepoint\system' since I can't find it in computer manager. I bet it is a system account used by sharepoint but how to set the permission to it. I got following

The permissions granted to user 'SHAREPOINT\system' are insufficient for performing this operation. > The permissions granted to user 'SHAREPOINT\system' are insufficient for performing this operation.

when I at screen:

Reporting Services Server Defaults

thanks.

|||

Generally you should open another thread for a different issue.

In any case, are you able to upload / view reports in other SharePoint web sites?

Additionally, are you using a built-in machine account, such as Network Service as the identity of the application pool that hosts the SharePoint Central Admin web site?

thanx,
Prash

|||

Hi,

I've experienced the same problem.

In "Grant Database Access" page, when I entered a domain user account e.g. domain-name\paul (with SQL server local admin right), it pop-up:

The group name could not be found

In my SharePoint Server, there is a WSS_WPG windows group which has my domain account e.g. domain-name\paul

My SQL server 2005 with SP 2 is installed in another server.

Any advice?

Paul

|||

The WSS_WPG Windows group needs to also be present on the Report Server machine you specify as the "Server Name" in the "Grant Database Access" web page.

HTH
Prash

|||

Thanks.

Actually, I can setup the SharePoint Integration in a single-box (MOSS+SQL). So, as you said, WSS_WPG is in the same machine. However, as my SQL server is installed in another server. What can I do? (I did create a group called WSS_WPG manually in the SQL server, but still failed)

Any idea?

Paul

|||

Correct if I am wrong, but it looks like Reporting Services is installed on your SQL Server machine. If yes, then you still need to install the SharePoint Object Model on the SQL Server machine.

For a multi-machine setup refer to "How to: Install the Windows SharePoint Services Object Model on a Report Server Computer" in SQL BOL.

HTH
Prash

Google Maps

Has anybody tried to display a Google Map inside a report using Reporting
Services?
Thank you,
Alain Quesnel
alainsansspam@.logiquel.comOn Jun 26, 9:43 pm, "Alain Quesnel" <alainsanss...@.logiquel.com>
wrote:
> Has anybody tried to display a Google Map inside a report using Reporting
> Services?
> Thank you,
> Alain Quesnel
> alainsanss...@.logiquel.com
You could add a textbox control to the report and give it a string
value and set it to a Google Maps URL (via: right-click the textbox
contol -> select Properties -> Navigation -> Jump to URL:). Hope this
is helpful.
Regards,
Enrique Martinez
Sr. Software Consultant|||I'm already doing that, thanks. It's fine for a pdf file or for viewing the
report online. But once it's printed, thank link is no longer useful. I was
hoping to do something similar to a Windows app or a web page that has a
Google map frame in it.
Thanks,
Alain Quesnel
alainsansspam@.logiquel.com
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:1183083791.675971.61680@.k79g2000hse.googlegroups.com...
> On Jun 26, 9:43 pm, "Alain Quesnel" <alainsanss...@.logiquel.com>
> wrote:
>> Has anybody tried to display a Google Map inside a report using Reporting
>> Services?
>> Thank you,
>> Alain Quesnel
>> alainsanss...@.logiquel.com
>
> You could add a textbox control to the report and give it a string
> value and set it to a Google Maps URL (via: right-click the textbox
> contol -> select Properties -> Navigation -> Jump to URL:). Hope this
> is helpful.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>

Good Reporting Service Books

I'm wondering if anyone has any good Reporting Services books they recommend.
I'm a DBA so I don't actually do or need to know the report development and
deployment but need to know the back-end of RS - the security - etc. Many of
the books I've seen so far concentrate on report creation. If anyone has any
good suggestions they would be appreciated.http://www.sqlreportingservices.net/
Hitchhiker's Guide to SQL Server 2000 Reporting Services
--
Adrian M.
MCP
"tsorv" <tsorv@.discussions.microsoft.com> wrote in message
news:8FAD8E6A-8CDF-44A7-B82F-53D50A1585A4@.microsoft.com...
> I'm wondering if anyone has any good Reporting Services books they
> recommend.
> I'm a DBA so I don't actually do or need to know the report development
> and
> deployment but need to know the back-end of RS - the security - etc. Many
> of
> the books I've seen so far concentrate on report creation. If anyone has
> any
> good suggestions they would be appreciated.|||I own 6 books - as a DBA I find them all to offer different ways of
explaining things.
I reccommend the following 4 - ranking them from highest to lowest for what
you want:
Hitchhikers Guide To SQL Server 2000 ISBN: 0-321-26828-8
Microsoft Reporting Services In Action ISBN: 1-932394-22-2
Professional SQL Server Reporting Services ISBN: 0-7645-6878-7
Microsoft SQL Server 2000 Reporting Services ISBN: 0-07-223216-1
Of course, each book offers information on report creation - but tucked away
in each is information on report security that every DBA should know, in
addition to installation issues, solutions, installing SSL, etc that have
nothing to do with report creation.
Good luck.
=-Chris
"tsorv" <tsorv@.discussions.microsoft.com> wrote in message
news:8FAD8E6A-8CDF-44A7-B82F-53D50A1585A4@.microsoft.com...
> I'm wondering if anyone has any good Reporting Services books they
> recommend.
> I'm a DBA so I don't actually do or need to know the report development
> and
> deployment but need to know the back-end of RS - the security - etc. Many
> of
> the books I've seen so far concentrate on report creation. If anyone has
> any
> good suggestions they would be appreciated.|||I'd definately recommend the Hitchhikers Guide. As yet another DBA I found
it very useful and it has a good focus on security. It also got me
interested in the SOAP side of things and I've ben having lots of fun/pain
writing some scripting utilities for environment migrations. I haven't read
the others but I have ordered Reporting Services in Action based on
recommendations from others.
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Christopher Conner" <someone@.someplace.com> wrote in message
news:u6uyONGFFHA.1836@.tk2msftngp13.phx.gbl...
>I own 6 books - as a DBA I find them all to offer different ways of
>explaining things.
> I reccommend the following 4 - ranking them from highest to lowest for
> what you want:
> Hitchhikers Guide To SQL Server 2000 ISBN: 0-321-26828-8
> Microsoft Reporting Services In Action ISBN: 1-932394-22-2
> Professional SQL Server Reporting Services ISBN: 0-7645-6878-7
> Microsoft SQL Server 2000 Reporting Services ISBN: 0-07-223216-1
> Of course, each book offers information on report creation - but tucked
> away in each is information on report security that every DBA should know,
> in addition to installation issues, solutions, installing SSL, etc that
> have nothing to do with report creation.
> Good luck.
> =-Chris
>
> "tsorv" <tsorv@.discussions.microsoft.com> wrote in message
> news:8FAD8E6A-8CDF-44A7-B82F-53D50A1585A4@.microsoft.com...
>> I'm wondering if anyone has any good Reporting Services books they
>> recommend.
>> I'm a DBA so I don't actually do or need to know the report development
>> and
>> deployment but need to know the back-end of RS - the security - etc.
>> Many of
>> the books I've seen so far concentrate on report creation. If anyone has
>> any
>> good suggestions they would be appreciated.
>|||hi
I studied differnt books on security.
Among all those books I felt " Microsoft SQL server 2000 Reporting Services"
is the best fit for DBA.
Allthebest
"Adrian M." wrote:
> http://www.sqlreportingservices.net/
> Hitchhiker's Guide to SQL Server 2000 Reporting Services
> --
> Adrian M.
> MCP
> "tsorv" <tsorv@.discussions.microsoft.com> wrote in message
> news:8FAD8E6A-8CDF-44A7-B82F-53D50A1585A4@.microsoft.com...
> > I'm wondering if anyone has any good Reporting Services books they
> > recommend.
> > I'm a DBA so I don't actually do or need to know the report development
> > and
> > deployment but need to know the back-end of RS - the security - etc. Many
> > of
> > the books I've seen so far concentrate on report creation. If anyone has
> > any
> > good suggestions they would be appreciated.
>
>|||tsorv wrote:
> I'm wondering if anyone has any good Reporting Services books they recommend.
> I'm a DBA so I don't actually do or need to know the report development and
> deployment but need to know the back-end of RS - the security - etc. Many of
> the books I've seen so far concentrate on report creation. If anyone has any
> good suggestions they would be appreciated.
Unfortunately, I have read several and they all stink and contain
errors. The worst Crystal reports book is better than the best RS books.|||Bryon wrote:
> tsorv wrote:
>> I'm wondering if anyone has any good Reporting Services books they
>> recommend. I'm a DBA so I don't actually do or need to know the
>> report development and deployment but need to know the back-end of RS
>> - the security - etc. Many of the books I've seen so far concentrate
>> on report creation. If anyone has any good suggestions they would be
>> appreciated.
>
> Unfortunately, I have read several and they all stink and contain
> errors. The worst Crystal reports book is better than the best RS books.
Although after reading the other posts I need to checkout the Hitchhiker
book.|||I definitely recommend the Hitchhiker's Guide, but beware that it seems
to be targeted more at the administrator, DBA, or lead developer,
rather than the average report developer. By this, I mean that it
contains a wealth of knowledge on installation, configuration,
security, and programability, but the chapters on Report Design are
limited to solving some higher level problems rather than focusing on
the basics. IMHO it isnt comprehensive enough to teach someone how to
write reports if they have never used the Report Designer.
This is fine for the "one man show" approach to using Sql Reporting
Services, but any large implementation will likely have one or two
admins/leads, and at least 3-4 people who are pure "report authors".
The latter group isnt always interested in many of the advanced topics
and may need more "bread and butter" tutorials on how to create various
styles of reports.
Can anyone recommend a RS book targeted more at the report
designer/author?
Thank you,
Lance Hunt
http://weblogs.asp.net/lhunt/

Good books on SQL Server Reporting Services

Can you please share with me if you are aware of any good books on SQL
Server reporting services.
Many Thanks
SimonReporting services is so new that I don't think there are any books
published on it yet.
This is your starting point:
http://www.microsoft.com/sql/reporting/default.asp
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
What hardware is your SQL Server running on?
http://vyaskn.tripod.com/poll.htm
"Simon Lenn" <simonlenn@.yahoo.com> wrote in message
news:3641e2c2.0312191558.270cef9b@.posting.google.com...
Can you please share with me if you are aware of any good books on SQL
Server reporting services.
Many Thanks
Simon

Good books on SQL Server Reporting Services

Can you please share with me if you are aware of any good books on SQL
Server reporting services.
Many Thanks
SimonReporting services is so new that I don't think there are any books
published on it yet.
This is your starting point:
http://www.microsoft.com/sql/reporting/default.asp
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
What hardware is your SQL Server running on?
http://vyaskn.tripod.com/poll.htm
"Simon Lenn" <simonlenn@.yahoo.com> wrote in message
news:3641e2c2.0312191558.270cef9b@.posting.google.com...
Can you please share with me if you are aware of any good books on SQL
Server reporting services.
Many Thanks
Simon

Good Book on SQL Server Reporting Services Script

Hello, I recently discovered the rs.exe utility and .rss files. I have
looked at and enjoyed the sample scripts, but was wondering if there were any
books on this subject that anyone has found useful?
Thanks in advance!
TimTim,
That is a hard one, as all of the books out there do not talk much to the
rs.exe utility, but there is one site www.sqldbatips.com has a tool that can
help out a ton: Reporting Services Scripter.
I also have a method to debug rss scripts.
In Visual Studio
1. Create a new Visual Basic Console Application Project: name it RSDebug
2. In the Soultion Explorer window - right click on the RSDebug Project and
select the Add Web Reference option.
3. In the URL text box add:
http://servername/reportserver/reportservice2005.asmx
4. Click Go Command Button (This step takes a while)
5. In the Web Reference Name text box add SSRSWebService
6. Click Add Reference Command Button
7. In the Code Window above the Module Module1 add:
Imports RSDebug.SSRSWebService
Imports System.Web.Services.Protocols
8. Below the Module Module1 add: Public rs As New ReportingService2005
9. Paste your script code in the Sub Main() procedure
10. Set your breakpoint and go.
Example: (In this example System.IO is needed due to the use of the
MemoryStream object)
Imports RSDebug.SSRSWebService
Imports System.Web.Services.Protocols
Imports System.IO ' This was added because MemoryStream was used
Module Module1
Public rs As New ReportingService2005
Sub Main()
Dim strObjectName As String = "Report Name"
Dim strObjectPath As String = "/Application"
Dim strObjectFullPath As String = strObjectPath & "/" & strObjectName
Dim strLocalFile As String = "Report Name.rdl"
Dim strLocalPath As String = "C:\"
Dim strLocalFullPath As String = strLocalPath & strLocalFile
Dim objReportDefinition As Byte()
Dim objMemoryStream As MemoryStream
Dim objDocument As New System.Xml.XmlDocument()
Try
rs.Credentials = System.Net.CredentialCache.DefaultCredentials
objReportDefinition = rs.GetReportDefinition(strObjectFullPath)
objMemoryStream = New MemoryStream(objReportDefinition)
objDocument.Load(objMemoryStream)
objDocument.Save(strLocalFullPath)
Console.WriteLine("Standard: Report downloaded successfully.")
Catch e As SoapException
Console.WriteLine("Error: " +
e.Detail.Item("ErrorCode").InnerText + " (" +
e.Detail.Item("Message").InnerText + ")")
End Try
End Sub
End Module|||Thanks very much Reeves, this is great information.
Tim
"Reeves Smith" wrote:
> Tim,
> That is a hard one, as all of the books out there do not talk much to the
> rs.exe utility, but there is one site www.sqldbatips.com has a tool that can
> help out a ton: Reporting Services Scripter.
> I also have a method to debug rss scripts.
> In Visual Studio
> 1. Create a new Visual Basic Console Application Project: name it RSDebug
> 2. In the Soultion Explorer window - right click on the RSDebug Project and
> select the Add Web Reference option.
> 3. In the URL text box add:
> http://servername/reportserver/reportservice2005.asmx
> 4. Click Go Command Button (This step takes a while)
> 5. In the Web Reference Name text box add SSRSWebService
> 6. Click Add Reference Command Button
> 7. In the Code Window above the Module Module1 add:
> Imports RSDebug.SSRSWebService
> Imports System.Web.Services.Protocols
> 8. Below the Module Module1 add: Public rs As New ReportingService2005
> 9. Paste your script code in the Sub Main() procedure
> 10. Set your breakpoint and go.
>
> Example: (In this example System.IO is needed due to the use of the
> MemoryStream object)
>
> Imports RSDebug.SSRSWebService
> Imports System.Web.Services.Protocols
>
> Imports System.IO ' This was added because MemoryStream was used
>
> Module Module1
> Public rs As New ReportingService2005
>
> Sub Main()
> Dim strObjectName As String = "Report Name"
> Dim strObjectPath As String = "/Application"
> Dim strObjectFullPath As String = strObjectPath & "/" & strObjectName
> Dim strLocalFile As String = "Report Name.rdl"
> Dim strLocalPath As String = "C:\"
> Dim strLocalFullPath As String = strLocalPath & strLocalFile
> Dim objReportDefinition As Byte()
> Dim objMemoryStream As MemoryStream
> Dim objDocument As New System.Xml.XmlDocument()
>
> Try
> rs.Credentials = System.Net.CredentialCache.DefaultCredentials
> objReportDefinition = rs.GetReportDefinition(strObjectFullPath)
> objMemoryStream = New MemoryStream(objReportDefinition)
> objDocument.Load(objMemoryStream)
> objDocument.Save(strLocalFullPath)
> Console.WriteLine("Standard: Report downloaded successfully.")
> Catch e As SoapException
> Console.WriteLine("Error: " +
> e.Detail.Item("ErrorCode").InnerText + " (" +
> e.Detail.Item("Message").InnerText + ")")
> End Try
> End Sub
> End Module|||On Aug 7, 7:58 pm, TimS <timsts...@.msn.com(donotspam)> wrote:
> Thanks very much Reeves, this is great information.
> Tim
> "Reeves Smith" wrote:
> > Tim,
> > That is a hard one, as all of the books out there do not talk much to the
> > rs.exe utility, but there is one sitewww.sqldbatips.comhas a tool that can
> > help out a ton: Reporting Services Scripter.
> > I also have a method to debug rss scripts.
> > In Visual Studio
> > 1. Create a new Visual Basic Console Application Project: name it RSDebug
> > 2. In the Soultion Explorer window - right click on the RSDebug Project and
> > select the Add Web Reference option.
> > 3. In the URL text box add:
> >http://servername/reportserver/reportservice2005.asmx
> > 4. Click Go Command Button (This step takes a while)
> > 5. In the Web Reference Name text box add SSRSWebService
> > 6. Click Add Reference Command Button
> > 7. In the Code Window above the Module Module1 add:
> > Imports RSDebug.SSRSWebService
> > Imports System.Web.Services.Protocols
> > 8. Below the Module Module1 add: Public rs As New ReportingService2005
> > 9. Paste your script code in the Sub Main() procedure
> > 10. Set your breakpoint and go.
> > Example: (In this example System.IO is needed due to the use of the
> > MemoryStream object)
> > Imports RSDebug.SSRSWebService
> > Imports System.Web.Services.Protocols
> > Imports System.IO ' This was added because MemoryStream was used
> > Module Module1
> > Public rs As New ReportingService2005
> > Sub Main()
> > Dim strObjectName As String = "Report Name"
> > Dim strObjectPath As String = "/Application"
> > Dim strObjectFullPath As String = strObjectPath & "/" & strObjectName
> > Dim strLocalFile As String = "Report Name.rdl"
> > Dim strLocalPath As String = "C:\"
> > Dim strLocalFullPath As String = strLocalPath & strLocalFile
> > Dim objReportDefinition As Byte()
> > Dim objMemoryStream As MemoryStream
> > Dim objDocument As New System.Xml.XmlDocument()
> > Try
> > rs.Credentials = System.Net.CredentialCache.DefaultCredentials
> > objReportDefinition = rs.GetReportDefinition(strObjectFullPath)
> > objMemoryStream = New MemoryStream(objReportDefinition)
> > objDocument.Load(objMemoryStream)
> > objDocument.Save(strLocalFullPath)
> > Console.WriteLine("Standard: Report downloaded successfully.")
> > Catch e As SoapException
> > Console.WriteLine("Error: " +
> > e.Detail.Item("ErrorCode").InnerText + " (" +
> > e.Detail.Item("Message").InnerText + ")")
> > End Try
> > End Sub
> > End Module
I ordered Microsoft's new books for the MCITP certification program in
Business Intelligence. One covers the 70-445 exam and the other one
the 70-446 exam. I'm sure you'll find them very useful (once they're
published anyways!).
http://www.amazon.com/MCTS-Self-Paced-Training-Exam-70-445/dp/0735623414/ref=pd_bbs_1/102-9922975-8902553?ie=UTF8&s=books&qid=1186575878&sr=8-1
http://www.amazon.com/MCITP-Self-Paced-Training-Exam-70-446/dp/0735623848/ref=pd_bbs_2/102-9922975-8902553?ie=UTF8&s=books&qid=1186575878&sr=8-2

Good Book for Reporting Services

Hi,
Is there any good book for learning reporting services or as a reporting
services refrence?
Thanks,
AlanHow about ours? See www.sqlreportingervices.net. It's in the final
stages--we expect to have copies on the shelf in September. According to the
reviewers, it's worth the wait.
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
"A.M" <nospam1@.online.nospam> wrote in message
news:elLm0LQaEHA.3112@.TK2MSFTNGP09.phx.gbl...
> Hi,
> Is there any good book for learning reporting services or as a reporting
> services refrence?
> Thanks,
> Alan
>|||I recommend "Reporting Services in Action."
--RJ
"A.M" <nospam1@.online.nospam> wrote in message
news:elLm0LQaEHA.3112@.TK2MSFTNGP09.phx.gbl...
> Hi,
> Is there any good book for learning reporting services or as a reporting
> services refrence?
> Thanks,
> Alan
>

Globalization & Localization in sql server reporting services.

Hi All,

I am new to sql server reporting services. I am planning to use sql server reporting services for one of my project. But i have some doubts. Please any one help me.

1) Is it possible to localize sql server reporting services?

2) Is it possible to read and display the search labels and other column headers from resource file?

3) Will it display numeric, date and sort based on culture?

4) If it is possible then where we have to make the setting for that? I mean in the sql server or in the asp.net code behind file?

5) Is there any samples available in the net.

Thanks in advance.

I'm new to reporting services as well but i'll try to answer a few of your questions.

3. it will display the data based on the language setting on the computer that is hosting the file I believe

Check out this article for some more infohttp://www.sqljunkies.com/WebLog/tpagel/archive/2005/07/24/16197.aspx

4. see the article above (just a heads up but there are no code behind files in reporting services)

5. there are some samples located on the msdn site (herehttp://msdn.microsoft.com/sql/bi/reporting/default.aspx also a good place to start for info )

|||Thanks saiham|||

Hi Vinoth, I am also new to this reporting service and now struggling with the globalization issue. Have you found out the answer to your second question "Is it possible to read and display search label and other column headrs from resource file"?

The report designer has a section for developer to create custom function or refernce to function from external assemblies. I wonder whether we can use this section to read the resource file. Any idea? I have zero knowledge on the Resource File. I'll highly appreciate any input. Thanks

Best regards,
Jess

|||

Hi jess, I posted this in many forums but not found any useful answers. I will get back to you if i found any.

|||

Hi, I wanna share with you guys, what I done on localization by making use of resource file.
I am new on this programming world, feel free to correct me.

Given the fact that we can add custom assembly to our report, my idea is to create a function (can be in any language) outside the report, which will return locale value for particular key. Then, create an assembly of the code, and add reference to the assembly from the report designer

The function I used as this:

Public shared Function ReturnString (ByVal myValue As String, ByVal myCI as Stirng) As String
Dim ci As New CultureInfo (myCI)
Dim rm As ResourceManager
rm = ResourceManager.CreateFileBasedResourceManager ("MyStrings", "e:\resources\", Nothing)
Return rm.GetString(myValue, ci)
End Function

Where MyStrings is my resource file name and "e:\resources" is the location where i stored all my resource files.

One thing to take note when adding custom assembly to report. The assembly we are referencing to, must be copied to report designer and report server. For SSRS 2005, copy the assembly to these 2 locations:

C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies
C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\bin

Hope this can be input to anyone who is looking for using resource file for localization for SSRS. If you have a better solution, please share with me.

Global variable for hyperlinks in reports

We are using Reporting Services 2000. We have several reports that all
contain an "Edit" hyperlink that goes to a URL not related to the report
server url. We cannot directly enter this URL into the "Jump To" section,
because the url is different depending on the environment (dev, test,
production). So, because the reports uploaded in dev, test, and production
need to be identical, we need to get to this url some other way.
Ideally, we could upload a text file or enter some type of global variable
in the Report Manager that all the reports could access. The contents of
that variable/file would then be used to get the value for the "Jump To"
field of the hyperlink.
Does anyone have any ideas on the best way to accomplish this? Thanks!First off, you would want to use Jump to URL, not Jump to Report. The URL
can be an expression.
You could have a Report Parameter but that gets a little cumbersome. What I
suggest is having a dataset that has a single value that determines whether
it is test, dev, production. It could query a table that returns this value.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"David" <dilworth@.newsgroups.nospam> wrote in message
news:F8AD4F01-FB63-44EE-9900-E72F8A2845BD@.microsoft.com...
> We are using Reporting Services 2000. We have several reports that all
> contain an "Edit" hyperlink that goes to a URL not related to the report
> server url. We cannot directly enter this URL into the "Jump To" section,
> because the url is different depending on the environment (dev, test,
> production). So, because the reports uploaded in dev, test, and
> production
> need to be identical, we need to get to this url some other way.
> Ideally, we could upload a text file or enter some type of global variable
> in the Report Manager that all the reports could access. The contents of
> that variable/file would then be used to get the value for the "Jump To"
> field of the hyperlink.
> Does anyone have any ideas on the best way to accomplish this? Thanks!|||That worked great - thanks!
"Bruce L-C [MVP]" wrote:
> First off, you would want to use Jump to URL, not Jump to Report. The URL
> can be an expression.
> You could have a Report Parameter but that gets a little cumbersome. What I
> suggest is having a dataset that has a single value that determines whether
> it is test, dev, production. It could query a table that returns this value.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "David" <dilworth@.newsgroups.nospam> wrote in message
> news:F8AD4F01-FB63-44EE-9900-E72F8A2845BD@.microsoft.com...
> > We are using Reporting Services 2000. We have several reports that all
> > contain an "Edit" hyperlink that goes to a URL not related to the report
> > server url. We cannot directly enter this URL into the "Jump To" section,
> > because the url is different depending on the environment (dev, test,
> > production). So, because the reports uploaded in dev, test, and
> > production
> > need to be identical, we need to get to this url some other way.
> >
> > Ideally, we could upload a text file or enter some type of global variable
> > in the Report Manager that all the reports could access. The contents of
> > that variable/file would then be used to get the value for the "Jump To"
> > field of the hyperlink.
> >
> > Does anyone have any ideas on the best way to accomplish this? Thanks!
>
>

Giving understandable name to excel file when exporting with RS

Hello every body,

I'm trying to export excel file on with reporting services. My file has about 50 sheets and reporting services gives them the default name "feuille1, feuille2, feuille3, feuille4 etc....). I would like to give a valid and understandable name to that sheets. In fact i would like to give the name of each page to my sheet. The name of the page was specified in the report query.

Could someone help me please...

Thanx

I do not think that is configurable but you can try asking that question on the SQL Server Reporting services forum: http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=82&SiteID=1

Even though it might not be the most fun task, you could always manually rename those sheets to have more meaningful names atfer you exported the report.

Good luck!
Othmane