Showing posts with label load. Show all posts
Showing posts with label load. Show all posts

Friday, March 30, 2012

Reportviewer does not load properly in a content page

Hi all,

I have two (2) questions here:

1) I have a reportviewer control in an aspx page. It is remote access server report. Everything works fine from report server and in vs 2005. But Report does not load properly once put on a content page. The multi-value parameter dropdown list is not clickable! It worked in a non master/content page.

Here is my code for the page that does not work:

<%@. Page Language="C#" MasterPageFile="~/FysbReviewer.master" AutoEventWireup="true" CodeFile="ReportsMenu.aspx.cs" Inherits="ReportsMenu" Title="Report Menu" %><%@. Register Assembly="Microsoft.ReportViewer.WebForms, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" Namespace="Microsoft.Reporting.WebForms" TagPrefix="rsweb" %>
<asp:Content ID="Content3" ContentPlaceHolderID="ContentPlaceHolder3" Runat="Server">

<rsweb:ReportViewer ID="ReportViewer1" runat="server" style="position:static" ShowParameterPrompts="true"
Font-Names="Verdana" Font-Size="8pt" Height="800px" ProcessingMode="Remote" Width="100%">
<ServerReport ReportPath="/FysbReports/Report1" />
</rsweb:ReportViewer>
</asp:Content>

Here is the code that reportviewer worked:

<%@. Page Language="C#" AutoEventWireup="true" CodeFile="Default3.aspx.cs" Inherits="Default3" %>

<%@. Register Assembly="Microsoft.ReportViewer.WebForms, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"
Namespace="Microsoft.Reporting.WebForms" TagPrefix="rsweb" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Untitled Page</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<rsweb:reportviewer id="ReportViewer1" runat="server" font-names="Verdana" font-size="8pt"
height="800px" processingmode="Remote" width="100%">
<ServerReport ReportPath="/FysbReports/Report1"></ServerReport>
</rsweb:reportviewer>

</div>
</form>
</body>
</html>

Question 2: How can I format the multi-value parameter prompts so that all selection are displayed as checkbox directly instead of clicking the dropdownlist and view the multple choices?

I know it is Friday afternoo. I want to say TIG Friday, but it looks like a long Friday afternoon ahead... Please help!

Hi,

From your description, it seems that your reportviewer works in a normal page but not in a master/content page, right?

Generally, for this kind of issue, the main issue is that the resource of ReportPath attribute of ServerReport maps doesn't exist. You should try to check the relative path of each resource to see if they match the relationship of your masterpage, content and the reportpath.

Second, the viewer does support multivalue parameters, but it doesn't have any concept of parsing based on comma or any other separator. When you supply the value from your textbox to the report, you will need to write your code and parse it on your own and supply the array of values to the ReportParameter object.

Thanks.

ReportViewer control Impersonate User

I need to impersonate to allow my asp.net ReportViewer control to load
reports from my SQL 2005 reporting server.
I have two ways of doing that and I was wondering which way was best
practice (or if there is any better way):
--
Method1: impersonate in in web.config
identity impersonate="true" userName="domain\username" password="password"
--
Method2: override IReportServerCredentials
...
if (!Page.IsPostBack)
rv1.ServerReport.ReportServerCredentials = new
MyReportServerCredentials();
...
[Serializable]
public sealed class MyReportServerCredentials : IReportServerCredentials
...
return new NetworkCredential(...)
(above explained excellantly in
http://msdn2.microsoft.com/en-us/library/microsoft.reporting.webforms.ireportservercredentials(VS.80).aspx)
Thank you!Hello Dev,
I suggest you use the second method. If you impersonate in the web.config
file, the whole application will effected and since you hardcode your
credential information in the web.config, it may have some security issue.
If you use the IReportCredentials and programmatically specify the
credential, it only use on the page which include the ReportViewer Control
which is more secure.
Hope this helps.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
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.)|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
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.

Wednesday, March 28, 2012

ReportViewer control - load parameter

Using Reporting Services in VS.Net 2005 (very much a newbie, though not a
newbie to ASP.Net)
I have a report which runs a Stored Procedure, requiring a parameter -
BudgetID -
In this particular case I just created an ASP.Net page (content page), and I
add a reportViewer control - the wizard picks up my report and creates an
ObjectDataSource, and assigns the report, but nothing is done or asked about
the BudgetID -
I found a reference on the web (in 2004) which showed that I could do
something like this in code:
ReportViewer1.SetQueryParameter("ProductCategory",CategoryDropDown.SelectedV
alue);
So I thought I could do something like this in the page load event - but it
doesn't like the SetqueryParameter method - and searching through all the
properties and methods, I can't seem to find anything like this.
Could someone please shed some light on this for me, please?You need to create an array of
Microsoft.Reporting.WebForms.ReportParameter that holds the parameters
for your report. Then call
ReportViewer1.ServerReport.SetParameters(paramArray). Hope this helps.
Devin
Elmo Watson wrote:
> Using Reporting Services in VS.Net 2005 (very much a newbie, though not a
> newbie to ASP.Net)
> I have a report which runs a Stored Procedure, requiring a parameter -
> BudgetID -
> In this particular case I just created an ASP.Net page (content page), and I
> add a reportViewer control - the wizard picks up my report and creates an
> ObjectDataSource, and assigns the report, but nothing is done or asked about
> the BudgetID -
> I found a reference on the web (in 2004) which showed that I could do
> something like this in code:
> ReportViewer1.SetQueryParameter("ProductCategory",CategoryDropDown.SelectedV
> alue);
> So I thought I could do something like this in the page load event - but it
> doesn't like the SetqueryParameter method - and searching through all the
> properties and methods, I can't seem to find anything like this.
> Could someone please shed some light on this for me, please?|||Please excuse my newbie-ness, but can you explain how to do that?
I've created Arrays from strings before, but I've tried several things, and
it's just not working
"Devin" <dlosee@.granitelp.com> wrote in message
news:1161276979.601948.215490@.i3g2000cwc.googlegroups.com...
> You need to create an array of
> Microsoft.Reporting.WebForms.ReportParameter that holds the parameters
> for your report. Then call
> ReportViewer1.ServerReport.SetParameters(paramArray). Hope this helps.
> Devin
> Elmo Watson wrote:
> > Using Reporting Services in VS.Net 2005 (very much a newbie, though not
a
> > newbie to ASP.Net)
> > I have a report which runs a Stored Procedure, requiring a parameter -
> > BudgetID -
> >
> > In this particular case I just created an ASP.Net page (content page),
and I
> > add a reportViewer control - the wizard picks up my report and creates
an
> > ObjectDataSource, and assigns the report, but nothing is done or asked
about
> > the BudgetID -
> > I found a reference on the web (in 2004) which showed that I could do
> > something like this in code:
> >
ReportViewer1.SetQueryParameter("ProductCategory",CategoryDropDown.SelectedV
> > alue);
> >
> > So I thought I could do something like this in the page load event - but
it
> > doesn't like the SetqueryParameter method - and searching through all
the
> > properties and methods, I can't seem to find anything like this.
> >
> > Could someone please shed some light on this for me, please?
>|||No problem. Basically it's the same as other arrays. Here's what I
have:
Here are the properties for the report viewer control (these can be
changed based on preferences, but here's what I have):
<rsweb:ReportViewer
ID="ReportViewer1"
runat="server"
Height="100%"
Width="100%"
ProcessingMode="Remote"
ShowBackButton="False"
ShowDocumentMapButton="False"
ShowParameterPrompts="False"
ShowPromptAreaButton="False"
BorderColor="Black"
BorderWidth="1px" >
<ServerReport ReportServerUrl="http://SERVER_NAME/ReportServer" />
</rsweb:ReportViewer>
Here is the code for either the OnLoad of the report viewer page or the
OnClick (if you have the params and report viewer on the same form) of
the button for viewing the report:
Dim params As Microsoft.Reporting.WebForms.ReportParameter()
ReDim params(1)
params(0) = New Microsoft.Reporting.WebForms.ReportParameter(
PARAM_1_NAME, PARAM_1_VALUE)
params(1) = New Microsoft.Reporting.WebForms.ReportParameter(
PARAM_2_NAME, PARAM_2_VALUE)
With ReportViewer1.ServerReport
.ReportPath = "/REPORT_FOLDER/REPORT_NAME"
.SetParameters(params)
.Refresh()
End With
There are problems when your report server and website the report
viewer control is on are on 2 separate servers. There's something with
a double hop. I haven't looked too much into this as mine are both on
the same server. If yours are on 2 different servers, you may want to
google the double hop problem (if you are getting security errors).
If you want to get really fancy, you can use inheritance for all of
your parameter forms and then have 1 report viewer form. If that is a
direction you want to take, let me know and I'll post how I did it
(there are many ways, inheritance is just the way I chose).
Elmo Watson wrote:
> Please excuse my newbie-ness, but can you explain how to do that?
> I've created Arrays from strings before, but I've tried several things, and
> it's just not working
>
> "Devin" <dlosee@.granitelp.com> wrote in message
> news:1161276979.601948.215490@.i3g2000cwc.googlegroups.com...
> > You need to create an array of
> > Microsoft.Reporting.WebForms.ReportParameter that holds the parameters
> > for your report. Then call
> > ReportViewer1.ServerReport.SetParameters(paramArray). Hope this helps.
> >
> > Devin
> >
> > Elmo Watson wrote:
> > > Using Reporting Services in VS.Net 2005 (very much a newbie, though not
> a
> > > newbie to ASP.Net)
> > > I have a report which runs a Stored Procedure, requiring a parameter -
> > > BudgetID -
> > >
> > > In this particular case I just created an ASP.Net page (content page),
> and I
> > > add a reportViewer control - the wizard picks up my report and creates
> an
> > > ObjectDataSource, and assigns the report, but nothing is done or asked
> about
> > > the BudgetID -
> > > I found a reference on the web (in 2004) which showed that I could do
> > > something like this in code:
> > >
> ReportViewer1.SetQueryParameter("ProductCategory",CategoryDropDown.SelectedV
> > > alue);
> > >
> > > So I thought I could do something like this in the page load event - but
> it
> > > doesn't like the SetqueryParameter method - and searching through all
> the
> > > properties and methods, I can't seem to find anything like this.
> > >
> > > Could someone please shed some light on this for me, please?
> >

Wednesday, March 21, 2012

Reports Timeout when MSRS 2005 Applicaiton Pool is restarted

Greetings,

Has anyone else had a problem with MSRS 2005 after restarting the application pool where it takes about 2 minutes to load the main Reports Home page? This is not a problem for the most part, but since the application pool for Reports recycles regulary by default this can be a major problem.

I have searched for, but have not located any documentation that states how the Applicaiton Pool configuration and be modified with regard to MSRS. Additionally the Reporting Services Configuration Manager does not appear to modify options specific to the Applicaiton Pool. I want to know what I can set the Application Pool properties to.

Anyone?

You can modify the application pool properties using IIS manager.|||

Yes, I understand that I can do that.

The problem is that there are not Microsoft recommendations for the ideal application pool configuration. At least, not one that I can find.

Tuesday, March 20, 2012

Reports on medium trust host?

Hi, I am building a reporting tool for students and now I got ReportViewer to work greate, local on my PC. But when I load the app. to the server it dont work, and I understand that it is becuse my host only run "Medium trust".

Is there a way to make it work dispite the medium trust issue?

Or is there some other tool that work wiht my medium trust host?

Or am I doing something else wrong and the medium trust is no problem?

I talked to the support and they never heard of any customer having problems wiht reports... I use one of the biggest hosts in Sweden (loopia).

I use vwd 2005 express, vb, accessdatabase, MS ReportViewer. And what I want is to present how many hours each person spent on a few given tasks each week and sum it up and maybe get some % and in the end hopefully a chart, the chart is not nessecerly.

My error:

Parser Error Message:Could not load file or assembly 'Microsoft.ReportViewer.WebForms, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified.

please help

sinserly

chris


Hi,

From the error message you provided, it seems that the cause of the problem is that the system can't load the assembly which needed for your application.

So what I suggest is to check if the assembly "Microsoft.ReportViewer.WebForms.dll" has existed on the server and if it can be found in your /bin subfolder.

Thanks.

|||

Ok thanks, that is ok now. But now I get a worse one, is there a way around it?

Server Error in '/' Application.

Required permissions cannot be acquired.

Description:An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details:System.Security.Policy.PolicyException: Required permissions cannot be acquired.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.


Stack Trace:

[PolicyException: Required permissions cannot be acquired.]
System.Security.SecurityManager.ResolvePolicy(Evidence evidence, PermissionSet reqdPset, PermissionSet optPset, PermissionSet denyPset, PermissionSet& denied, Boolean checkExecutionPermission) +2709488
System.Security.SecurityManager.ResolvePolicy(Evidence evidence, PermissionSet reqdPset, PermissionSet optPset, PermissionSet denyPset, PermissionSet& denied, Int32& securitySpecialFlags, Boolean checkExecutionPermission) +57

[FileLoadException: Could not load file or assembly 'Microsoft.ReportViewer.Common, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. Failed to grant minimum permission requests. (Exception from HRESULT: 0x80131417)]
System.Reflection.Assembly.nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, Assembly locationHint, StackCrawlMark& stackMark, Boolean throwOnFileNotFound, Boolean forIntrospection) +0
System.Reflection.Assembly.InternalLoad(AssemblyName assemblyRef, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection) +211
System.Reflection.Assembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection) +141
System.Reflection.Assembly.Load(String assemblyString) +25
System.Web.Configuration.CompilationSection.LoadAssemblyHelper(String assemblyName, Boolean starDirective) +32

[ConfigurationErrorsException: Could not load file or assembly 'Microsoft.ReportViewer.Common, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. Failed to grant minimum permission requests. (Exception from HRESULT: 0x80131417)]
System.Web.Configuration.CompilationSection.LoadAssemblyHelper(String assemblyName, Boolean starDirective) +596
System.Web.Configuration.CompilationSection.LoadAllAssembliesFromAppDomainBinDirectory() +3596761
System.Web.Configuration.CompilationSection.LoadAssembly(AssemblyInfo ai) +46
System.Web.Compilation.BuildManager.GetReferencedAssemblies(CompilationSection compConfig) +177
System.Web.Compilation.BuildProvidersCompiler..ctor(VirtualPath configPath, Boolean supportLocalization, String outputAssemblyName) +180
System.Web.Compilation.CodeDirectoryCompiler.GetCodeDirectoryAssembly(VirtualPath virtualDir, CodeDirectoryType dirType, String assemblyName, StringSet excludedSubdirectories, Boolean isDirectoryAllowed) +350
System.Web.Compilation.BuildManager.CompileCodeDirectory(VirtualPath virtualDir, CodeDirectoryType dirType, String assemblyName, StringSet excludedSubdirectories) +125
System.Web.Compilation.BuildManager.CompileCodeDirectories() +525
System.Web.Compilation.BuildManager.EnsureTopLevelFilesCompiled() +448

[HttpException (0x80004005): Could not load file or assembly 'Microsoft.ReportViewer.Common, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. Failed to grant minimum permission requests. (Exception from HRESULT: 0x80131417)]
System.Web.Compilation.BuildManager.ReportTopLevelCompilationException() +57
System.Web.Compilation.BuildManager.EnsureTopLevelFilesCompiled() +612
System.Web.Hosting.HostingEnvironment.Initialize(ApplicationManager appManager, IApplicationHost appHost, IConfigMapPathFactory configMapPathFactory, HostingEnvironmentParameters hostingParameters) +521

[HttpException (0x80004005): Could not load file or assembly 'Microsoft.ReportViewer.Common, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. Failed to grant minimum permission requests. (Exception from HRESULT: 0x80131417)]
System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +3540923
System.Web.HttpRuntime.EnsureFirstRequestInit(HttpContext context) +69
System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) +275



Version Information: Microsoft .NET Framework Version:2.0.50727.832; ASP.NET Version:2.0.50727.832

Friday, March 9, 2012

Reportmanager failed to load from internet as a webapplication

I works fine when I run from our lan by a IIS virtual directory. But using
reportmanager from a IIS application outside the lan as a true
webapplication, the reportmanager produce wrong paths for controls. E.x.
http://images/48folderopen.jpg There should have been a domain in front of
/images. I haven't been able to find any parameters in config's to meet this
problem.
Regards
Henrik Juel
GBS A/S
DenmarkI have same probleme, anybody have the solution'
"Henrik Juel" <hjh@.gbs.dk> a écrit dans le message de
news:clsmdo$2bti$1@.news.cybercity.dk...
> I works fine when I run from our lan by a IIS virtual directory. But using
> reportmanager from a IIS application outside the lan as a true
> webapplication, the reportmanager produce wrong paths for controls. E.x.
> http://images/48folderopen.jpg There should have been a domain in front of
> /images. I haven't been able to find any parameters in config's to meet
this
> problem.
> Regards
> Henrik Juel
> GBS A/S
> Denmark
>|||Have you added the <ReportServerExternalURL> tag to the
c:\programfiles\microsoft sql server\mssql\reporting services\report anager\
rswebapplication.config file as below?
<Configuration>
<UI>
<ReportServerUrl>http://servername/ReportServer</ReportServerUrl>
<ReportServerExternalURL>http://www.domain.org/ReportServer</ReportServerExt
ernalURL>
</UI>
Ken
"Henrik Juel" <hjh@.gbs.dk> wrote in message
news:clsmdo$2bti$1@.news.cybercity.dk...
> I works fine when I run from our lan by a IIS virtual directory. But using
> reportmanager from a IIS application outside the lan as a true
> webapplication, the reportmanager produce wrong paths for controls. E.x.
> http://images/48folderopen.jpg There should have been a domain in front of
> /images. I haven't been able to find any parameters in config's to meet
this
> problem.
> Regards
> Henrik Juel
> GBS A/S
> Denmark
>|||Hello Ken
After reading others posting about this topic, I have tried the tag
<ReportServerExternalURL>. But it made no difference. I belive in this setup
there is a ok connection from the reportmanager to the reportserver.
"Ken" wrote:
> Have you added the <ReportServerExternalURL> tag to the
> c:\programfiles\microsoft sql server\mssql\reporting services\report anager\
> rswebapplication.config file as below?
> <Configuration>
> <UI>
> <ReportServerUrl>http://servername/ReportServer</ReportServerUrl>
> <ReportServerExternalURL>http://www.domain.org/ReportServer</ReportServerExt
> ernalURL>
> </UI>
> Ken
> "Henrik Juel" <hjh@.gbs.dk> wrote in message
> news:clsmdo$2bti$1@.news.cybercity.dk...
> > I works fine when I run from our lan by a IIS virtual directory. But using
> > reportmanager from a IIS application outside the lan as a true
> > webapplication, the reportmanager produce wrong paths for controls. E.x.
> > http://images/48folderopen.jpg There should have been a domain in front of
> > /images. I haven't been able to find any parameters in config's to meet
> this
> > problem.
> >
> > Regards
> >
> > Henrik Juel
> > GBS A/S
> > Denmark
> >
> >
>
>

Reportmanager failed to load from internet as a webapplication

I works fine when I run from our lan by a IIS virtual directory. But using
reportmanager from a IIS application outside the lan as a true
webapplication, the reportmanager produce wrong paths for controls. E.x.
http://images/48folderopen.jpg There should have been a domain in front of
/images. I haven't been able to find any parameters in config's to meet this
problem.
Regards
Henrik Juel
GBS A/S
DenmarkHi Henrik,
Thanks for your post.
From your descriptions, I understood that you could not access your Report
Manager via Internet while it's OK for intrannet. Have I understood you?
Correct me if i was wrong.
Based on my scope, it seems you should modify your <ReportServerUrl> Tag
for the remote access. Go look at the Report Manager configuration
file,RSWebApplication.config. There is a UI section
<UI>
<ReportServerUrl>http://intranet-computer-name/ReportServer</ReportServerUrl
>
</UI>
Change it to
<UI>
<ReportServerVirtualDirectory>/ReportServer</ReportServerVirtualDirectory>
</UI>
or you could find another way in charpter "Deploying a Report Server for
Internet Access" under Topic "Enterprise Deployment Model" in Reporting
Services Books Online.
Last but not the least, make sure you follow the security practices before
you opening the Internet Access:)
Hope this helps and if you have any questions or concerns, don't hesitate
to let me know. We are always here to be of assistance!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||Hello Michael
Thanks for your instant answer. And yes you do understand me.
I haved tried the <ReportServerVirtualDirectory> tag in the
RSWebApplication.config file but it didn't made any difference to this
problem. I have read the chapter in the online book as I have read about
this topic in my Wrox book. I was not able to find this issue.
When starting the reportmanager from http://rs.gbs.dk the reportmanager
application do have connection to the reportserver, as it is able to show
folders, but fail to work with fully urls. E.x. the image problem stated
earlier.
""Michael Cheng [MSFT]"" wrote:
> Hi Henrik,
> Thanks for your post.
> From your descriptions, I understood that you could not access your Report
> Manager via Internet while it's OK for intrannet. Have I understood you?
> Correct me if i was wrong.
> Based on my scope, it seems you should modify your <ReportServerUrl> Tag
> for the remote access. Go look at the Report Manager configuration
> file,RSWebApplication.config. There is a UI section
> <UI>
> <ReportServerUrl>http://intranet-computer-name/ReportServer</ReportServerUrl
> >
> </UI>
> Change it to
> <UI>
> <ReportServerVirtualDirectory>/ReportServer</ReportServerVirtualDirectory>
> </UI>
> or you could find another way in charpter "Deploying a Report Server for
> Internet Access" under Topic "Enterprise Deployment Model" in Reporting
> Services Books Online.
> Last but not the least, make sure you follow the security practices before
> you opening the Internet Access:)
> Hope this helps and if you have any questions or concerns, don't hesitate
> to let me know. We are always here to be of assistance!
>
> Sincerely yours,
> Michael Cheng
> Online Partner Support Specialist
> Partner Support Group
> Microsoft Global Technical Support Center
> ---
> Get Secure! - http://www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>
>
>|||Hi Henrik,
If the Report Manager and Report Server are on the same machine then remove
the <ReportServerExternalUrl> and the <ReportServerUrl> from the <UI> node
in the config file - and replace with <ReportServerVirtualDirectory>
Let me know whether this works
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||Hello Michael
Both applications are on the same machine.
And I have only the <ReportServerVirtualDirectory> tag in the
rswebapplication.config.
<UI>
<ReportServerVirtualDirectory>/ReportServer</ReportServerVirtualDirectory>
</UI>
I have created a virtual directory in the reportmanager root, which point to
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer
where the server originally is installed.
So I belive It doesn't work.
""Michael Cheng [MSFT]"" wrote:
> Hi Henrik,
> If the Report Manager and Report Server are on the same machine then remove
> the <ReportServerExternalUrl> and the <ReportServerUrl> from the <UI> node
> in the config file - and replace with <ReportServerVirtualDirectory>
> Let me know whether this works
> Sincerely yours,
> Michael Cheng
> Online Partner Support Specialist
> Partner Support Group
> Microsoft Global Technical Support Center
> ---
> Get Secure! - http://www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>
>
>
>
>
>|||Hi Henrik,
First of all, I need to confirm that how do get the following link. Is it
in report manager when he right click a image->Properties to see the link
of the image? http://images/48folderopen.jpg
Secondly, please make sure that 'images' are in the IIS manager the image
folder:
1). Expand IIS server->Web sites->Default Website->Reports->Images
2). Right click Images->Properties->Directory and check if "The designated
directory" is used and "reports\images" is listed.
Thank you for your patience and corporation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||Hello Michael
1. Yes I have the http://images/48folderopen.jpg from right clicking a image
in reportmanager.
2. The IIS settings are as you describe
You are welcome to contact me on +45 20282851 or on email : hjh@.gbs.dk for a
login to http://rs.gbs.dk
""Michael Cheng [MSFT]"" wrote:
> Hi Henrik,
> First of all, I need to confirm that how do get the following link. Is it
> in report manager when he right click a image->Properties to see the link
> of the image? http://images/48folderopen.jpg
> Secondly, please make sure that 'images' are in the IIS manager the image
> folder:
> 1). Expand IIS server->Web sites->Default Website->Reports->Images
> 2). Right click Images->Properties->Directory and check if "The designated
> directory" is used and "reports\images" is listed.
> Thank you for your patience and corporation. If you have any questions or
> concerns, don't hesitate to let me know. We are always here to be of
> assistance!
>
> Sincerely yours,
> Michael Cheng
> Online Partner Support Specialist
> Partner Support Group
> Microsoft Global Technical Support Center
> ---
> Get Secure! - http://www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>|||Hi Henrik,
Looking at the nature of this issue, I am afraid we need more time
researching on this issue and this issue was critical to your business, I
would like to suggest you open an incidnet call with Microsoft Support
Professional through Microsoft Product Support Services. You can contact
Microsoft Product Support directly to discuss additional support options
you may have available, by contacting us at 1-(800)936-5800 or by choosing
one of the options listed at
http://support.microsoft.com/directory/overview.asp
If you'd still like to continue working via the newsgroup, I want to set
your expectations that the issue might take a long time to narrow down.
During the course of troubleshooting, we may redirect you to PSS if
required.
For now, I doubt it might be a IIS issue instead of Reporting Services one
and please let me know the answers for the following questions
1. If you are browsing the Report Manager *Locally* via domain name
(http://rs.gbs.dk), will it shows as expected?
If you are browsing via domain name within the intrannet, will it shows as
expected?
2. Open the Web site property,
Click Advanced Button in Web site identification of Web Site Tab
Select Default in Multiple identities for the Web site, Click Edit...
Let me know whether there is anything in the Host Header value
3. Is it possible for you to post IIS logs here? You could also send it to
me if you think it was critical for your business. My email address was
v-mingqc@.online.microsoft.com (please remove "online", it's only for SPAM,
thanks:-)
Thank you for your patience and corporation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||Hi Henrik,
I am currently standing by for an update from you and would like to know
how things are going there. Should you have any questions or concerns on
the recent questions/ information I've posted, please don't hesitate to let
me know directly. It's my pleasure to be of assistance
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||I have sent my reponse on your emailaddres v-mingqc@.online.microsoft.com
"removed online" for some weeks ago. Looking forward to your answer.
regards Henrik
""Michael Cheng [MSFT]"" wrote:
> Hi Henrik,
> I am currently standing by for an update from you and would like to know
> how things are going there. Should you have any questions or concerns on
> the recent questions/ information I've posted, please don't hesitate to let
> me know directly. It's my pleasure to be of assistance
>
> Sincerely yours,
> Michael Cheng
> Online Partner Support Specialist
> Partner Support Group
> Microsoft Global Technical Support Center
> ---
> Get Secure! - http://www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>|||Hi Henrik,
I am sorry that I have never received email from you :-(
May I ask your favor to resend the email?
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!

Monday, February 20, 2012

Reporting Services: Report Manager does not load (server error)

Hello Everyone,

I have installed SQL Server 2005 with Reporting Services on Windows Server 2003. I can run through reporting services configuration and completed all the required steps to initialize it. I can access the reports through //localhost/reportserver and I can also access the reports through Microsoft CRM. But I cannot access the Report Manager (//localhost/reports). I get this Error:

Server Error in '/Reports' Application.

Could not load file or assembly 'ReportingServicesWebServer' or one of its dependencies. The system cannot find the file specified.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.IO.FileNotFoundException: Could not load file or assembly 'ReportingServicesWebServer' or one of its dependencies. The system cannot find the file specified.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.


Assembly Load Trace: The following information can be helpful to determine why the assembly 'ReportingServicesWebServer' could not be loaded.

WRN: Assembly binding logging is turned OFF. To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1. Note: There is some performance penalty associated with assembly bind failure logging. To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].


Stack Trace:

[FileNotFoundException: Could not load file or assembly 'ReportingServicesWebServer' or one of its dependencies. The system cannot find the file specified.] System.Reflection.Assembly.nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, Assembly locationHint, StackCrawlMark& stackMark, Boolean throwOnFileNotFound, Boolean forIntrospection) +0 System.Reflection.Assembly.InternalLoad(AssemblyName assemblyRef, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection) +211 System.Reflection.Assembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection) +141 System.Reflection.Assembly.Load(String assemblyString) +25 System.Web.Configuration.CompilationSection.LoadAssemblyHelper(String assemblyName, Boolean starDirective) +32 [ConfigurationErrorsException: Could not load file or assembly 'ReportingServicesWebServer' or one of its dependencies. The system cannot find the file specified.] System.Web.Configuration.CompilationSection.LoadAssemblyHelper(String assemblyName, Boolean starDirective) +596 System.Web.Configuration.CompilationSection.LoadAssembly(AssemblyInfo ai) +70 System.Web.Compilation.BuildManager.GetReferencedAssemblies(CompilationSection compConfig) +177 System.Web.Compilation.BuildProvidersCompiler..ctor(VirtualPath configPath, Boolean supportLocalization, String outputAssemblyName) +180 System.Web.Compilation.ApplicationBuildProvider.GetGlobalAsaxBuildResult(Boolean isPrecompiledApp) +3561465 System.Web.Compilation.BuildManager.CompileGlobalAsax() +51 System.Web.Compilation.BuildManager.EnsureTopLevelFilesCompiled() +462 [HttpException (0x80004005): Could not load file or assembly 'ReportingServicesWebServer' or one of its dependencies. The system cannot find the file specified.] System.Web.Compilation.BuildManager.ReportTopLevelCompilationException() +57 System.Web.Compilation.BuildManager.EnsureTopLevelFilesCompiled() +612 System.Web.Hosting.HostingEnvironment.Initialize(ApplicationManager appManager, IApplicationHost appHost, IConfigMapPathFactory configMapPathFactory, HostingEnvironmentParameters hostingParameters) +521 [HttpException (0x80004005): Could not load file or assembly 'ReportingServicesWebServer' or one of its dependencies. The system cannot find the file specified.] System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +3540923 System.Web.HttpRuntime.EnsureFirstRequestInit(HttpContext context) +69 System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) +275


Version Information: Microsoft .NET Framework Version:2.0.50727.832; ASP.NET Version:2.0.50727.832

Any ideas? I have done some searching, but could not find any viable solutions. Please Help Smile

Regards,

Ray

It sounds like this is a fairly complex problem:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1259637&SiteID=1

Have you tried reinstalling report manager?

Reporting Services with Visual Studio

Do I need to load Visual Studio 2005 or Visual Studio 2005.NET to work with the .rdl reports. I have VS 2005 loaded and I can't access my reports I created before my hard drive died...

Intall the SQL Server 2005 Business Intelligent Development studio. With this you will be able to access the reports

Raj

|||Is that software on the SQL Server 2005 Development cd's?|||

It is under Client Components on the Advanced screen of the regular SQL 2005 installation. It does not require Visual Studio to be installed. The BI component for SRS 2000 had that dependency, but they built the 2005 installer to install the required framework. As an aside, VS 2008 (Orcas) will allow individual developers to build applications based on the VS Shell and deploy them without royalties (http://msdn2.microsoft.com/en-us/vstudio/bb510103.aspx).

Larry