ReportViewer does not refresh when rdlc file changes

Hi,

I am trying to change rdlc file at run time but it does not resfresh.

I know there is an option to use Reset method but my version of ReportViewer

does not have this method. Does someone know how to change rdlc files

dynamically without using Reset ?

Thanks

Hi,

From your description, it seems that you want to change the report at runtime, right?

I think what you can do is to write a method in your code behind file which assigns the reportpath,datasources property and calls the refreshReport method, and invoke that method in the any event you want. See the following code snippet:

ReportViewer1.ProcessingMode = Microsoft.Reporting.WinForms.ProcessingMode.Local;
ReportViewer1.LocalReport.ReportPath = "rdlc file path";
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.DataSources.Add(new Microsoft.Reporting.WinForms.ReportDataSource("ReportDataSet_XX", ReportDataSet.Tables[int i]));
ReportViewer1.DocumentMapCollapsed = true;
ReportViewer1.RefreshReport();

For more information, you can refer the following threads:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2421083&SiteID=1

Thanks.

|||

Thanks for the reply.

This is exactly what I have in the code except this line.

ReportViewer1.DocumentMapCollapsed = true;

I have added this line and the result as following:

When I set first time reportviewer to rdlc, it works as expected.

When in another event, I am resetting.ReportPath and.DataSources to something different,

I get "

Some parameters or credentials have not been specified".|||

Hi,

The error "some parameters or credentials have not been specified" indicates that you have not set your parameters well, which is needed for your report.

And based on the code you provided,

List<ReportParameter> paramList =newList<ReportParameter>();this.ReportViewer1.LocalReport.SetParameters(paramList);

You have created a ReportParameterList, but you haven't add any report parameter to the parameter list.

Thanks.

|||

Thanks,

That is the part of the problem, first rdlc has 2 parameteres

but second one has no parameters and when I reset to second one it goves me this message.

|||

List<ReportParameter> paramList =newList<ReportParameter>();this.ReportViewer1.LocalReport.SetParameters(paramList);

As the second report has no parameters, remove the above line, you are adding an empty parameter list.

ReportViewer does not print on first attempt

Hi,
Has anyone found a solution to the problem of the reportviewer not printing
the first time you try to print? We found a solution on another newsgroup
but it doesn't fully resolve the problem.
Me.ReportViewer1.SetDisplayMode(Microsoft.Reporting.WinForms.DisplayMode.PrintLayout)Me.ReportViewer1.RefreshReport()
By using the displaymode.printlayout now you have to press the Print button
in the print dialog twice. But at least it prints. It seems that when the
print dialog displays it does not have focus. Clicking the print button or
anything else in the print dialog, then clicking the Print Button again does
actually print the report.there is a fix on msdn.
using a timer
EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.comsql

ReportViewer Connection to Remote Server

Hello,
I have a ReportViewer placed in a webform in remote mode and am having a
difficult time getting it to connect to a remote 2005 Report Server.
I can connect to the report manager remotely; however, all my attempts at
connnecting a reportviewer to that same Report Server has failed.
I believe it has something to do with impersonation but everything I see is
in c# and I use vb.net.
A step by step tutorial using VB.NET would be great but I have been unable
to locate any.
Any suggestions?
Thanks,
JohnHello Steven,
>What's the error messge you got in the
> reportviewer control at runtime, is it a message indicate that the current
> security context doesn't have sufficient permission?
The request failed with HTTP status 401: Unauthorized.
> 1. Is the SSRS reportserver installed with default setting?(using
> integrated windows security in IIS) Also, have you ever customized the
> role based security setting of the certain report you want to access in
> reportviewer?
The SSRS is using integrated windows security in IIS and I have not
customized any role-based security in the report.
> 2. What's OS and IIS version of your ASP.NET web application's host
> machine? Is it IIS 5 or IIS6. If you haven't manually configured to use
> impersonate for your ASP.NET application, the reportViewer page will run
> under your ASP.NET application's process identity and use this identity to
> access the remote reportserver. For IIS6, ASP.NET process identity is
> configured in the application pool identity and the default value is "NT
> AUTHORITY\NETWORK SERVICE". As for IIS5, is still use the machine.config's
> <processModel> section for setting ASP.NET process identity and the default
> value is machine\ASPNET. The following msdn article also described on
> configuring ASP.NET process identity:
> #Configuring ASP.NET Process Identity
> http://msdn2.microsoft.com/en-us/library/dwc1xthy.aspx
> And in your page you can use the following code snippet to printout the
> current security identity:
> =============> protected void Page_Load(object sender, EventArgs e)
> {
> Response.Write("<br/>Identity: " +
> System.Security.Principal.WindowsIdentity.GetCurrent().Name);
> }
> =============
I am currently developing on a WinXP Pro OS and trying to connect to the
SSRS 2005 on a Windows 2003 Standard OS. I will eventually need to move my
application to a production web server that is running Windows 2003 Web
Edition and connecting to a SSRS 2005 installation on a remote Windows
Standard 2003 server.
I tried changing the identity in the machine.config; however, no matter what
I change it to I get a response.write computername\mywindowsloginname when I
run in the integrated file based development environment. If I launch it from
IIS5 I get computername\ASPNET.
I can not go any further in your steps until I get this resolved.
Thanks,
John
"Steven Cheng[MSFT]" wrote:
> Hello John,
> Thank you for posting in the MSDN newsgroup.
> From your description, I understand you're developing an ASP.NET
> application which use the webform reportViewer control to access and
> display some server-reports from the SSRS 2005 reportserver. However, you
> found that the reportviewer always failed to connect to the
> reportserver(server report), correct? If there is anything I missed, please
> feel free to let me know.
> As for this problem, based on my experience, it is likely cause by security
> permission setting issue. What's the error messge you got in the
> reportviewer control at runtime, is it a message indicate that the current
> security context doesn't have sufficient permission? First, I'd like to
> confrim some environment info about the problem server machine and the
> reportserver with you:
> 1. Is the SSRS reportserver installed with default setting?(using
> integrated windows security in IIS) Also, have you ever customized the
> role based security setting of the certain report you want to access in
> reportviewer?
> 2. What's OS and IIS version of your ASP.NET web application's host
> machine? Is it IIS 5 or IIS6. If you haven't manually configured to use
> impersonate for your ASP.NET application, the reportViewer page will run
> under your ASP.NET application's process identity and use this identity to
> access the remote reportserver. For IIS6, ASP.NET process identity is
> configured in the application pool identity and the default value is "NT
> AUTHORITY\NETWORK SERVICE". As for IIS5, is still use the machine.config's
> <processModel> section for setting ASP.NET process identity and the default
> value is machine\ASPNET. The following msdn article also described on
> configuring ASP.NET process identity:
> #Configuring ASP.NET Process Identity
> http://msdn2.microsoft.com/en-us/library/dwc1xthy.aspx
> And in your page you can use the following code snippet to printout the
> current security identity:
> =============> protected void Page_Load(object sender, EventArgs e)
> {
> Response.Write("<br/>Identity: " +
> System.Security.Principal.WindowsIdentity.GetCurrent().Name);
> }
> =============>
> 3. After you've detect and ensure the running security identity of your
> ASP.NET application(the one reportviewer will use to access the remote
> report server). You can consider the role based permission setting on the
> remote reportServer. First, you should check whether the security identity
> can be identified and recognized on the remote reportserver machine. for
> example, the "NT AUTHORITY\NETWORK SERVICE" account is recognized as the
> machine's account on remote machine in windows domain. After you've
> verified that the identity can be recognized as a valid account on the
> remote reportserver, you should grant that account the sufficient
> permission to access that report. Generally, since we only view the report,
> so the "browser" role is sufficient. You can grant certain user/group one
> or more roles through the ReportManager or SQL Server management studio.
> Here are some resources on SSRS 2005 role based security managment:
> #Using Role-Based Security
> http://msdn2.microsoft.com/en-us/library/ms156014.aspx
> #Role Assignments
> http://msdn2.microsoft.com/en-us/library/ms156406.aspx
> #Creating, Modifying, and Deleting Role Definitions
> http://msdn2.microsoft.com/en-us/library/ms156264.aspx
> And I've also attached a screenshot of the role management interface in the
> ReportManager web application(grant a certain user with certain role).
> If you have anything unclear on the above things or if there is any further
> questions, please feel free to let me know.
> Sincerely,
> Steven Cheng
> Microsoft MSDN Online Support Lead
>
> ==================================================> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications.
>
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial
> response from the community or a Microsoft Support Engineer within 1
> business day is
> acceptable. Please note that each follow up response may take approximately
> 2 business days
> as the support professional working with you may need further investigation
> to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require
> urgent, real-time or phone-based interactions or complex project analysis
> and dump analysis
> issues. Issues of this nature are best handled working with a dedicated
> Microsoft Support
> Engineer by contacting Microsoft Customer Support Services (CSS) at
> http://msdn.microsoft.com/subscriptions/support/default.aspx.
> ==================================================>
> This posting is provided "AS IS" with no warranties, and confers no rights|||Hello John,
Thanks for your response.
From your further description, I've got that your current development
machine is a winxp box and the error you got is a "401 unauthorized" error.
I think this is due to the security identity passed from your XP dev box is
not recognizable in the reportserver machine(2003 test server). Here is my
understanding and analysis on the following symptom you described:
===============I tried changing the identity in the machine.config; however, no matter
what
I change it to I get a response.write computername\mywindowsloginname when
I
run in the integrated file based development environment. If I launch it
from
IIS5 I get computername\ASPNET.
===============
At first, when you change different identities in the machine.config, since
you're developing through the VS 2005 built-in tes webserver/File system
based project), the ASP.NET application is always running in the test
server and will run under your current logon user accountand.(That's why
you always see the "computername\mylogonuser") Thus, the reportViewer will
use this identity to access remote server report, surely this local account
is not valid on the remote reportserver machine(different machine) and the
IIS windows authentication will fail with 401.
Again, when you host the ASP.NET application in IIS, it will use the
ASP.NET worker process identity which is configured in the <processModel>
element in machine.config, and by default it is "machine\ASPNET". And this
account is also a machine specfic local account, therefore it is also
invalid when the reportviewer use the it to access the remote reportserver.
To resolve this, you can consider the following possible means:
1. When deveoping use Test web server, logon with a domain account (have
sufficient permission on the devbox) which is also recognizable on the
remote reportserver machine. This require that both machines are in the
same local domain.
2. Still developing use the test webserver, and still logon with a local
account. However, you need to create a duplicated local account on the
remote reportserver machine(with the same username and password). This can
make your local account on XP dev machine also recognizable(be
authenticated) on the remote reportserver machine. This is a workable
solution for all windows system use NTLM authentication.
3. If you will use IIS host ASP.NET application, then just change the
account in the <processModel> element in machine.config. And which account
to use also reference to the #1 and #2
BTW, when you finally move the ASP.NET application to a windows 2003
server, since IIS6 use application pool to configure worker process
identity and it use "NetworkService" account by default(this account is
recognized as the server's machine account on other remote machines in the
same domain), it'll be eaiser for you to configure the security setting if
your machines are in a domain environment.
Please feel free to let me know if there is anything unclear or if you
still have any other concerns on this.
Regards,
Steven Cheng
Microsoft MSDN Online Support Lead
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may
learn and benefit from your issue.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.|||Hello Steven,
I added a user account to the remote server with my local machine's username
and password. I gave that user Administrative priveledges. Also, my local and
my remote computers are on two seperate domains.
I am no longer getting the error:
The request failed with HTTP status 401: Unauthorized.
I am now getting the following error:
The attempt to connect to the report server failed. Check your connection
information and that the report server is a compatible version.
The request failed with HTTP status 404: Not Found.
If I change the password on the remote server to be different than my local
password, I once again get the 401 unauthorized error. It therefore seems to
me that I am little farther.
What would you suggest?
Thanks,
John
"Steven Cheng[MSFT]" wrote:
> Hello John,
> Thanks for your response.
> From your further description, I've got that your current development
> machine is a winxp box and the error you got is a "401 unauthorized" error.
> I think this is due to the security identity passed from your XP dev box is
> not recognizable in the reportserver machine(2003 test server). Here is my
> understanding and analysis on the following symptom you described:
> ===============> I tried changing the identity in the machine.config; however, no matter
> what
> I change it to I get a response.write computername\mywindowsloginname when
> I
> run in the integrated file based development environment. If I launch it
> from
> IIS5 I get computername\ASPNET.
> ===============> At first, when you change different identities in the machine.config, since
> you're developing through the VS 2005 built-in tes webserver/File system
> based project), the ASP.NET application is always running in the test
> server and will run under your current logon user accountand.(That's why
> you always see the "computername\mylogonuser") Thus, the reportViewer will
> use this identity to access remote server report, surely this local account
> is not valid on the remote reportserver machine(different machine) and the
> IIS windows authentication will fail with 401.
> Again, when you host the ASP.NET application in IIS, it will use the
> ASP.NET worker process identity which is configured in the <processModel>
> element in machine.config, and by default it is "machine\ASPNET". And this
> account is also a machine specfic local account, therefore it is also
> invalid when the reportviewer use the it to access the remote reportserver.
>
> To resolve this, you can consider the following possible means:
> 1. When deveoping use Test web server, logon with a domain account (have
> sufficient permission on the devbox) which is also recognizable on the
> remote reportserver machine. This require that both machines are in the
> same local domain.
> 2. Still developing use the test webserver, and still logon with a local
> account. However, you need to create a duplicated local account on the
> remote reportserver machine(with the same username and password). This can
> make your local account on XP dev machine also recognizable(be
> authenticated) on the remote reportserver machine. This is a workable
> solution for all windows system use NTLM authentication.
> 3. If you will use IIS host ASP.NET application, then just change the
> account in the <processModel> element in machine.config. And which account
> to use also reference to the #1 and #2
> BTW, when you finally move the ASP.NET application to a windows 2003
> server, since IIS6 use application pool to configure worker process
> identity and it use "NetworkService" account by default(this account is
> recognized as the server's machine account on other remote machines in the
> same domain), it'll be eaiser for you to configure the security setting if
> your machines are in a domain environment.
> Please feel free to let me know if there is anything unclear or if you
> still have any other concerns on this.
> Regards,
> Steven Cheng
> Microsoft MSDN Online Support Lead
>
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may
> learn and benefit from your issue.
> ==================================================>
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>
>
>
>|||Thanks for your followup John,
I thank we've made some progress on this. As you can find the remote server
now correctly recognize and validate the user on your cilent dev machine
and no longer display the 401 error, you can also check the IIS server's
log to see whether it list the client user's username in the request log
entry.
For the new problem you mentioned, I think it is somewhat specific to the
reportServer (server-side configuration). Have you tried directly use the
IE browser to visit that report in reportserver(not reportManager)? And
you can test by using the same account as you developed in VS IDE to access
that server report in IE browser(on XP dev box ) to see whether it report
the same error. The reportserver's url is like below by default:
Http://servername/reportserver/
Please let me know what you get on this. If convenient, you can also attach
some screenshot on the error.
Looking forward to your reply.
Sincerely,
Steven Cheng
Microsoft MSDN Online Support Lead
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.|||Hello Steven,
I have no problems connecting to the remote ReportServer or ReportManager
from a browser.
Thanks,
John
"Steven Cheng[MSFT]" wrote:
> Thanks for your followup John,
> I thank we've made some progress on this. As you can find the remote server
> now correctly recognize and validate the user on your cilent dev machine
> and no longer display the 401 error, you can also check the IIS server's
> log to see whether it list the client user's username in the request log
> entry.
> For the new problem you mentioned, I think it is somewhat specific to the
> reportServer (server-side configuration). Have you tried directly use the
> IE browser to visit that report in reportserver(not reportManager)? And
> you can test by using the same account as you developed in VS IDE to access
> that server report in IE browser(on XP dev box ) to see whether it report
> the same error. The reportserver's url is like below by default:
> Http://servername/reportserver/
> Please let me know what you get on this. If convenient, you can also attach
> some screenshot on the error.
> Looking forward to your reply.
> Sincerely,
> Steven Cheng
> Microsoft MSDN Online Support Lead
>
> ==================================================>
> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||Thanks for your reply John,
Since you can visit the reportserver correctly through webbrowser, the
problem should be specific to the reportviewer control. Based on my
investigation, the reportViewer control internally use a pregenerated
webservice proxy to call the reportserver's webservice (the ReportService
and ReportExecutionService), so we may perform some test against the
webservice call to the remote reportserver. To do this, you can still use
your ASP.NET web application (running under the certain user account that
has mapped account on remote server), add the webreference to the reporting
service webservice:
#Report Server Web Service
http://msdn2.microsoft.com/en-us/library/ms152787.aspx
You can reference the two main reporting service webservices through the
following two endpoints under the reportserver web root:
ReportService2005.asmx
ReportExecution2005.asmx
So, the url will be like:
http://servername/reportserver/ReportService2005.asmx or
http://servername/reportserver/ReportExecution2005.asmx
Please try calling some methods on it to see whether your ASP.NET
application can correctly consume the webmethods. You can also check the
reportserver's log files to see what's the error generated when your client
ASP.NET application fails to access it.
BTW, I've also found some other former issue which had the similar symptom
with yours. In those cases, their reportServer application's IIS virtual
directory or IIS site is using a custom host header(dosn't use the default
website/machine name). And we need to check the some URL settings(like the
reportserver virtual directory, UrlRoot ...) in the
RsWebApplication.config file, you can find those setting in the following
BOL reference:
#RSWebApplication Configuration File
http://msdn2.microsoft.com/en-us/library/ms155878.aspx
Based on my local test, the <UrlRoot> element in the rsreportserver.config
file should be conform to your reportserver's external url(to other
machines).
<UrlRoot>http://myservermachine/reportserver</UrlRoot>
the file is under the reportserver application directory(C:\Program
Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer)
Here are some related threads over the internet discussing on the similar
issue:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=256312&SiteID=1
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=256312&SiteID=1
Hope this helps. If you there is anything unclear or have any further
question, please feel free to post here.
Sincerely,
Steven Cheng
Microsoft MSDN Online Support Lead
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.|||Steven,
I too am having the same problem. I''m getting the error: The request failed
with HTTP status 401: Unauthorized.
I'm very sure this is happening because I am not passing my Credentials to
the ReportViewer Control. I cannot seem to get the syntax correct.
Here is how I did it using the rs.render method:
Dim strUserName_Dev As String =System.Configuration.ConfigurationManager.AppSettings("UserName_Dev")
Dim strPWD_Dev As String =System.Configuration.ConfigurationManager.AppSettings("PWD_Dev")
Dim strDomain_Dev As String =System.Configuration.ConfigurationManager.AppSettings("Domain_Dev")
RS.Credentials = New System.Net.NetworkCredential(strUserName_Dev,
strPWD_Dev, strDomain_Dev)
Dim data As Byte()
data = RS_Dev.Render(Path2, Format, Nothing, Nothing, Parameters, _
Nothing, Nothing, Encoding, MimeType,
ParametersUsed, _
Warnings, StreamIDs)
The above methods works very well when I'm sending the output to a binary
stream or writer.
I need to now use the ReportViewer Control.
Can you please help me assign the same credentials to the ReportViewer
Control? I cannot figure out the syntax. Here is what I'm trying:
Getting the credentials:
RS.Credentials = New System.Net.NetworkCredential(strUserName_Dev,
strPWD_Dev, strDomain_Dev)
ReportViewer1.ServerReport.ReportServerCredentials.NetworkCredentials =RS.credentials
I get a compile error telling me this is a Read Only Property.
I'm not sure what to do next.
Thanks,
Rwiethorn
"Steven Cheng[MSFT]" wrote:
> Thanks for your reply John,
> Since you can visit the reportserver correctly through webbrowser, the
> problem should be specific to the reportviewer control. Based on my
> investigation, the reportViewer control internally use a pregenerated
> webservice proxy to call the reportserver's webservice (the ReportService
> and ReportExecutionService), so we may perform some test against the
> webservice call to the remote reportserver. To do this, you can still use
> your ASP.NET web application (running under the certain user account that
> has mapped account on remote server), add the webreference to the reporting
> service webservice:
> #Report Server Web Service
> http://msdn2.microsoft.com/en-us/library/ms152787.aspx
> You can reference the two main reporting service webservices through the
> following two endpoints under the reportserver web root:
> ReportService2005.asmx
> ReportExecution2005.asmx
> So, the url will be like:
> http://servername/reportserver/ReportService2005.asmx or
> http://servername/reportserver/ReportExecution2005.asmx
> Please try calling some methods on it to see whether your ASP.NET
> application can correctly consume the webmethods. You can also check the
> reportserver's log files to see what's the error generated when your client
> ASP.NET application fails to access it.
> BTW, I've also found some other former issue which had the similar symptom
> with yours. In those cases, their reportServer application's IIS virtual
> directory or IIS site is using a custom host header(dosn't use the default
> website/machine name). And we need to check the some URL settings(like the
> reportserver virtual directory, UrlRoot ...) in the
> RsWebApplication.config file, you can find those setting in the following
> BOL reference:
> #RSWebApplication Configuration File
> http://msdn2.microsoft.com/en-us/library/ms155878.aspx
> Based on my local test, the <UrlRoot> element in the rsreportserver.config
> file should be conform to your reportserver's external url(to other
> machines).
> <UrlRoot>http://myservermachine/reportserver</UrlRoot>
> the file is under the reportserver application directory(C:\Program
> Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer)
> Here are some related threads over the internet discussing on the similar
> issue:
>
> http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=256312&SiteID=1
> http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=256312&SiteID=1
> Hope this helps. If you there is anything unclear or have any further
> question, please feel free to post here.
> Sincerely,
> Steven Cheng
> Microsoft MSDN Online Support Lead
> ==================================================>
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>|||Hello Steven,
I still haven't had any luck; however, the Report Services was not set up to
a default install. I am going to reinstall and see if that helps.
Thanks,
John
"Steven Cheng[MSFT]" wrote:
> Thanks for your reply John,
> Since you can visit the reportserver correctly through webbrowser, the
> problem should be specific to the reportviewer control. Based on my
> investigation, the reportViewer control internally use a pregenerated
> webservice proxy to call the reportserver's webservice (the ReportService
> and ReportExecutionService), so we may perform some test against the
> webservice call to the remote reportserver. To do this, you can still use
> your ASP.NET web application (running under the certain user account that
> has mapped account on remote server), add the webreference to the reporting
> service webservice:
> #Report Server Web Service
> http://msdn2.microsoft.com/en-us/library/ms152787.aspx
> You can reference the two main reporting service webservices through the
> following two endpoints under the reportserver web root:
> ReportService2005.asmx
> ReportExecution2005.asmx
> So, the url will be like:
> http://servername/reportserver/ReportService2005.asmx or
> http://servername/reportserver/ReportExecution2005.asmx
> Please try calling some methods on it to see whether your ASP.NET
> application can correctly consume the webmethods. You can also check the
> reportserver's log files to see what's the error generated when your client
> ASP.NET application fails to access it.
> BTW, I've also found some other former issue which had the similar symptom
> with yours. In those cases, their reportServer application's IIS virtual
> directory or IIS site is using a custom host header(dosn't use the default
> website/machine name). And we need to check the some URL settings(like the
> reportserver virtual directory, UrlRoot ...) in the
> RsWebApplication.config file, you can find those setting in the following
> BOL reference:
> #RSWebApplication Configuration File
> http://msdn2.microsoft.com/en-us/library/ms155878.aspx
> Based on my local test, the <UrlRoot> element in the rsreportserver.config
> file should be conform to your reportserver's external url(to other
> machines).
> <UrlRoot>http://myservermachine/reportserver</UrlRoot>
> the file is under the reportserver application directory(C:\Program
> Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer)
> Here are some related threads over the internet discussing on the similar
> issue:
>
> http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=256312&SiteID=1
> http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=256312&SiteID=1
> Hope this helps. If you there is anything unclear or have any further
> question, please feel free to post here.
> Sincerely,
> Steven Cheng
> Microsoft MSDN Online Support Lead
> ==================================================>
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>|||Thanks for your followup John,
I think the non-default installed location of the webservice could be the
potential cause as the configuration file of reportserver contains some
settings that identitfy the webservice's url(virtual directory or server
url).
Before you performing the reinstall, I still suggest you have a look at the
following threads and tried the settings mentioned there:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=256312&SiteID=1
#Installing Microsoft SQL Server 2005 Reporting Services on a non-default
web site.
http://www.mathgv.com/sql2005docs/SQL2005ReportingServicesInstall.htm
Hope that also helps.
If you meet any further problem or need any assistance, please feel free to
let me know.
Sincerely,
Steven Cheng
Microsoft MSDN Online Support Lead
This posting is provided "AS IS" with no warranties, and confers no rights.|||Hello Rwiethorn,
Yes, 401 error indicate that the supplied credential (security identity) is
not valid. What's your client appilcation(calling the SSRS webservice)'s
type, winform or asp.net? You can first try changing your client
appliation's security identity to a valid account which is recognizable on
the remote server to see whether it works.
Sincerely,
Steven Cheng
Microsoft MSDN Online Support Lead
This posting is provided "AS IS" with no warranties, and confers no rights.|||Steven Thanks for your response.
To answer your questions:
>What's your client application(calling the SSRS webservice)'s type, winform or
asp.net?
Its an ASP.NET application.
>You can first try changing your client applicationâ's security identity to a valid account which is recognizable on the remote server to see whether it works.
I've done that using the SOAP API Render method, and rendering the report to
a Response Object works perfectly. (Response.BinaryWrite(data))
When I use the SOAP method, I assign credentials to the RS object via this
method:
RS.Credentials = New System.Net.NetworkCredential(â'MyNameâ', â'MyPWDâ',
â'MyDomainâ')
Then proceed to assign the other propeties ie: parameters, and call the
Render method of the RS object as so:
data = RS.Render(Path2, Format, Nothing, Nothing, Parameters, Nothing,
Nothing, Encoding, MimeType, ParametersUsed, Warnings, StreamIDs)
When I try to use the ReportViewer Control, Iâ'm getting an error: â'Unable to
cast object of type 'System.Net.NetworkCredential' to type
'Microsoft.Reporting.WebForms.IReportServerCredentials'â'. From the following
lines of code:
Dim RC As New NetworkCredential("strUserName_Dev", "strPWD_Dev",
"strDomain_Dev")
ReportViewer1.ServerReport.ReportServerCredentials = RC
ReportViewer1.ServerReport.ReportPath = "/PA/CASNO_with_UNASSIGNED"
ReportViewer1.ServerReport.Refresh()
Iâ've also tried:
Dim CC As New System.Net.CredentialCache
CC.Add(New
Uri("http://bdcintra557.internal.pg.com/ReportServer$SQL2005/ReportService.asmx"),
"Digest", New System.Net.NetworkCredential("strUserName_Dev", "strPWD_Dev",
"strDomain_Dev"))
ReportViewer1.ServerReport.ReportServerCredentials.NetworkCredentials = CC
ReportViewer1.ServerReport.ReportPath = "/PA/CASNO_with_UNASSIGNED"
ReportViewer1.ServerReport.Refresh()
But I get an error trying to assign the CredentialCache to the ReporViewer
Control: Property 'NetworkCredentials' is 'ReadOnly'
I need help to assign these same NetworkCredentials to the ReportViewer
Control.
I just donâ't know the VB syntax to do it; Iâ'm not a very strong programmer.
Thanks,
Robert Wiethorn
rwiethorn
"Steven Cheng[MSFT]" wrote:
> Hello Rwiethorn,
> Yes, 401 error indicate that the supplied credential (security identity) is
> not valid. What's your client appilcation(calling the SSRS webservice)'s
> type, winform or asp.net? You can first try changing your client
> appliation's security identity to a valid account which is recognizable on
> the remote server to see whether it works.
> Sincerely,
> Steven Cheng
> Microsoft MSDN Online Support Lead
>
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>
>|||Hello Robert,
AS for the ReportViewer's Credential property, you can not directly use the
System.Net.NetworkCredential class, you need to implement a custom
IReportCredential interface's concrete class. Here is a previous thread in
which I've provided a sample IReportCredential implementation:
http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/brow
se_thread/thread/359cd6fce6f3ab37/dadf62fe2aed9f87?lnk=st&q=&rnum=1&hl=en#da
df62fe2aed9f87
In addition, do you think it's also possible that we programmatically
imerpsonate the ASP.NET worker thread as a specific user(which has
sufficient permission on the remote server)? If so, you can
programmtically impersonate in the reportviewer page (as a specific
account) so that you do not need to implement a custom ReportCredential
class. For programmtic impersonate in ASP.NET, please refer to the
following kb:
#How to implement impersonation in an ASP.NET application
http://support.microsoft.com/kb/306158/en-us
Hope this helps.
Sincerely,
Steven Cheng
Microsoft MSDN Online Support Lead
This posting is provided "AS IS" with no warranties, and confers no rights.|||Steven,
Thanks for the info, and all I can say is wow, thats going deep, but I got
it to work, I'll paste the code that I found after following a couple of
links:
Public Class MyReportViewerCredentials
Implements IReportServerCredentials
Private _userName As String
Private _password As String
Private _domain As String
Public Sub New(ByVal userName As String, ByVal password As String, ByVal
domain As String)
_userName = userName
_password = password
_domain = domain
End Sub
Public ReadOnly Property ImpersonationUser() As
System.Security.Principal.WindowsIdentity Implements
Microsoft.Reporting.WebForms.IReportServerCredentials.ImpersonationUser
Get
Return Nothing
End Get
End Property
Public ReadOnly Property NetworkCredentials() As System.Net.ICredentials
Implements
Microsoft.Reporting.WebForms.IReportServerCredentials.NetworkCredentials
Get
Return New Net.NetworkCredential(_userName, _password, _domain)
End Get
End Property
Public Function GetFormsCredentials(ByRef authCookie As
System.Net.Cookie, ByRef userName As String, ByRef password As String, ByRef
authority As String) As Boolean Implements
Microsoft.Reporting.WebForms.IReportServerCredentials.GetFormsCredentials
userName = _userName
password = _password
authority = _domain
Return Nothing
End Function
End Class
I then call that class in using:
ReportViewer1.ServerReport.ReportServerCredentials = New
MyReportViewerCredentials(strUserName_Dev, strPWD_Dev, strDomain_Dev)
ReportViewer1.ServerReport.Refresh()
Here is the link I found:
http://forums.asp.net/thread/1271383.aspx
Thanks for the help.
rwiethorn
"Steven Cheng[MSFT]" wrote:
> Hello Robert,
> AS for the ReportViewer's Credential property, you can not directly use the
> System.Net.NetworkCredential class, you need to implement a custom
> IReportCredential interface's concrete class. Here is a previous thread in
> which I've provided a sample IReportCredential implementation:
> http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/brow
> se_thread/thread/359cd6fce6f3ab37/dadf62fe2aed9f87?lnk=st&q=&rnum=1&hl=en#da
> df62fe2aed9f87
> In addition, do you think it's also possible that we programmatically
> imerpsonate the ASP.NET worker thread as a specific user(which has
> sufficient permission on the remote server)? If so, you can
> programmtically impersonate in the reportviewer page (as a specific
> account) so that you do not need to implement a custom ReportCredential
> class. For programmtic impersonate in ASP.NET, please refer to the
> following kb:
> #How to implement impersonation in an ASP.NET application
> http://support.microsoft.com/kb/306158/en-us
> Hope this helps.
> Sincerely,
> Steven Cheng
> Microsoft MSDN Online Support Lead
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>
>|||Thanks for the followup Robert,
Glad that you've got it working.
Sincerely,
Steven Cheng
Microsoft MSDN Online Support Lead|||Hello Steven,
I finally got this to work.
I had to change the Report Server URL to http://IPADDRESS/Reportserver from
http://IPADDRESS/Reports
I also was then able to set my credentials up using the information from
Rwiethorn's posts.
Thank you for the help.
John
"Steven Cheng[MSFT]" wrote:
> Thanks for your followup John,
> I think the non-default installed location of the webservice could be the
> potential cause as the configuration file of reportserver contains some
> settings that identitfy the webservice's url(virtual directory or server
> url).
> Before you performing the reinstall, I still suggest you have a look at the
> following threads and tried the settings mentioned there:
> http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=256312&SiteID=1
>
> #Installing Microsoft SQL Server 2005 Reporting Services on a non-default
> web site.
> http://www.mathgv.com/sql2005docs/SQL2005ReportingServicesInstall.htm
>
> Hope that also helps.
> If you meet any further problem or need any assistance, please feel free to
> let me know.
>
> Sincerely,
> Steven Cheng
> Microsoft MSDN Online Support Lead
>
> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||Hi John,
Thanks for the followup and glad that you've got it working.
Have a good day!
Sincerely,
Steven Cheng
Microsoft MSDN Online Support Lead
This posting is provided "AS IS" with no warranties, and confers no rights.

ReportView control taking long time to Export report

When using Reserved.ReportViewerWebControl.axd control from within a web
application on a web server to export a Reporting Services report in PDF
format takes 5-10 minutes (note same problem no matter what export format
used). The control was incorporated into the web application via Visual
Studio. But when you export the same report using the web interface provided
on the Reporting Services machine it runs in seconds. The web services
machine of course is using the same control but it is on reporting services
web machine, where as the slow application uses the control provided by
Visual Studio which resides on the web box where the application lives. So
why is the ReportViewer control on the application IIS box, so much slower
than the ReportViewer on the Reporting Services IIS box for the same report?
--
If you are looking for SQL Server examples or a free SQL Server DBA
Dashboard tool check out my Website at http://www.sqlserverexamples.comJust to be clear. Are you saying when you use the Report Manager it takes
seconds? And when you use the report viewer web control it takes minutes?
Because below you are saying this: "The web services machine of course is
using the same control but it is on reporting services" This confuses me.
Is it your app on the machine or Report Manager. I don't think Report
Manager is using the control.
Now as far as the 5-10 minutes, are you using the control in local mode or
server mode?
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Greg Larsen" <gregalarsen@.removeit.msn.com> wrote in message
news:85AD0C03-0420-4C4B-A241-C9249A3EE1CD@.microsoft.com...
> When using Reserved.ReportViewerWebControl.axd control from within a web
> application on a web server to export a Reporting Services report in PDF
> format takes 5-10 minutes (note same problem no matter what export format
> used). The control was incorporated into the web application via Visual
> Studio. But when you export the same report using the web interface
> provided
> on the Reporting Services machine it runs in seconds. The web services
> machine of course is using the same control but it is on reporting
> services
> web machine, where as the slow application uses the control provided by
> Visual Studio which resides on the web box where the application lives.
> So
> why is the ReportViewer control on the application IIS box, so much slower
> than the ReportViewer on the Reporting Services IIS box for the same
> report?
> --
> If you are looking for SQL Server examples or a free SQL Server DBA
> Dashboard tool check out my Website at http://www.sqlserverexamples.com

ReportServer DB and ReportServerTempDB databases

Hi all,

Is it possible to cleanup ReportServer DB and ReportServerTempDB by setting the time interval ? For example, I want data in these two dbs to be deleted automatically after 5 or 10 minutes. How can I do that because as new reports are added and executed data goes on increasing in very short time and hurts performance.

Thanks,

Prashant

What data specifically are you trying to clean up? How are you measuring performance to know that this is the root of your problem?|||

Thanks for the reply !

No, there is no problem till now, but the data which is stored in tables like ChunkData, SnapShotData etc. is quite huge as many reports are running. I know, its temporary but is there any way from where I can set the time limit after which it will be cleaned up ?

Also one more thing, if I delete a report, what would happen to data stored in above tables ? Does it (data) get deleted with the deletion of report which populated them or does it remain in tables to be deleted after time limit ?

Thank again,

Prashant

|||

You need CleanupCycleMinutes in rsReportServer.config -- The default is 10 minutes.

<don't get me wrong here...>

It doesn't really sound like you know whether large orphaned snapshots are a perf problem in your scenario...by definition, they shouldn't be, as they are just blobs sitting around doing nothing. Even if you clean up more often, there's no win (unless you are storing snapshots to the filesystem with limited space) as I don't think the databases themselves are going to shrink for you anyway...You could actually make a situation which you think is bad worse by modifying this setting, as there's a cost to running the cleanup process. You don't want it firing all the time, and when most people modify it, the actually bump the value UP to make sure they don't get contention between the "normal" SSRS processes that read/write to these tables and the "cleanup" process.

</don't get me wrong here...>

Hope this helps?

|||

Thanks for opening my eyes ! Now I prefer to leave this cleaning task untouched and let RS take care of it.

Thanks again, Russell

Prashant

sql

Reports running much slower on SQL Express Edition of Reporting Services...

We have a SQL Server 2005 application that we deploy most of the time on SQL
Express, not full blown SQL. We have a Development box here (2 CPU XEON
with 4GB RAM) that has the Developer Edition and an instance of SQL Express
installed. If I run the same reports, with the same data, but one on the
developer edition and one on the Express Edition, there is a SIGNIFICANT
performance difference. This is a 1-page report - nothing huge, and it
renders in 2-3 seconds on Developer edition, but consistantly takes 15-20
seconds on the Express Edition.
I know SQL Express has a 1GB RAM limit, and a 1-CPU limit, but are there any
settings or anything that I can do to bring this closer to the full blown
SQL Version. This performance killing me onsite...
Any thoughts?
Thanks,
Markhave you identify if the problem is related to RS or SQL?
Does the SQL query is slower on the express edition? or the query takes the
same amount of time?
if the difference is here, then you have to play in the query and the
indexes to optimize it for the Express edition.
"Mark Essex" <messex@.netalytics.com> wrote in message
news:eyZTzG35HHA.980@.TK2MSFTNGP06.phx.gbl...
> We have a SQL Server 2005 application that we deploy most of the time on
> SQL Express, not full blown SQL. We have a Development box here (2 CPU
> XEON with 4GB RAM) that has the Developer Edition and an instance of SQL
> Express installed. If I run the same reports, with the same data, but one
> on the developer edition and one on the Express Edition, there is a
> SIGNIFICANT performance difference. This is a 1-page report - nothing
> huge, and it renders in 2-3 seconds on Developer edition, but consistantly
> takes 15-20 seconds on the Express Edition.
> I know SQL Express has a 1GB RAM limit, and a 1-CPU limit, but are there
> any settings or anything that I can do to bring this closer to the full
> blown SQL Version. This performance killing me onsite...
> Any thoughts?
> Thanks,
> Mark
>|||The query is 'instant' (less than a second) on both SQL Instances, so I
would say that this is an RS issue, not a SQL issue.
"Jeje" <willgart@.hotmail.com> wrote in message
news:2645D59B-223F-4F18-9712-AFF641F24C77@.microsoft.com...
> have you identify if the problem is related to RS or SQL?
> Does the SQL query is slower on the express edition? or the query takes
> the same amount of time?
> if the difference is here, then you have to play in the query and the
> indexes to optimize it for the Express edition.
>
> "Mark Essex" <messex@.netalytics.com> wrote in message
> news:eyZTzG35HHA.980@.TK2MSFTNGP06.phx.gbl...
>> We have a SQL Server 2005 application that we deploy most of the time on
>> SQL Express, not full blown SQL. We have a Development box here (2 CPU
>> XEON with 4GB RAM) that has the Developer Edition and an instance of SQL
>> Express installed. If I run the same reports, with the same data, but
>> one on the developer edition and one on the Express Edition, there is a
>> SIGNIFICANT performance difference. This is a 1-page report - nothing
>> huge, and it renders in 2-3 seconds on Developer edition, but
>> consistantly takes 15-20 seconds on the Express Edition.
>> I know SQL Express has a 1GB RAM limit, and a 1-CPU limit, but are there
>> any settings or anything that I can do to bring this closer to the full
>> blown SQL Version. This performance killing me onsite...
>> Any thoughts?
>> Thanks,
>> Mark
>>|||what is the connection string used by the report?
and does RS and SQL are on the same server?
"Mark Essex" <messex@.netalytics.com> wrote in message
news:eoyjDAJ6HHA.4880@.TK2MSFTNGP03.phx.gbl...
> The query is 'instant' (less than a second) on both SQL Instances, so I
> would say that this is an RS issue, not a SQL issue.
> "Jeje" <willgart@.hotmail.com> wrote in message
> news:2645D59B-223F-4F18-9712-AFF641F24C77@.microsoft.com...
>> have you identify if the problem is related to RS or SQL?
>> Does the SQL query is slower on the express edition? or the query takes
>> the same amount of time?
>> if the difference is here, then you have to play in the query and the
>> indexes to optimize it for the Express edition.
>>
>> "Mark Essex" <messex@.netalytics.com> wrote in message
>> news:eyZTzG35HHA.980@.TK2MSFTNGP06.phx.gbl...
>> We have a SQL Server 2005 application that we deploy most of the time on
>> SQL Express, not full blown SQL. We have a Development box here (2 CPU
>> XEON with 4GB RAM) that has the Developer Edition and an instance of SQL
>> Express installed. If I run the same reports, with the same data, but
>> one on the developer edition and one on the Express Edition, there is a
>> SIGNIFICANT performance difference. This is a 1-page report - nothing
>> huge, and it renders in 2-3 seconds on Developer edition, but
>> consistantly takes 15-20 seconds on the Express Edition.
>> I know SQL Express has a 1GB RAM limit, and a 1-CPU limit, but are there
>> any settings or anything that I can do to bring this closer to the full
>> blown SQL Version. This performance killing me onsite...
>> Any thoughts?
>> Thanks,
>> Mark
>>
>|||COnnection string looks like:
data source=.\installs; initial catalog = Methasoft53
RS and SQL are on the same machine.
Would the '.\installs' cause issues, meaning should I put the MACHINE NAME
in there, instead of using the 'dot' notation? Maybe a 'lookup' time issue?
Thanks,
Mark
"Jeje" <willgart@.hotmail.com> wrote in message
news:6C308FB1-6A82-440F-9746-8BED264C9313@.microsoft.com...
> what is the connection string used by the report?
> and does RS and SQL are on the same server?
> "Mark Essex" <messex@.netalytics.com> wrote in message
> news:eoyjDAJ6HHA.4880@.TK2MSFTNGP03.phx.gbl...
>> The query is 'instant' (less than a second) on both SQL Instances, so I
>> would say that this is an RS issue, not a SQL issue.
>> "Jeje" <willgart@.hotmail.com> wrote in message
>> news:2645D59B-223F-4F18-9712-AFF641F24C77@.microsoft.com...
>> have you identify if the problem is related to RS or SQL?
>> Does the SQL query is slower on the express edition? or the query takes
>> the same amount of time?
>> if the difference is here, then you have to play in the query and the
>> indexes to optimize it for the Express edition.
>>
>> "Mark Essex" <messex@.netalytics.com> wrote in message
>> news:eyZTzG35HHA.980@.TK2MSFTNGP06.phx.gbl...
>> We have a SQL Server 2005 application that we deploy most of the time
>> on SQL Express, not full blown SQL. We have a Development box here (2
>> CPU XEON with 4GB RAM) that has the Developer Edition and an instance
>> of SQL Express installed. If I run the same reports, with the same
>> data, but one on the developer edition and one on the Express Edition,
>> there is a SIGNIFICANT performance difference. This is a 1-page
>> report - nothing huge, and it renders in 2-3 seconds on Developer
>> edition, but consistantly takes 15-20 seconds on the Express Edition.
>> I know SQL Express has a 1GB RAM limit, and a 1-CPU limit, but are
>> there any settings or anything that I can do to bring this closer to
>> the full blown SQL Version. This performance killing me onsite...
>> Any thoughts?
>> Thanks,
>> Mark
>>
>>|||to see if there is a naming resolution issue, open the profiler on your
server, then run the report.
if you see the query 10 seconds after you click "view report", then there is
a name resolution issue. if you see the query in less then 1second, then
there is no naming issue and the problem is somewhere else.
but using the . (dot) should not cause name resolution issue.
but maybe there is an authentication issue.
try to use an SQL Server login instead of the windows authentication
data source=.\installs; initial catalog =Methasoft53;uid=<user>;pwd=<password>
"Mark Essex" <messex@.netalytics.com> wrote in message
news:Oqg98Rp6HHA.4584@.TK2MSFTNGP03.phx.gbl...
> COnnection string looks like:
> data source=.\installs; initial catalog = Methasoft53
> RS and SQL are on the same machine.
> Would the '.\installs' cause issues, meaning should I put the MACHINE NAME
> in there, instead of using the 'dot' notation? Maybe a 'lookup' time
> issue?
> Thanks,
> Mark
> "Jeje" <willgart@.hotmail.com> wrote in message
> news:6C308FB1-6A82-440F-9746-8BED264C9313@.microsoft.com...
>> what is the connection string used by the report?
>> and does RS and SQL are on the same server?
>> "Mark Essex" <messex@.netalytics.com> wrote in message
>> news:eoyjDAJ6HHA.4880@.TK2MSFTNGP03.phx.gbl...
>> The query is 'instant' (less than a second) on both SQL Instances, so I
>> would say that this is an RS issue, not a SQL issue.
>> "Jeje" <willgart@.hotmail.com> wrote in message
>> news:2645D59B-223F-4F18-9712-AFF641F24C77@.microsoft.com...
>> have you identify if the problem is related to RS or SQL?
>> Does the SQL query is slower on the express edition? or the query takes
>> the same amount of time?
>> if the difference is here, then you have to play in the query and the
>> indexes to optimize it for the Express edition.
>>
>> "Mark Essex" <messex@.netalytics.com> wrote in message
>> news:eyZTzG35HHA.980@.TK2MSFTNGP06.phx.gbl...
>> We have a SQL Server 2005 application that we deploy most of the time
>> on SQL Express, not full blown SQL. We have a Development box here (2
>> CPU XEON with 4GB RAM) that has the Developer Edition and an instance
>> of SQL Express installed. If I run the same reports, with the same
>> data, but one on the developer edition and one on the Express Edition,
>> there is a SIGNIFICANT performance difference. This is a 1-page
>> report - nothing huge, and it renders in 2-3 seconds on Developer
>> edition, but consistantly takes 15-20 seconds on the Express Edition.
>> I know SQL Express has a 1GB RAM limit, and a 1-CPU limit, but are
>> there any settings or anything that I can do to bring this closer to
>> the full blown SQL Version. This performance killing me onsite...
>> Any thoughts?
>> Thanks,
>> Mark
>>
>>
>

Reports run automatically w/ Allow Null parameters?

I wrote a stored procedure with two paramters, both of which are nullable but
both should not be null at the same time... it is either one or the other...
if both are null then I return an error from the stored procedure.
So now I am making the report to use this stored procedure.
When I click the "Allow null value" checkbox for both report parameters, the
report run automatically without waiting for the user to click the "View
Report" button! This creates a situation where if the user navigates to the
report using the Report Manager web application, then it will always first
give an error and then the user can enter a value and re-execute the report.
Is there some way to ALLOW null but not ASSUME null? I would like the user
to see the textbox for typing the parameter values and also see the unchecked
boxes for nulls.
PS: Both report parameters currently have the "None" as their default value.I have the exact same problem. Anyone find a solution for this?
"Al" wrote:
> I wrote a stored procedure with two paramters, both of which are nullable but
> both should not be null at the same time... it is either one or the other...
> if both are null then I return an error from the stored procedure.
> So now I am making the report to use this stored procedure.
> When I click the "Allow null value" checkbox for both report parameters, the
> report run automatically without waiting for the user to click the "View
> Report" button! This creates a situation where if the user navigates to the
> report using the Report Manager web application, then it will always first
> give an error and then the user can enter a value and re-execute the report.
> Is there some way to ALLOW null but not ASSUME null? I would like the user
> to see the textbox for typing the parameter values and also see the unchecked
> boxes for nulls.
> PS: Both report parameters currently have the "None" as their default value.
>

Report's Parameter : From Date to Date

I want to add 2 parameters in my report to delimit a date range. The report is based on Analysis Services 2005 and I have created a Time Dimension. What is the best way to do this ?

I would prefer to use a Datetime parameter type because of the calendar component, but then I don't succeed to associate this parameter with the Time Dimension in the filter expression...

I really need an answer to that question, please help me |||You can't really use a datetime parameter (at least not using the built-in prompting) as AS dates are members of a dimension, not scalars. And you aren't really guaranteed that the range between two members will give you what you want. We could add a feature at some point to convert them but that doesn't exist now.|||

Thanks for the answer.

I just found a solution to my problem, even if the solution is not what I hoped for, it may help someone :

I created two Report Parameters "From Date" and "To Date" which use the calendar component to let the user choose a date. And in my Dataset, in the '...' button, in the 'Parameters' bar, I add a parameter whose value is :

="[Temps].[Temps - Date Key].[" & Year(Parameters!FromTempsTempsCalendrier.Value) & "-" & IIF(Month(Parameters!FromTempsTempsCalendrier.Value)<10,"0","") & Month(Parameters!FromTempsTempsCalendrier.Value) & "-" & IIF(Day(Parameters!FromTempsTempsCalendrier.Value)<10, "0","") & Day(Parameters!FromTempsTempsCalendrier.Value) & " 00:00:00]"

That way, I build the UNIQUENAME properties of my Time Dimension.

But an error occurs when the user select a date which does not exist in the Time Dimension.

|||

Thanks for the possible solution. However, I've been working on following your steps, but I am not getting it to work.

Could you explain in a little more detail how to accomplish this?

Reports only render sometimes

I am experiencening the folowing problem with RS SP2. My reports do not
render all of the time, sometimes they run fine in a few seconds other times
they simply do not run. These are small reports with only a few hundred
records in the dataset.
They are using store procedures to generate the data and the stored
procedures always finish, so i am assuming it is at the rendering stages
where i am experiencing this intermittent problem.
Has anyone any idea where to start looking or diagnosing. I can see no
logic or pattern that is causing the reports to fail only sometimes.
I would be the most grateful man in the world if somebody could help.
--
Gerry ConnollyCheck the Reporting Services error logs and see if you see an "Assert" error
in there. If you do then it could be related to the AMD Cool N' Quiet
technology.
Add the following line to your boot.ini after your other boot switches and
see if that works.
switch: /usepmtimer
More information about this can be found here:
http://support.microsoft.com/kb/895980/en-us
--
SQL Server Developer Support Engineer
"GerryC" wrote:
> I am experiencening the folowing problem with RS SP2. My reports do not
> render all of the time, sometimes they run fine in a few seconds other times
> they simply do not run. These are small reports with only a few hundred
> records in the dataset.
> They are using store procedures to generate the data and the stored
> procedures always finish, so i am assuming it is at the rendering stages
> where i am experiencing this intermittent problem.
> Has anyone any idea where to start looking or diagnosing. I can see no
> logic or pattern that is causing the reports to fail only sometimes.
> I would be the most grateful man in the world if somebody could help.
> --
> Gerry Connolly

Reports not running simultaneously.

On our SQL 2005 box it seems that only one report will run at a time. For
example, if I run one of our reports which takes about a minute to complete,
then I try to run another report (even a small one that takes a second to
run) the second report will just stay as a blank screen until the first
report finishes running. Then it will complete.
Is this a setting that can be changed? The reports do no use up all of the
CPU or memory on the server so there are resources available for more reports
to run. I would like to get these reports running simultaneously, especially
the long ones I have scheduled for after hours executions.It sounds like someone set the throttling option to just 1 report per user.
You can change this option - look for this in your rsreportserver.config
file:
(This one is the installation default)
<Add Key="MaxActiveReqForOneUser" Value="20"/>
=-Chris
"Matt M" <MattM@.discussions.microsoft.com> wrote in message
news:6F3ED62A-49B5-456E-A166-ABA523645A22@.microsoft.com...
> On our SQL 2005 box it seems that only one report will run at a time. For
> example, if I run one of our reports which takes about a minute to
> complete,
> then I try to run another report (even a small one that takes a second to
> run) the second report will just stay as a blank screen until the first
> report finishes running. Then it will complete.
> Is this a setting that can be changed? The reports do no use up all of the
> CPU or memory on the server so there are resources available for more
> reports
> to run. I would like to get these reports running simultaneously,
> especially
> the long ones I have scheduled for after hours executions.|||That setting is already set to 20 in the config file. Is there anything else
that would stop a user from running more than one report at a time?
"Chris Conner" wrote:
> It sounds like someone set the throttling option to just 1 report per user.
> You can change this option - look for this in your rsreportserver.config
> file:
> (This one is the installation default)
> <Add Key="MaxActiveReqForOneUser" Value="20"/>
> =-Chris
> "Matt M" <MattM@.discussions.microsoft.com> wrote in message
> news:6F3ED62A-49B5-456E-A166-ABA523645A22@.microsoft.com...
> > On our SQL 2005 box it seems that only one report will run at a time. For
> > example, if I run one of our reports which takes about a minute to
> > complete,
> > then I try to run another report (even a small one that takes a second to
> > run) the second report will just stay as a blank screen until the first
> > report finishes running. Then it will complete.
> >
> > Is this a setting that can be changed? The reports do no use up all of the
> > CPU or memory on the server so there are resources available for more
> > reports
> > to run. I would like to get these reports running simultaneously,
> > especially
> > the long ones I have scheduled for after hours executions.
>
>|||are you using Office Writer by SoftArtisans?
-Tom
Chris Conner wrote:
> It sounds like someone set the throttling option to just 1 report per user.
> You can change this option - look for this in your rsreportserver.config
> file:
> (This one is the installation default)
> <Add Key="MaxActiveReqForOneUser" Value="20"/>
> =-Chris
> "Matt M" <MattM@.discussions.microsoft.com> wrote in message
> news:6F3ED62A-49B5-456E-A166-ABA523645A22@.microsoft.com...
> > On our SQL 2005 box it seems that only one report will run at a time. For
> > example, if I run one of our reports which takes about a minute to
> > complete,
> > then I try to run another report (even a small one that takes a second to
> > run) the second report will just stay as a blank screen until the first
> > report finishes running. Then it will complete.
> >
> > Is this a setting that can be changed? The reports do no use up all of the
> > CPU or memory on the server so there are resources available for more
> > reports
> > to run. I would like to get these reports running simultaneously,
> > especially
> > the long ones I have scheduled for after hours executions.|||No we are not.
"punjab_tom@.hotmail.com" wrote:
> are you using Office Writer by SoftArtisans?
> -Tom
>
>
> Chris Conner wrote:
> > It sounds like someone set the throttling option to just 1 report per user.
> >
> > You can change this option - look for this in your rsreportserver.config
> > file:
> > (This one is the installation default)
> >
> > <Add Key="MaxActiveReqForOneUser" Value="20"/>
> >
> > =-Chris
> >
> > "Matt M" <MattM@.discussions.microsoft.com> wrote in message
> > news:6F3ED62A-49B5-456E-A166-ABA523645A22@.microsoft.com...
> > > On our SQL 2005 box it seems that only one report will run at a time. For
> > > example, if I run one of our reports which takes about a minute to
> > > complete,
> > > then I try to run another report (even a small one that takes a second to
> > > run) the second report will just stay as a blank screen until the first
> > > report finishes running. Then it will complete.
> > >
> > > Is this a setting that can be changed? The reports do no use up all of the
> > > CPU or memory on the server so there are resources available for more
> > > reports
> > > to run. I would like to get these reports running simultaneously,
> > > especially
> > > the long ones I have scheduled for after hours executions.
>

ReportingWeekToMonthPattern possible values

Hi, I'm working with a server Time dimension which one of it's many purposes is to provide sales analysis by Reporting week. I'm using the property ReportingWeekToMonthPattern to divide the months in weeks but none of the default values is good to me {4-4-5 | 4-5-4 | 544}. According to the business rules, the pattern is not that regular and instead, I need this exact pattern that includes the 12 months of the year:

4-4-5-4-4-5-4-5-4-4-5-4

That is, the first half of the year with a 4-4-5 pattern, and the second half with a 4-5-4 pattern. Is this possible to set in the dimension?

Thanks in advance,

RAH

I don't think you can do this using a server time dimension. You would probably need to create a dimension table and build your time dimension off it. That way you can do pretty much anything you like.

reportingsvcs 2000 grouping by week

Hi, I have a yearly report that needs to be group by week. How I make
the report group my data by week? At this time I have it running with
@.startdate and @.enddate, but the big boss needs the report group by
week. All help and advice will be a great help.
Thanks
abzOn Jul 11, 6:01 pm, abz <abz81s...@.gmail.com> wrote:
> Hi, I have a yearly report that needs to be group by week. How I make
> the report group my data by week? At this time I have it running with
> @.startdate and @.enddate, but the big boss needs the report group by
> week. All help and advice will be a great help.
> Thanks
> abz
Right-click the table/matrix control and select Properties. Select the
Groups tab and select the Add.../Edit... button. Below Group on: ->
Expression enter an expression similar to the following:
=Datepart("ww", Fields!SomeFieldName.Value)
Regards,
Enrique Martinez
Sr. Software Consultant|||On Jul 11, 6:19 pm, EMartinez <emartinez...@.gmail.com> wrote:
> On Jul 11, 6:01 pm, abz <abz81s...@.gmail.com> wrote:
> > Hi, I have a yearly report that needs to be group by week. How I make
> > the report group my data by week? At this time I have it running with
> > @.startdate and @.enddate, but the big boss needs the report group by
> > week. All help and advice will be a great help.
> > Thanks
> > abz
> Right-click the table/matrix control and select Properties. Select the
> Groups tab and select the Add.../Edit... button. Below Group on: ->
> Expression enter an expression similar to the following:
> =Datepart("ww", Fields!SomeFieldName.Value)
> Regards,
> Enrique Martinez
> Sr. Software Consultant
Thank you very much Enrique, it grouped it by week, but the date it
show jumps around. Meaning, it dont displays every friday as the
display date, it shows monday as the date for one week, the week after
is friday. How do I make it display every friday?
=DatePart("ww", Fields!DESIRED_WANT_DATE.Value)
I read some where about putting +5, or an actual day of week (friday).
Would that apply to this?
Thanks again,
abz|||On Jul 13, 12:37 pm, abz <abz81s...@.gmail.com> wrote:
> On Jul 11, 6:19 pm, EMartinez <emartinez...@.gmail.com> wrote:
>
> > On Jul 11, 6:01 pm, abz <abz81s...@.gmail.com> wrote:
> > > Hi, I have a yearly report that needs to be group by week. How I make
> > > the report group my data by week? At this time I have it running with
> > > @.startdate and @.enddate, but the big boss needs the report group by
> > > week. All help and advice will be a great help.
> > > Thanks
> > > abz
> > Right-click the table/matrix control and select Properties. Select the
> > Groups tab and select the Add.../Edit... button. Below Group on: ->
> > Expression enter an expression similar to the following:
> > =Datepart("ww", Fields!SomeFieldName.Value)
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant
> Thank you very much Enrique, it grouped it by week, but the date it
> show jumps around. Meaning, it dont displays every friday as the
> display date, it shows monday as the date for one week, the week after
> is friday. How do I make it display every friday?
> =DatePart("ww", Fields!DESIRED_WANT_DATE.Value)
> I read some where about putting +5, or an actual day of week (friday).
> Would that apply to this?
> Thanks again,
> abz
You're welcome. Yes, that should apply to this scenario.
Regards,
Enrique Martinez
Sr. Software Consultant|||mmm...well for some reason its not working. Is it because the way
that is written?
=(DatePart("ww", Fields!DESIRED_WANT_DATE.Value)+6)
Also, is it because the Fields!DESIRED_WANT_DATE.Value is an actual
field that already has dates filled in Visual'
well, thanks once again for your help
Abz|||On Jul 16, 11:08 am, abz <abz81s...@.gmail.com> wrote:
> mmm...well for some reason its not working. Is it because the way
> that is written?
> =(DatePart("ww", Fields!DESIRED_WANT_DATE.Value)+6)
> Also, is it because the Fields!DESIRED_WANT_DATE.Value is an actual
> field that already has dates filled in Visual'
> well, thanks once again for your help
> Abz
You might want to use something like:
=DatePart("ww", Dateadd("d", 6, Fields!DESIRED_WANT_DATE.Value))
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||On Jul 16, 4:27 pm, EMartinez <emartinez...@.gmail.com> wrote:
> On Jul 16, 11:08 am, abz <abz81s...@.gmail.com> wrote:
> > mmm...well for some reason its not working. Is it because the way
> > that is written?
> > =(DatePart("ww", Fields!DESIRED_WANT_DATE.Value)+6)
> > Also, is it because the Fields!DESIRED_WANT_DATE.Value is an actual
> > field that already has dates filled in Visual'
> > well, thanks once again for your help
> > Abz
> You might want to use something like:
> =DatePart("ww", Dateadd("d", 6, Fields!DESIRED_WANT_DATE.Value))
> Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
This is very weird.....the expression worked for a different report
I tried it on, but the one I really need it on still dont take. I dont
know what's wrong with it, but Enrique, thank you very much with the
grouping.
Now, dont want to be a pain, but I know to get current date is
GETDATE(), but if I want a report to be just for the current month,
what would the expression be? I tried =DatePart("m",
SHIPPER.SHIPPED_DATE) also =DATEADD(month, shipper.shipped_date) and
that dont work...I also tried GETMONTH() but I found out that dont
exist...well, if its possible your help is very greatful...
once again...Thank You very much
Abner|||On Jul 18, 11:27 am, abz <abz81s...@.gmail.com> wrote:
> On Jul 16, 4:27 pm, EMartinez <emartinez...@.gmail.com> wrote:
>
> > On Jul 16, 11:08 am, abz <abz81s...@.gmail.com> wrote:
> > > mmm...well for some reason its not working. Is it because the way
> > > that is written?
> > > =(DatePart("ww", Fields!DESIRED_WANT_DATE.Value)+6)
> > > Also, is it because the Fields!DESIRED_WANT_DATE.Value is an actual
> > > field that already has dates filled in Visual'
> > > well, thanks once again for your help
> > > Abz
> > You might want to use something like:
> > =DatePart("ww", Dateadd("d", 6, Fields!DESIRED_WANT_DATE.Value))
> > Hope this helps.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant
> This is very weird.....the expression worked for a different report
> I tried it on, but the one I really need it on still dont take. I dont
> know what's wrong with it, but Enrique, thank you very much with the
> grouping.
> Now, dont want to be a pain, but I know to get current date is
> GETDATE(), but if I want a report to be just for the current month,
> what would the expression be? I tried =DatePart("m",
> SHIPPER.SHIPPED_DATE) also =DATEADD(month, shipper.shipped_date) and
> that dont work...I also tried GETMONTH() but I found out that dont
> exist...well, if its possible your help is very greatful...
> once again...Thank You very much
> Abner
You are correct for the report expression: to get the month. The
format is:
=DatePart("m", Now())
-or- you could use
=DatePart("m", Fields!SHIPPED_DATE.Value)
Of course, in SQL it would be:
datepart(mm, getdate())
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant

Reporting SVCS Error and Deadlock Victim Error

Hi Everyone,
I having a problem when generating the reports. Some time, the report generation are slow and there is frequent intermitten reporting svcs error such as process ID 86 or Deadlock victim error. But, some time the report generation are ok.
Please help !! Thank you.
Best Regard,
Terence Wong
I am speculating - but
Is there a "deadly embrace" on the table you are going after - cause you are timing out - and that indicates to me there is another process (ID 86) that is causing the "hang"..
Or in the SQL statement do you have a JOIN that is not correct -
Take your SQL statement your are using within the MS RS report and paste into query analyzer and
Within Query Analyzer <Query> <Display Estimated Execution Plan> this wil ltell you where the hang up is based upon percentages for every step within the SQL statement. As a general rule anything over 30% could potentially be a problem!
best regards,

Reporting Services-getting started

Someone pleeeease help me. I need help creating a report. A simple report
in SQL 2005. I use Access and ADP's all the time - the reports are very easy
to create, modify, etc. I'd like to know how to make a report using
Reporting Services. The "help" is of no use - I can't understand how to even
use the report wizard. It seems like there are 610 different ways to do one
simple thing - create a report.
I have views of data that I have created that I need to present - in report
format, with groupings, totals, etc. Can someone please tell me how to do
this?
Also, what are the benefits of using reporting services versus just creating
an ADP and developing reports the old fashioned way? Seriously, what ARE the
benefits?
Any help would be very welcomed. Thanks.
--
FrustratedHey Craig,
"Craig" <Craig@.discussions.microsoft.com> wrote in message
news:6137FDEC-B961-48F9-BA30-89ECFECF9AE9@.microsoft.com...
> Someone pleeeease help me. I need help creating a report. A simple
> report
> in SQL 2005. I use Access and ADP's all the time - the reports are very
> easy
> to create, modify, etc. I'd like to know how to make a report using
> Reporting Services. The "help" is of no use - I can't understand how to
> even
> use the report wizard. It seems like there are 610 different ways to do
> one
> simple thing - create a report.
> I have views of data that I have created that I need to present - in
> report
> format, with groupings, totals, etc. Can someone please tell me how to do
> this?
> Also, what are the benefits of using reporting services versus just
> creating
> an ADP and developing reports the old fashioned way? Seriously, what ARE
> the
> benefits?
What's ADP? I worked with Access but this acronym is missing in my
vocabulary.
A damn good book (although on RS 2000) is the Hitchhikers Guide to Reporting
Services.
About RS: Sorry but to me it looks pretty straightforward. You create a
report, create datasets that query a datasource that you might have to
create. Then you stick those into the report and format them. W/o more
detailed information about where you're stuck it's hard to help you.
Christoph|||If ADPs are doing what you need then I would suggest just continuing with
them.
ADPs require Access to be installed at each PC. And the same version of
Access. If this is not a problem and it is working well for you then you can
just continue to use them.
RS is a server based product. You develop and then deploy. As a server based
product there is more infrastructure to setup (versus ADPs). You have to
know about IIS, Windows 2003 and SQL Server.
Access is a much more mature product and in my opion has better wizards. RS
would do well to add additional wizards. But that being said, if you create
a report using the wizard in RS it does allow you to group and it adds the
group and totals for you. Have you tried something simple just to test?
Advantages of RS. Server based, clients only need a browser. Format
independent reports, render to different formats: Html, Excel, PDF, CSV etc.
Can integrate with own apps either with URL integration, web services or
controls which ship with VS 2005.
One other point, there are walkthroughs but they start from scratch, not
using the wizard. I suggest first creating some sample reports using the
wizard and then modifying the report.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Craig" <Craig@.discussions.microsoft.com> wrote in message
news:6137FDEC-B961-48F9-BA30-89ECFECF9AE9@.microsoft.com...
> Someone pleeeease help me. I need help creating a report. A simple
> report
> in SQL 2005. I use Access and ADP's all the time - the reports are very
> easy
> to create, modify, etc. I'd like to know how to make a report using
> Reporting Services. The "help" is of no use - I can't understand how to
> even
> use the report wizard. It seems like there are 610 different ways to do
> one
> simple thing - create a report.
> I have views of data that I have created that I need to present - in
> report
> format, with groupings, totals, etc. Can someone please tell me how to do
> this?
> Also, what are the benefits of using reporting services versus just
> creating
> an ADP and developing reports the old fashioned way? Seriously, what ARE
> the
> benefits?
> Any help would be very welcomed. Thanks.
> --
> Frustrated|||In Books Online look for Report Wizard. There will be two hits for it. Look
at report wizard help.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Craig" <Craig@.discussions.microsoft.com> wrote in message
news:6137FDEC-B961-48F9-BA30-89ECFECF9AE9@.microsoft.com...
> Someone pleeeease help me. I need help creating a report. A simple
> report
> in SQL 2005. I use Access and ADP's all the time - the reports are very
> easy
> to create, modify, etc. I'd like to know how to make a report using
> Reporting Services. The "help" is of no use - I can't understand how to
> even
> use the report wizard. It seems like there are 610 different ways to do
> one
> simple thing - create a report.
> I have views of data that I have created that I need to present - in
> report
> format, with groupings, totals, etc. Can someone please tell me how to do
> this?
> Also, what are the benefits of using reporting services versus just
> creating
> an ADP and developing reports the old fashioned way? Seriously, what ARE
> the
> benefits?
> Any help would be very welcomed. Thanks.
> --
> Frustrated|||Thanks for the help...
--
Craig
"Bruce L-C [MVP]" wrote:
> In Books Online look for Report Wizard. There will be two hits for it. Look
> at report wizard help.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Craig" <Craig@.discussions.microsoft.com> wrote in message
> news:6137FDEC-B961-48F9-BA30-89ECFECF9AE9@.microsoft.com...
> > Someone pleeeease help me. I need help creating a report. A simple
> > report
> > in SQL 2005. I use Access and ADP's all the time - the reports are very
> > easy
> > to create, modify, etc. I'd like to know how to make a report using
> > Reporting Services. The "help" is of no use - I can't understand how to
> > even
> > use the report wizard. It seems like there are 610 different ways to do
> > one
> > simple thing - create a report.
> >
> > I have views of data that I have created that I need to present - in
> > report
> > format, with groupings, totals, etc. Can someone please tell me how to do
> > this?
> >
> > Also, what are the benefits of using reporting services versus just
> > creating
> > an ADP and developing reports the old fashioned way? Seriously, what ARE
> > the
> > benefits?
> >
> > Any help would be very welcomed. Thanks.
> >
> > --
> > Frustrated
>
>

Reporting Services/BI Model processing

My company is in the process of migrating to SQL Reporting Services 2005. At
this time we are most interested in the Business Intelligence functionality
included in SS2K5. While we were testing this product we had everything all
on the same box...SS, Reporting Services, web tools...everything. Now, we are
scaling out the project and are trying to determine where the processing of
the reports and BI models takes place. Is it on the SQL Server box or on the
Reporting Services box?
Thanks in advance!!
--
ManuelRS is a aps.net application. It uses SQL Server databases for its object and
metadata storage. It stores reporting definitions, subscriptions, etc.
Rendering occurs in RAM. So, a big report can definitely really drag on the
server. Then, if your data is also coming from SQL Server then SQL Server DB
engine has the work to retrieve the data. This is totally separate from the
work that RS is doing.
When RS is put on its own server you still need to have a SQL Server license
for the box. It doesn't matter where the RS databases reside (ReportServer
and ReportServerTempDB). My advice is, unless you are doing a web farm,
install the SQL Server database for the metadata storage on the box that
will run RS. Then keep the data you are reporting off of on a second box. In
that way, the temp data storage, the report definitions, etc are close at
hand. And, a big report won't slow down your database server which contains
your data.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"mlg1906" <mlg1906@.discussions.microsoft.com> wrote in message
news:256AEE4E-AC81-4388-A20B-67247EE7EA59@.microsoft.com...
> My company is in the process of migrating to SQL Reporting Services 2005.
> At
> this time we are most interested in the Business Intelligence
> functionality
> included in SS2K5. While we were testing this product we had everything
> all
> on the same box...SS, Reporting Services, web tools...everything. Now, we
> are
> scaling out the project and are trying to determine where the processing
> of
> the reports and BI models takes place. Is it on the SQL Server box or on
> the
> Reporting Services box?
> Thanks in advance!!
> --
> Manuel
>|||We're a lot clearer on what our approach will be. Thanks a million!
--
Manuel
"Bruce L-C [MVP]" wrote:
> RS is a aps.net application. It uses SQL Server databases for its object and
> metadata storage. It stores reporting definitions, subscriptions, etc.
> Rendering occurs in RAM. So, a big report can definitely really drag on the
> server. Then, if your data is also coming from SQL Server then SQL Server DB
> engine has the work to retrieve the data. This is totally separate from the
> work that RS is doing.
> When RS is put on its own server you still need to have a SQL Server license
> for the box. It doesn't matter where the RS databases reside (ReportServer
> and ReportServerTempDB). My advice is, unless you are doing a web farm,
> install the SQL Server database for the metadata storage on the box that
> will run RS. Then keep the data you are reporting off of on a second box. In
> that way, the temp data storage, the report definitions, etc are close at
> hand. And, a big report won't slow down your database server which contains
> your data.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "mlg1906" <mlg1906@.discussions.microsoft.com> wrote in message
> news:256AEE4E-AC81-4388-A20B-67247EE7EA59@.microsoft.com...
> > My company is in the process of migrating to SQL Reporting Services 2005.
> > At
> > this time we are most interested in the Business Intelligence
> > functionality
> > included in SS2K5. While we were testing this product we had everything
> > all
> > on the same box...SS, Reporting Services, web tools...everything. Now, we
> > are
> > scaling out the project and are trying to determine where the processing
> > of
> > the reports and BI models takes place. Is it on the SQL Server box or on
> > the
> > Reporting Services box?
> >
> > Thanks in advance!!
> > --
> > Manuel
> >
>
>