Friday, March 30, 2012
ReportViewer graphics and charts do not display in aspx page
I'm trying to display a basic report in an aspx page using the ReportViewer
component. The report displays but a graphic and simple chart are not
displayed. It seems like it has had good try because link regions in the
graph do actually work, but no visual chart.
Any ideas!Update on below
As I said it seems to be giving the display a good go, and I have managed to
intermitently display the chart graphic (I think by viewing the report in
report manager first), but refresh the page and it disapears again. Follow a
link from the report and then use the back button and it displays again. IE
pants or what!
Only hint is that when the chart is not display the properties say Type: Not
Available, when it is displayed it says Type: PNG Image. I have seen the
.gif displayed once, but don't seem to be able to do it again - same
properties - Type: Not Available.
Seems to be some info about on this type of issue, that is - controls,
security and encoding but nothing definitive.
Any assistance greatly appreciated
Thanks
Laurence
"Laurence" <laurence.pull@.silversands.co.uk> wrote in message
news:OmHV2yb4EHA.3236@.TK2MSFTNGP15.phx.gbl...
> Hi,
> I'm trying to display a basic report in an aspx page using the
> ReportViewer component. The report displays but a graphic and simple chart
> are not displayed. It seems like it has had good try because link regions
> in the graph do actually work, but no visual chart.
> Any ideas!
>|||I am also having the same issue... If I restart IIS( iisreset ) the images
would start diplaying but would disappear after couple of minutes(in most
cases the third refresh would kill the images)
--Sarvan
"Laurence" wrote:
> Update on below
> As I said it seems to be giving the display a good go, and I have managed to
> intermitently display the chart graphic (I think by viewing the report in
> report manager first), but refresh the page and it disapears again. Follow a
> link from the report and then use the back button and it displays again. IE
> pants or what!
> Only hint is that when the chart is not display the properties say Type: Not
> Available, when it is displayed it says Type: PNG Image. I have seen the
> ..gif displayed once, but don't seem to be able to do it again - same
> properties - Type: Not Available.
> Seems to be some info about on this type of issue, that is - controls,
> security and encoding but nothing definitive.
> Any assistance greatly appreciated
> Thanks
> Laurence
> "Laurence" <laurence.pull@.silversands.co.uk> wrote in message
> news:OmHV2yb4EHA.3236@.TK2MSFTNGP15.phx.gbl...
> > Hi,
> >
> > I'm trying to display a basic report in an aspx page using the
> > ReportViewer component. The report displays but a graphic and simple chart
> > are not displayed. It seems like it has had good try because link regions
> > in the graph do actually work, but no visual chart.
> >
> > Any ideas!
> >
>
>
ReportViewer error "Page navigation is out of range"
The application has session state turned off.
The problem occurs whether or not the viewstate for ReportViewer is turned on or off.
How can I fix this problem?I have exactly the same problem...anyone out there from MS monitoring this? Please help! Thanks!|||
I also had the same problem.
Can you try setting you internet-intranet security settings to Medium-Low and then try generating the reports? There seems to be some problem with storing of cookies because of which it gives this error.
Hope it helps!!!
|||Page navigation is a postback. Look at what you are doing in the PageLoad when IsPostBack == true.|||Hi BradB,
what are the things that can cause such error in the pageload if it's a postback?
i encountered this error but my coding uses !IsPostBack , will that be a difference?
|||I figured out a workaround. It appears that the error occurs when you set the ServerPage during the postback. Don't explicitly set the ReportServerUrl or ReportPath during postback and it should work:
/* Insert the following two lines before setting ReportServerUrl or ReportPath */
if (IsPostBack)
return;
Report.ServerReport.ReportServerUrl = new Uri(@."http://localhost/ReportServer");
Report.ServerReport.ReportPath = @."/MyReportDirectory/MyReport";
Perfect.
You made my day.
Thanx.
ReportViewer error "Page navigation is out of range"
The application has session state turned off.
The problem occurs whether or not the viewstate for ReportViewer is turned on or off.
How can I fix this problem?I have exactly the same problem...anyone out there from MS monitoring this? Please help! Thanks!|||
I also had the same problem.
Can you try setting you internet-intranet security settings to Medium-Low and then try generating the reports? There seems to be some problem with storing of cookies because of which it gives this error.
Hope it helps!!!
|||Page navigation is a postback. Look at what you are doing in the PageLoad when IsPostBack == true.|||Hi BradB,
what are the things that can cause such error in the pageload if it's a postback?
i encountered this error but my coding uses !IsPostBack , will that be a difference?
|||I figured out a workaround. It appears that the error occurs when you set the ServerPage during the postback. Don't explicitly set the ReportServerUrl or ReportPath during postback and it should work:
/* Insert the following two lines before setting ReportServerUrl or ReportPath */
if (IsPostBack)
return;
Report.ServerReport.ReportServerUrl = new Uri(@."http://localhost/ReportServer");
Report.ServerReport.ReportPath = @."/MyReportDirectory/MyReport";
Perfect.
You made my day.
Thanx.
ReportViewer error "Page navigation is out of range"
The application has session state turned off.
The problem occurs whether or not the viewstate for ReportViewer is turned on or off.
How can I fix this problem?I have exactly the same problem...anyone out there from MS monitoring this? Please help! Thanks!|||
I also had the same problem.
Can you try setting you internet-intranet security settings to Medium-Low and then try generating the reports? There seems to be some problem with storing of cookies because of which it gives this error.
Hope it helps!!!
|||Page navigation is a postback. Look at what you are doing in the PageLoad when IsPostBack == true.|||Hi BradB,
what are the things that can cause such error in the pageload if it's a postback?
i encountered this error but my coding uses !IsPostBack , will that be a difference?
|||I figured out a workaround. It appears that the error occurs when you set the ServerPage during the postback. Don't explicitly set the ReportServerUrl or ReportPath during postback and it should work:
/* Insert the following two lines before setting ReportServerUrl or ReportPath */
if (IsPostBack)
return;
Report.ServerReport.ReportServerUrl = new Uri(@."http://localhost/ReportServer");
Report.ServerReport.ReportPath = @."/MyReportDirectory/MyReport";
Perfect.
You made my day.
Thanx.
ReportViewer error "Page navigation is out of range"
The application has session state turned off.
The problem occurs whether or not the viewstate for ReportViewer is turned on or off.
How can I fix this problem?I have exactly the same problem...anyone out there from MS monitoring this? Please help! Thanks!|||
I also had the same problem.
Can you try setting you internet-intranet security settings to Medium-Low and then try generating the reports? There seems to be some problem with storing of cookies because of which it gives this error.
Hope it helps!!!
|||Page navigation is a postback. Look at what you are doing in the PageLoad when IsPostBack == true.|||Hi BradB,
what are the things that can cause such error in the pageload if it's a postback?
i encountered this error but my coding uses !IsPostBack , will that be a difference?
|||I figured out a workaround. It appears that the error occurs when you set the ServerPage during the postback. Don't explicitly set the ReportServerUrl or ReportPath during postback and it should work:
/* Insert the following two lines before setting ReportServerUrl or ReportPath */
if (IsPostBack)
return;
Report.ServerReport.ReportServerUrl = new Uri(@."http://localhost/ReportServer");
Report.ServerReport.ReportPath = @."/MyReportDirectory/MyReport";
Perfect.
You made my day.
Thanx.
ReportViewer error "Page navigation is out of range"
The application has session state turned off.
The problem occurs whether or not the viewstate for ReportViewer is turned on or off.
How can I fix this problem?
I have exactly the same problem...anyone out there from MS monitoring this? Please help! Thanks!|||
I also had the same problem.
Can you try setting you internet-intranet security settings to Medium-Low and then try generating the reports? There seems to be some problem with storing of cookies because of which it gives this error.
Hope it helps!!!
|||Page navigation is a postback. Look at what you are doing in the PageLoad when IsPostBack == true.|||Hi BradB,
what are the things that can cause such error in the pageload if it's a postback?
i encountered this error but my coding uses !IsPostBack , will that be a difference?
|||I figured out a workaround. It appears that the error occurs when you set the ServerPage during the postback. Don't explicitly set the ReportServerUrl or ReportPath during postback and it should work:
/* Insert the following two lines before setting ReportServerUrl or ReportPath */
if (IsPostBack)
return;
Report.ServerReport.ReportServerUrl = new Uri(@."http://localhost/ReportServer");
Report.ServerReport.ReportPath = @."/MyReportDirectory/MyReport";
|||
Perfect.
You made my day.
Thanx.
ReportViewer does not show report in aspx page
I created a report with a parameter. The parameter was created using a dataset in the report designer. This works fine. I deployed the report (webhost4life) and the report runs fine in the report manager. I am able to select my casenumber click on the default view report button and it works.
Problem: I embedd the report into an aspx page frmReports1.aspx. I call this page from another page (form). the frmReports.aspx page comes up and displays the default drop down list box with the casenumbers (fine). I select the casenumber and click on the view report button and NOTHING. I here the postbacks taking place but all that happens is the default value appears in the drop down list box and the toolbar shows. I checked permissions and everything is fine. I searched the forum and thought i found the solution with the inLine HTML and Async (still nothing) I can only think that something is not going right with the parameter. Here is my html, and code behind code. any help would be greatly apprcieated.
Zachary
<%@. Page Language="VB" AutoEventWireup="false" CodeFile="frmReports1.aspx.vb" Inherits="frmReports1" %>
<%@. Register Assembly="Microsoft.ReportViewer.WebForms, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"
Namespace="Microsoft.Reporting.WebForms" TagPrefix="rsweb" %>
<%@. Register Assembly="Microsoft.ReportViewer.WebForms, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"
Namespace="Microsoft.Reporting.WebForms" TagPrefix="rsweb" %>
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Untitled Page</title>
<style>html,body,form {height:100%}</style>
</head>
<body>
<form id="form1" runat="server">
<div>
<rsweb:ReportViewer ID="rvTest" runat="server" Width="600px" ProcessingMode="Remote" AsyncRendering="false" Height="75%" >
<ServerReport
DisplayName="Billable Hours"
ReportPath="/sddmtech/SnowandIce/rptHoursWorked"
ReportServerUrl="http://sqlreport01.mysite4now.com/Reportserver" />
</rsweb:ReportViewer>
</div>
</form>
</body>
</html>
aspx code behind
Imports System.Net
Imports System.Security.Principal
Imports Microsoft.Reporting.WebForms
Partial Class frmReports1
Inherits System.Web.UI.Page
Protected Sub rvTest_Init(ByVal sender As Object, ByVal e As System.EventArgs) Handles rvTest.Init
End Sub
<Serializable()> _
Public NotInheritable Class MyReportServerCredentials
Implements IReportServerCredentials
Public ReadOnly Property ImpersonationUser() As WindowsIdentity _
Implements IReportServerCredentials.ImpersonationUser
Get
Return Nothing
End Get
End Property
Public ReadOnly Property NetworkCredentials() As ICredentials _
Implements IReportServerCredentials.NetworkCredentials
Get
' Put your login and password here this works fine
Dim userName As String = ""
Dim password As String = ""
Dim domain As String = ""
Return New 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
End Function
End Class
Public Function GetFormsCredentials(ByRef authCookie As Cookie, _
ByRef userName As String, _
ByRef password As String, _
ByRef authority As String) _
As Boolean
authCookie = Nothing
userName = Nothing
password = Nothing
authority = Nothing
'Not using form credentials
Return False
End Function
Protected Sub form1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles form1.Load
'ReportViewer1.ServerReport.ReportServerCredentials = New MyReportServerCredentials()
'rvTest.ServerReport.Refresh()
End Sub
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
rvTest.ServerReport.ReportServerCredentials = New MyReportServerCredentials()
End Sub
End Class
Try taking out the http://www.w3.org/1999/xhtml namespace value and see if it works. It may have nothing to do with it, but there are some um infelicities with the rendered HTML for report viewer that make the Standards Police very unhappy...
It's just a guess but it is a guess that will take you 3 seconds to check <s>.
I don't think it's your credentials -- otherwise why would the parameters etc show up? You're getting to the site...
>L<
|||Thanks Lisa
I took the www.w3.org statement out but it did not work. Still the same.
Zachary
|||Hi Lisa
It is a problem with the parameter. I created a stored procedure with the same data however; it does not contain a parmeter. i.e. it pulls back all of the data (it works).
In report designer I created two datasets. One dataset holds all the possible values that can be passed to the stored procedure
Select CaseNumber from tblCases
These values are put into a drop down list box in the toolbar (it is done automatically for me).
The second dataset uses this value once it is selected and retrieves the data that is to be displayed in the report. (This is the disconnect. ) Does anyone know how to do this. I do not want to create a custom control in the toolbar. I want to extract the parameter value that already exists in the existing toolbar and then pass that value to the stored procedure / report.
Is there an example or does anyone have an example of passing the parameter value using the Report Viewer and a stored procedure.
thanks
Zachary
|||>.Is there an example or does anyone have an example of passing the parameter value using the Report Viewer and a stored procedure.
<
Yep <g>.
http://forums.microsoft.com/msdn/showpost.aspx?postid=1705421&siteid=1&sb=0&d=1&at=7&ft=11&tf=0&pageid=1
>L<
|||Thanks Lisa
Fixed the problem - In Problem I was reloading the report on postback therefore cancelling out the paramter. So I did a check for post back (i.e if page.ispostback = false then ) and everything is working.
This is a greate forum.
Zachary
Fixed the problem - thanks
Zachary
|||Cool! Thanks for explaining.
>L<
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 does not display number of records per page properly??
I am using a reportviewer control to display locally generated reports. I use a parameter to set the number of records per page in the reportviewer. The value of this parameter is set by the user from a dropdownlist that has values 10, 15, 25, 30. I added two more options of 50 and 100 to this dropdownlist but the reportviewer does not display the number or records properly.
For example, if I set the number to 50, it will display first 42 or 43 records on first page and then the next 8 or 7 records on the second page and leaving extra space after that. Is it because of the height property?
Please help me fix this problem.
Thanks,
Bullpit
Hi,
As you have noted the problem may be related with the page layout properties of the report.
|||It actually was the InteractiveSize property (specifically the Height) that was doing this. The problem is fixed now for the time being.
ReportViewer control questions
in an asp.net (1.1) page. I am using Visual Studio .NET. Is this possible,
or do I need to be using Visual Studio 2005?
And, once the ReportViewer control is there, what steps do I need to take in
order for the asp.net process to access report server on a different box in
the same domain? Do I need to add the Network Service account as a user in
report server?
Thanks,
RobHi Rob,
Report viewer comes with VS 2005 so you need to have the .NET 2.0 to use the
report viewer. you cannot use in asp.net 1.1.
for more FAQ see this http://www.gotreportviewer.com/
Let us know how it goes
Thanks
Bava
"Rob" wrote:
> I am using report server on SQL2005. I want to embed a ReportViewer control
> in an asp.net (1.1) page. I am using Visual Studio .NET. Is this possible,
> or do I need to be using Visual Studio 2005?
> And, once the ReportViewer control is there, what steps do I need to take in
> order for the asp.net process to access report server on a different box in
> the same domain? Do I need to add the Network Service account as a user in
> report server?
> Thanks,
> Rob
Wednesday, March 28, 2012
reportviewer control Error, Plz help
I am using reportviewer control to show some data on an asp.net page. It is working fine in the devolpment?Machine, but when I move the code over to our Production server I get a runtime error, the runtime error shows up on the webpage and simply says:
An error has occurred during report processing.
Exception has been thrown by the target of an invocation.
Object reference not set to an instance of an object.
That didn't help at all.
Any ideas?
Thanks a lot you guys have been very helpful.
SajjadNo reply yet :(|||
Hi,
Can you add a label to display the exception in detail. At lease you can get the code line where you get the error.
Perhaps the dev and the production reports may differ in parameters, etc.
Do you set the processing mode to remote?
|||Thanx for reply,
I used this code in Report web page...(no code in code behind file)
<%@. Page Language="VB" AutoEventWireup="false" CodeFile="Report_ArabicInvoice.aspx.vb" Inherits="Web_Pages_Reports_Report_ArabicInvoice" %
<%@. 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>?ú??EXFP - Arabic Invoice</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<table>
<tr>
<td style="width: 100px">
<rsweb:ReportViewer ID="ReportViewer1" runat="server" Font-Names="Verdana" Font-Size="8pt"
Height="800px" Width="800px" ShowDocumentMapButton="False" ShowFindControls="False" ShowPromptAreaButton="False" ShowRefreshButton="False">
<LocalReport ReportPath="~\..\Web_Pages\Reports\Report_ArabicInvoice.rdlc">
<DataSources>
<rsweb:ReportDataSource DataSourceId="ObjectDataSource1" Name="ReportDataSet_Report_DT_ArabicInvoice" />
</DataSources>
</LocalReport>
</rsweb:ReportViewer>
<asp:ObjectDataSource ID="ObjectDataSource1" runat="server" SelectMethod="GetData"
TypeName="ReportDataSetTableAdapters.Report_DT_ArabicInvoiceTableAdapter" OldValuesParameterFormatString="original_{0}">
<SelectParameters>
<asp:SessionParameter Name="ord_ID" SessionField="Report_AI_OrdID" Type="Int32" />
</SelectParameters>
</asp:ObjectDataSource>
</td>
</tr>
</table>
</div>
</form>
</body>
</html|||note : ?Process mode is set to be "LOCAL"|||no reply yet ?:(
ReportViewer control and scaling issue
width and heighth to a percentage of the container that it is placed in. It
appears that the defaults are 400px. Of course these can be changed, but you
may experience horizontal and/or vertical scroll bars or a window that is too
large for the report. What we are trying to achieve is to have the contents
of the exposed SRS report scale properly when the size of the browser window
is changed. Has anyone else come across or tried to solve this issue ?Keith,
What I did was create one table with one cell and set the height and width
to 100%. Next put the report viewer control inside the table and set the
height and width to lets say 95%(this can be flexible whatever fits your
situation). The outside table will act as a container and will adjust
appropriately to the users screen resolution and the ReportViewer control
will just follow the tables lead.
--
Andrew
MCSA,MCDBA
--
Andrew
MCSA,MCDBA
"Keith" wrote:
> When using the reportviewer control on a web page, we would like to set the
> width and heighth to a percentage of the container that it is placed in. It
> appears that the defaults are 400px. Of course these can be changed, but you
> may experience horizontal and/or vertical scroll bars or a window that is too
> large for the report. What we are trying to achieve is to have the contents
> of the exposed SRS report scale properly when the size of the browser window
> is changed. Has anyone else come across or tried to solve this issue ?
>|||Thank you for the response.
I did try that as evidenced in this code:
<table id="rptViewer" runat=server align=center width="100%"
height="100%">
<tr>
<td>
<rsweb:ReportViewer ID="ReportViewer1" runat="server"
Font-Names="Verdana" Font-Size="8pt" Height="95%" ProcessingMode="Remote"
Width="95%" ShowCredentialPrompts="true">
<ServerReport
ReportPath="/chartingtest/horizontalreport_large"
ReportServerUrl="http://localhost/reportserver" />
</rsweb:ReportViewer>
</td>
</tr>
</table>
As you can see I am using SQL Reporting Services ReportViewer control. With
this configuration, nothing is rendered within the reportviewer when I run
the application. From what I see, the ReportViewer is not accepting a
percenrtage width.
Any other ideas are greatly appreciated.
"Andrew" wrote:
> Keith,
> What I did was create one table with one cell and set the height and width
> to 100%. Next put the report viewer control inside the table and set the
> height and width to lets say 95%(this can be flexible whatever fits your
> situation). The outside table will act as a container and will adjust
> appropriately to the users screen resolution and the ReportViewer control
> will just follow the tables lead.
> --
> Andrew
> MCSA,MCDBA
> --
> Andrew
> MCSA,MCDBA
>
> "Keith" wrote:
> > When using the reportviewer control on a web page, we would like to set the
> > width and heighth to a percentage of the container that it is placed in. It
> > appears that the defaults are 400px. Of course these can be changed, but you
> > may experience horizontal and/or vertical scroll bars or a window that is too
> > large for the report. What we are trying to achieve is to have the contents
> > of the exposed SRS report scale properly when the size of the browser window
> > is changed. Has anyone else come across or tried to solve this issue ?
> >|||I have experienced the same difficulty. When the Height property of the
reportviewer control is set to a percentage, it appears that the report does
not display - only the toolbar and parameters. The width as a percentage
seems to work just fine.
Is this a bug in the ReportViewer control? Is there a workaround or fix?
Mike
"Keith" wrote:
> Thank you for the response.
> I did try that as evidenced in this code:
> <table id="rptViewer" runat=server align=center width="100%"
> height="100%">
> <tr>
> <td>
> <rsweb:ReportViewer ID="ReportViewer1" runat="server"
> Font-Names="Verdana" Font-Size="8pt" Height="95%" ProcessingMode="Remote"
> Width="95%" ShowCredentialPrompts="true">
> <ServerReport
> ReportPath="/chartingtest/horizontalreport_large"
> ReportServerUrl="http://localhost/reportserver" />
> </rsweb:ReportViewer>
> </td>
> </tr>
> </table>
>
> As you can see I am using SQL Reporting Services ReportViewer control. With
> this configuration, nothing is rendered within the reportviewer when I run
> the application. From what I see, the ReportViewer is not accepting a
> percenrtage width.
> Any other ideas are greatly appreciated.
>
>
> "Andrew" wrote:
> > Keith,
> > What I did was create one table with one cell and set the height and width
> > to 100%. Next put the report viewer control inside the table and set the
> > height and width to lets say 95%(this can be flexible whatever fits your
> > situation). The outside table will act as a container and will adjust
> > appropriately to the users screen resolution and the ReportViewer control
> > will just follow the tables lead.
> > --
> > Andrew
> > MCSA,MCDBA
> >
> > --
> > Andrew
> > MCSA,MCDBA
> >
> >
> > "Keith" wrote:
> >
> > > When using the reportviewer control on a web page, we would like to set the
> > > width and heighth to a percentage of the container that it is placed in. It
> > > appears that the defaults are 400px. Of course these can be changed, but you
> > > may experience horizontal and/or vertical scroll bars or a window that is too
> > > large for the report. What we are trying to achieve is to have the contents
> > > of the exposed SRS report scale properly when the size of the browser window
> > > is changed. Has anyone else come across or tried to solve this issue ?
> > >|||Please see Question 14 in the FAQ: http://www.gotreportviewer.com/
--
Rajeev Karunakaran [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Michael R" <MichaelR@.discussions.microsoft.com> wrote in message
news:B9AE8223-6164-4B8A-89F3-30181B62583F@.microsoft.com...
>I have experienced the same difficulty. When the Height property of the
> reportviewer control is set to a percentage, it appears that the report
> does
> not display - only the toolbar and parameters. The width as a percentage
> seems to work just fine.
> Is this a bug in the ReportViewer control? Is there a workaround or fix?
> Mike
> "Keith" wrote:
>> Thank you for the response.
>> I did try that as evidenced in this code:
>> <table id="rptViewer" runat=server align=center width="100%"
>> height="100%">
>> <tr>
>> <td>
>> <rsweb:ReportViewer ID="ReportViewer1" runat="server"
>> Font-Names="Verdana" Font-Size="8pt" Height="95%" ProcessingMode="Remote"
>> Width="95%" ShowCredentialPrompts="true">
>> <ServerReport
>> ReportPath="/chartingtest/horizontalreport_large"
>> ReportServerUrl="http://localhost/reportserver" />
>> </rsweb:ReportViewer>
>> </td>
>> </tr>
>> </table>
>>
>> As you can see I am using SQL Reporting Services ReportViewer control.
>> With
>> this configuration, nothing is rendered within the reportviewer when I
>> run
>> the application. From what I see, the ReportViewer is not accepting a
>> percenrtage width.
>> Any other ideas are greatly appreciated.
>>
>>
>> "Andrew" wrote:
>> > Keith,
>> > What I did was create one table with one cell and set the height and
>> > width
>> > to 100%. Next put the report viewer control inside the table and set
>> > the
>> > height and width to lets say 95%(this can be flexible whatever fits
>> > your
>> > situation). The outside table will act as a container and will adjust
>> > appropriately to the users screen resolution and the ReportViewer
>> > control
>> > will just follow the tables lead.
>> > --
>> > Andrew
>> > MCSA,MCDBA
>> >
>> > --
>> > Andrew
>> > MCSA,MCDBA
>> >
>> >
>> > "Keith" wrote:
>> >
>> > > When using the reportviewer control on a web page, we would like to
>> > > set the
>> > > width and heighth to a percentage of the container that it is placed
>> > > in. It
>> > > appears that the defaults are 400px. Of course these can be changed,
>> > > but you
>> > > may experience horizontal and/or vertical scroll bars or a window
>> > > that is too
>> > > large for the report. What we are trying to achieve is to have the
>> > > contents
>> > > of the exposed SRS report scale properly when the size of the browser
>> > > window
>> > > is changed. Has anyone else come across or tried to solve this issue
>> > > ?
>> > >|||I added the following code to my body tag - and it worked!!! The
reportviewer control acts as if the height were set to 100% (give or take,
based on what you subtract from the 'clientHeight'). I also added the script
to the onload event, so my report will always be the correct height.
<body
onresize="javascript:document.getElementById('ReportViewer1').style.height =document.documentElement.clientHeight - 100;">
hope this helps. Enjoy!
Mike Rainey
"Michael R" wrote:
> I have experienced the same difficulty. When the Height property of the
> reportviewer control is set to a percentage, it appears that the report does
> not display - only the toolbar and parameters. The width as a percentage
> seems to work just fine.
> Is this a bug in the ReportViewer control? Is there a workaround or fix?
> Mike
> "Keith" wrote:
> > Thank you for the response.
> >
> > I did try that as evidenced in this code:
> > <table id="rptViewer" runat=server align=center width="100%"
> > height="100%">
> > <tr>
> > <td>
> > <rsweb:ReportViewer ID="ReportViewer1" runat="server"
> > Font-Names="Verdana" Font-Size="8pt" Height="95%" ProcessingMode="Remote"
> > Width="95%" ShowCredentialPrompts="true">
> > <ServerReport
> > ReportPath="/chartingtest/horizontalreport_large"
> > ReportServerUrl="http://localhost/reportserver" />
> > </rsweb:ReportViewer>
> > </td>
> > </tr>
> > </table>
> >
> >
> > As you can see I am using SQL Reporting Services ReportViewer control. With
> > this configuration, nothing is rendered within the reportviewer when I run
> > the application. From what I see, the ReportViewer is not accepting a
> > percenrtage width.
> >
> > Any other ideas are greatly appreciated.
> >
> >
> >
> >
> > "Andrew" wrote:
> >
> > > Keith,
> > > What I did was create one table with one cell and set the height and width
> > > to 100%. Next put the report viewer control inside the table and set the
> > > height and width to lets say 95%(this can be flexible whatever fits your
> > > situation). The outside table will act as a container and will adjust
> > > appropriately to the users screen resolution and the ReportViewer control
> > > will just follow the tables lead.
> > > --
> > > Andrew
> > > MCSA,MCDBA
> > >
> > > --
> > > Andrew
> > > MCSA,MCDBA
> > >
> > >
> > > "Keith" wrote:
> > >
> > > > When using the reportviewer control on a web page, we would like to set the
> > > > width and heighth to a percentage of the container that it is placed in. It
> > > > appears that the defaults are 400px. Of course these can be changed, but you
> > > > may experience horizontal and/or vertical scroll bars or a window that is too
> > > > large for the report. What we are trying to achieve is to have the contents
> > > > of the exposed SRS report scale properly when the size of the browser window
> > > > is changed. Has anyone else come across or tried to solve this issue ?
> > > >|||I have the same issue with the control not recognizing height. I am going to
submit it as a bug even though this workaround *may* work its very kludgey
and the bug should be fixed (or else and explanation should be made here by
MS).
"Michael R" wrote:
> I added the following code to my body tag - and it worked!!! The
> reportviewer control acts as if the height were set to 100% (give or take,
> based on what you subtract from the 'clientHeight'). I also added the script
> to the onload event, so my report will always be the correct height.
> <body
> onresize="javascript:document.getElementById('ReportViewer1').style.height => document.documentElement.clientHeight - 100;">
> hope this helps. Enjoy!
> Mike Rainey
>
> "Michael R" wrote:
> > I have experienced the same difficulty. When the Height property of the
> > reportviewer control is set to a percentage, it appears that the report does
> > not display - only the toolbar and parameters. The width as a percentage
> > seems to work just fine.
> >
> > Is this a bug in the ReportViewer control? Is there a workaround or fix?
> >
> > Mike
> >
> > "Keith" wrote:
> >
> > > Thank you for the response.
> > >
> > > I did try that as evidenced in this code:
> > > <table id="rptViewer" runat=server align=center width="100%"
> > > height="100%">
> > > <tr>
> > > <td>
> > > <rsweb:ReportViewer ID="ReportViewer1" runat="server"
> > > Font-Names="Verdana" Font-Size="8pt" Height="95%" ProcessingMode="Remote"
> > > Width="95%" ShowCredentialPrompts="true">
> > > <ServerReport
> > > ReportPath="/chartingtest/horizontalreport_large"
> > > ReportServerUrl="http://localhost/reportserver" />
> > > </rsweb:ReportViewer>
> > > </td>
> > > </tr>
> > > </table>
> > >
> > >
> > > As you can see I am using SQL Reporting Services ReportViewer control. With
> > > this configuration, nothing is rendered within the reportviewer when I run
> > > the application. From what I see, the ReportViewer is not accepting a
> > > percenrtage width.
> > >
> > > Any other ideas are greatly appreciated.
> > >
> > >
> > >
> > >
> > > "Andrew" wrote:
> > >
> > > > Keith,
> > > > What I did was create one table with one cell and set the height and width
> > > > to 100%. Next put the report viewer control inside the table and set the
> > > > height and width to lets say 95%(this can be flexible whatever fits your
> > > > situation). The outside table will act as a container and will adjust
> > > > appropriately to the users screen resolution and the ReportViewer control
> > > > will just follow the tables lead.
> > > > --
> > > > Andrew
> > > > MCSA,MCDBA
> > > >
> > > > --
> > > > Andrew
> > > > MCSA,MCDBA
> > > >
> > > >
> > > > "Keith" wrote:
> > > >
> > > > > When using the reportviewer control on a web page, we would like to set the
> > > > > width and heighth to a percentage of the container that it is placed in. It
> > > > > appears that the defaults are 400px. Of course these can be changed, but you
> > > > > may experience horizontal and/or vertical scroll bars or a window that is too
> > > > > large for the report. What we are trying to achieve is to have the contents
> > > > > of the exposed SRS report scale properly when the size of the browser window
> > > > > is changed. Has anyone else come across or tried to solve this issue ?
> > > > >|||Try removing the code <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN"
"">http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd"> at the top of the aspx
page.
I too had the same issue, but was able to fix it by deleting the above
code in my aspx page that hosted the reportviewer control.sql
ReportViewer control and multivalue parameter
value field which is populated by a query. How can I programaicattly select
the first value as a default? I don't see anything in ReportParameter class
that can do that.
Thanks,
GilgameshOn Sep 27, 9:00 pm, "Gilgamesh" <gilgamesh4e...@.aol.com> wrote:
> I'm using the control on an asp.net page. The first parameter is a multi
> value field which is populated by a query. How can I programaicattly select
> the first value as a default? I don't see anything in ReportParameter class
> that can do that.
> Thanks,
> Gilgamesh
You might need to create a second dataset (duplicate of the
multivalued parameter's dataset except for maybe the minimum/maximum
value) that is tied to the default value you want to use and then
select it as the default value in the Parameter settings. Hope this
helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||you can create a query which return the first value you want
and set this query result as the default value for the multivalue parameter.
"Gilgamesh" <gilgamesh4ever@.aol.com> wrote in message
news:ueSMzNXAIHA.3848@.TK2MSFTNGP05.phx.gbl...
> I'm using the control on an asp.net page. The first parameter is a multi
> value field which is populated by a query. How can I programaicattly
> select the first value as a default? I don't see anything in
> ReportParameter class that can do that.
> Thanks,
> Gilgamesh
>
>|||The problem is that this is thesecond parameter which depends on thevalue of
first parameter. The first parameter value is passed in through URL, and I
found out that the second parameter can not beinitialized when it depends on
another parameter.
-G
"Jeje" <willgart@.hotmail.com> wrote in message
news:00359520-1109-4640-8E3D-E625BD6D651C@.microsoft.com...
> you can create a query which return the first value you want
> and set this query result as the default value for the multivalue
> parameter.
>
> "Gilgamesh" <gilgamesh4ever@.aol.com> wrote in message
> news:ueSMzNXAIHA.3848@.TK2MSFTNGP05.phx.gbl...
>> I'm using the control on an asp.net page. The first parameter is a multi
>> value field which is populated by a query. How can I programaicattly
>> select the first value as a default? I don't see anything in
>> ReportParameter class that can do that.
>> Thanks,
>> Gilgamesh
>>
ReportViewer control
trying to build a test page with a single ReportViewer control
<rsweb:ReportViewer ID="ReportViewer1" ProcessingMode="remote" runat="server">
<ServerReport DisplayName="VSTestReport" ReportPath="MyReports/VSTestReport" ReportServerUrl="http://pugrs/reportserver"/>
</rsweb:ReportViewer>
build fails with 401: Unauthorized.
Not even sure where to begin troubleshooting this one. Any ideas?
Thanks!
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.Net.WebException: The request failed with HTTP status 401: Unauthorized.
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:
Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.GetSecureMethods() +240
Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.IsSecureMethod(String methodname) +86
Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.SetConnectionSSLForMethod(String methodname) +33
Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.LoadReport(String Report, String HistoryID) +152
Microsoft.Reporting.WebForms.ServerReport.GetExecutionInfo() +249
Microsoft.Reporting.WebForms.ServerReport.GetParameters() +40
Microsoft.Reporting.WebForms.ParametersArea.GetMetaDataFromReport(Boolean useCurrentValues) +138
Microsoft.Reporting.WebForms.ReportViewer.OnPreRender(EventArgs e) +182
System.Web.UI.Control.PreRenderRecursiveInternal() +77
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1787 ok. got past the authentication problem... got a new one now:
The path of the item "MyReports/VSTestReport" is not valid. The path must be less than 260 characters long and must not start with slash. Other restrictions apply. > The path of the item "MyReports/VSTestReport" is not valid. The path must be less than 260 characters long and must not start with slash. Other restrictions apply.
|||
I believe the problem is in the placement of your "/"
When naming the the server is should look like "http://localhost/reportserver"
then when naming the report path it would be "/MyReports/VSTestReport"
Good Luck
-JW
Got the same problem as you had with the authentication. It was probably pretty easy to solve but I'm a newbie so I'm glad for any help. What did you do to make it work? I have no clue where to begin searching for this one.
Thanks for your answer in advance.
Nat|||Thanks JW. -- adding a slash did work the error message that says: The path must not start with slash, should probably be a bit more helpful ;)
Nat.
We were playing with some domain accounts at the time, and the problem went away once we stopped. I have to assume that error had something to do with that -- I didn't do anything specific to resolve it.
I surely need your help TOO. I met the same "unauthorized" error. I cannot use this kind of url:
server: "http://localhost/reportserver"
report path:"/MyReports/VSTestReport"
because it will show 404 Not found error. I used:
server: "http://localhost/reportserver?"
report path:"/MyReports/VSTestReport"
and got the "unauthorized" error. Which version of visual studio are you using? I'm using 2005 beta 2.
I have tried different settings for the reportserver, even implemented IReportServerCredentials, but no luck at all. There is absolutely NO problem when I connect directly to http://localhost/reportserver?/MyReports/VSTestReport
using browser. But when using reportviewer, always "unauthorized". I'm crazy with it now. Can you post your exact codes so that I can try on my machine? Thanks.|||
Camms
I had the same trouble you did. This is what I did to make it work.
reportViewer1.ServerReport.ReportServerUrl = new System.Uri("http://localhost/reportserver");
reportViewer1.ServerReport.ReportPath = reportPath;
reportViewer1.RefreshReport();
-JW
|||could you tell me how you solved authentication problem?|||i have the authentication problem too...
|||
I got it running by Just putting following
<rsweb:ReportViewer ID="ReportViewer1" runat="server" Font-Names="Verdana" Font-Size="8pt"
Height="400px" ProcessingMode="Remote" Width="400px">
<ServerReport ReportPath="/WebReport/warmup"
ReportServerUrl="http://localhost/reportserver" />
</rsweb:ReportViewer>
|||I think that as long you are doing it on localhost, it will work.I am using a web app on another iss than the on hosting the sql2005.
I have to pass some authentication, but I need a step by step code example. Can anybody please please help?|||
I have the same problem
IIS / ASP.net on Server1, SQL Server 2005 Standard and Reporting Services on Server2
My web app uses forms authentication with the ASP.net SqlAuthenticationProvider. So my users are stored in a table in Sql Server 2005
How do I have to pass a authentication if I like to use the ReportViewer Control in my Website?
Thanks,
Dirk
|||I am having the same problem, my Reporting Services is also in a different server.
Currently, if I open the the reporting services using a web browser it prompts for a windows login, which I think I need to pass the same information using a ReportViewer control inside a code.
Example:
ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote;
// Get the Report Server endpoint from the config file
ReportViewer1.ServerReport.ReportServerUrl = new Uri(ConfigurationManager.AppSettings["ReportServerEndPoint"]);
ReportViewer1.ServerReport.ReportPath = "DailyCensus";
// Need to a code to pass the windows authentication....
//ReportViewer1.ServerReport.ReportServerCredentials
ReportViewer control
trying to build a test page with a single ReportViewer control
<rsweb:ReportViewer ID="ReportViewer1" ProcessingMode="remote" runat="server">
<ServerReport DisplayName="VSTestReport" ReportPath="MyReports/VSTestReport" ReportServerUrl="http://pugrs/reportserver"/>
</rsweb:ReportViewer>
build fails with 401: Unauthorized.
Not even sure where to begin troubleshooting this one. Any ideas?
Thanks!
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.Net.WebException: The request failed with HTTP status 401: Unauthorized.
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:
Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.GetSecureMethods() +240
Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.IsSecureMethod(String methodname) +86
Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.SetConnectionSSLForMethod(String methodname) +33
Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.LoadReport(String Report, String HistoryID) +152
Microsoft.Reporting.WebForms.ServerReport.GetExecutionInfo() +249
Microsoft.Reporting.WebForms.ServerReport.GetParameters() +40
Microsoft.Reporting.WebForms.ParametersArea.GetMetaDataFromReport(Boolean useCurrentValues) +138
Microsoft.Reporting.WebForms.ReportViewer.OnPreRender(EventArgs e) +182
System.Web.UI.Control.PreRenderRecursiveInternal() +77
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1787 ok. got past the authentication problem... got a new one now:
The path of the item "MyReports/VSTestReport" is not valid. The path must be less than 260 characters long and must not start with slash. Other restrictions apply. > The path of the item "MyReports/VSTestReport" is not valid. The path must be less than 260 characters long and must not start with slash. Other restrictions apply.|||
I believe the problem is in the placement of your "/"
When naming the the server is should look like "http://localhost/reportserver"
then when naming the report path it would be "/MyReports/VSTestReport"
Good Luck
-JW
Got the same problem as you had with the authentication. It was probably pretty easy to solve but I'm a newbie so I'm glad for any help. What did you do to make it work? I have no clue where to begin searching for this one.
Thanks for your answer in advance.
Nat|||Thanks JW. -- adding a slash did work the error message that says: The path must not start with slash, should probably be a bit more helpful ;)
Nat.
We were playing with some domain accounts at the time, and the problem went away once we stopped. I have to assume that error had something to do with that -- I didn't do anything specific to resolve it.
I surely need your help TOO. I met the same "unauthorized" error. I cannot use this kind of url:
server: "http://localhost/reportserver"
report path:"/MyReports/VSTestReport"
because it will show 404 Not found error. I used:
server: "http://localhost/reportserver?"
report path:"/MyReports/VSTestReport"
and got the "unauthorized" error. Which version of visual studio are you using? I'm using 2005 beta 2.
I have tried different settings for the reportserver, even implemented IReportServerCredentials, but no luck at all. There is absolutely NO problem when I connect directly to http://localhost/reportserver?/MyReports/VSTestReport
using browser. But when using reportviewer, always "unauthorized". I'm crazy with it now. Can you post your exact codes so that I can try on my machine? Thanks.|||
Camms
I had the same trouble you did. This is what I did to make it work.
reportViewer1.ServerReport.ReportServerUrl = new System.Uri("http://localhost/reportserver");
reportViewer1.ServerReport.ReportPath = reportPath;
reportViewer1.RefreshReport();
-JW
|||could you tell me how you solved authentication problem?|||i have the authentication problem too...
|||
I got it running by Just putting following
<rsweb:ReportViewer ID="ReportViewer1" runat="server" Font-Names="Verdana" Font-Size="8pt"
Height="400px" ProcessingMode="Remote" Width="400px">
<ServerReport ReportPath="/WebReport/warmup"
ReportServerUrl="http://localhost/reportserver" />
</rsweb:ReportViewer>
|||I think that as long you are doing it on localhost, it will work.
I am using a web app on another iss than the on hosting the sql2005.
I have to pass some authentication, but I need a step by step code example. Can anybody please please help?|||
I have the same problem
IIS / ASP.net on Server1, SQL Server 2005 Standard and Reporting Services on Server2
My web app uses forms authentication with the ASP.net SqlAuthenticationProvider. So my users are stored in a table in Sql Server 2005
How do I have to pass a authentication if I like to use the ReportViewer Control in my Website?
Thanks,
Dirk
|||I am having the same problem, my Reporting Services is also in a different server.
Currently, if I open the the reporting services using a web browser it prompts for a windows login, which I think I need to pass the same information using a ReportViewer control inside a code.
Example:
ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote;
// Get the Report Server endpoint from the config file
ReportViewer1.ServerReport.ReportServerUrl = new Uri(ConfigurationManager.AppSettings["ReportServerEndPoint"]);
ReportViewer1.ServerReport.ReportPath = "DailyCensus";
// Need to a code to pass the windows authentication....
//ReportViewer1.ServerReport.ReportServerCredentials
ReportViewer control
trying to build a test page with a single ReportViewer control
<rsweb:ReportViewer ID="ReportViewer1" ProcessingMode="remote" runat="server">
<ServerReport DisplayName="VSTestReport" ReportPath="MyReports/VSTestReport" ReportServerUrl="http://pugrs/reportserver"/>
</rsweb:ReportViewer>
build fails with 401: Unauthorized.
Not even sure where to begin troubleshooting this one. Any ideas?
Thanks!
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.Net.WebException: The request failed with HTTP status 401: Unauthorized.
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:
Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.GetSecureMethods() +240
Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.IsSecureMethod(String methodname) +86
Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.SetConnectionSSLForMethod(String methodname) +33
Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.LoadReport(String Report, String HistoryID) +152
Microsoft.Reporting.WebForms.ServerReport.GetExecutionInfo() +249
Microsoft.Reporting.WebForms.ServerReport.GetParameters() +40
Microsoft.Reporting.WebForms.ParametersArea.GetMetaDataFromReport(Boolean useCurrentValues) +138
Microsoft.Reporting.WebForms.ReportViewer.OnPreRender(EventArgs e) +182
System.Web.UI.Control.PreRenderRecursiveInternal() +77
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1787 ok. got past the authentication problem... got a new one now:
The path of the item "MyReports/VSTestReport" is not valid. The path must be less than 260 characters long and must not start with slash. Other restrictions apply. > The path of the item "MyReports/VSTestReport" is not valid. The path must be less than 260 characters long and must not start with slash. Other restrictions apply.
|||
I believe the problem is in the placement of your "/"
When naming the the server is should look like "http://localhost/reportserver"
then when naming the report path it would be "/MyReports/VSTestReport"
Good Luck
-JW
Got the same problem as you had with the authentication. It was probably pretty easy to solve but I'm a newbie so I'm glad for any help. What did you do to make it work? I have no clue where to begin searching for this one.
Thanks for your answer in advance.
Nat|||Thanks JW. -- adding a slash did work the error message that says: The path must not start with slash, should probably be a bit more helpful ;)
Nat.
We were playing with some domain accounts at the time, and the problem went away once we stopped. I have to assume that error had something to do with that -- I didn't do anything specific to resolve it.
I surely need your help TOO. I met the same "unauthorized" error. I cannot use this kind of url:
server: "http://localhost/reportserver"
report path:"/MyReports/VSTestReport"
because it will show 404 Not found error. I used:
server: "http://localhost/reportserver?"
report path:"/MyReports/VSTestReport"
and got the "unauthorized" error. Which version of visual studio are you using? I'm using 2005 beta 2.
I have tried different settings for the reportserver, even implemented IReportServerCredentials, but no luck at all. There is absolutely NO problem when I connect directly to http://localhost/reportserver?/MyReports/VSTestReport
using browser. But when using reportviewer, always "unauthorized". I'm crazy with it now. Can you post your exact codes so that I can try on my machine? Thanks.|||
Camms
I had the same trouble you did. This is what I did to make it work.
reportViewer1.ServerReport.ReportServerUrl = new System.Uri("http://localhost/reportserver");
reportViewer1.ServerReport.ReportPath = reportPath;
reportViewer1.RefreshReport();
-JW
|||could you tell me how you solved authentication problem?|||i have the authentication problem too...
|||
I got it running by Just putting following
<rsweb:ReportViewer ID="ReportViewer1" runat="server" Font-Names="Verdana" Font-Size="8pt"
Height="400px" ProcessingMode="Remote" Width="400px">
<ServerReport ReportPath="/WebReport/warmup"
ReportServerUrl="http://localhost/reportserver" />
</rsweb:ReportViewer>
|||I think that as long you are doing it on localhost, it will work.I am using a web app on another iss than the on hosting the sql2005.
I have to pass some authentication, but I need a step by step code example. Can anybody please please help?|||
I have the same problem
IIS / ASP.net on Server1, SQL Server 2005 Standard and Reporting Services on Server2
My web app uses forms authentication with the ASP.net SqlAuthenticationProvider. So my users are stored in a table in Sql Server 2005
How do I have to pass a authentication if I like to use the ReportViewer Control in my Website?
Thanks,
Dirk
|||I am having the same problem, my Reporting Services is also in a different server.
Currently, if I open the the reporting services using a web browser it prompts for a windows login, which I think I need to pass the same information using a ReportViewer control inside a code.
Example:
ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote;
// Get the Report Server endpoint from the config file
ReportViewer1.ServerReport.ReportServerUrl = new Uri(ConfigurationManager.AppSettings["ReportServerEndPoint"]);
ReportViewer1.ServerReport.ReportPath = "DailyCensus";
// Need to a code to pass the windows authentication....
//ReportViewer1.ServerReport.ReportServerCredentials
ReportViewer control
trying to build a test page with a single ReportViewer control
<rsweb:ReportViewer ID="ReportViewer1" ProcessingMode="remote" runat="server">
<ServerReport DisplayName="VSTestReport" ReportPath="MyReports/VSTestReport" ReportServerUrl="http://pugrs/reportserver"/>
</rsweb:ReportViewer>
build fails with 401: Unauthorized.
Not even sure where to begin troubleshooting this one. Any ideas?
Thanks!
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.Net.WebException: The request failed with HTTP status 401: Unauthorized.
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:
Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.GetSecureMethods() +240
Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.IsSecureMethod(String methodname) +86
Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.SetConnectionSSLForMethod(String methodname) +33
Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.LoadReport(String Report, String HistoryID) +152
Microsoft.Reporting.WebForms.ServerReport.GetExecutionInfo() +249
Microsoft.Reporting.WebForms.ServerReport.GetParameters() +40
Microsoft.Reporting.WebForms.ParametersArea.GetMetaDataFromReport(Boolean useCurrentValues) +138
Microsoft.Reporting.WebForms.ReportViewer.OnPreRender(EventArgs e) +182
System.Web.UI.Control.PreRenderRecursiveInternal() +77
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1787 ok. got past the authentication problem... got a new one now:
The path of the item "MyReports/VSTestReport" is not valid. The path must be less than 260 characters long and must not start with slash. Other restrictions apply. > The path of the item "MyReports/VSTestReport" is not valid. The path must be less than 260 characters long and must not start with slash. Other restrictions apply.
|||
I believe the problem is in the placement of your "/"
When naming the the server is should look like "http://localhost/reportserver"
then when naming the report path it would be "/MyReports/VSTestReport"
Good Luck
-JW
Got the same problem as you had with the authentication. It was probably pretty easy to solve but I'm a newbie so I'm glad for any help. What did you do to make it work? I have no clue where to begin searching for this one.
Thanks for your answer in advance.
Nat|||Thanks JW. -- adding a slash did work the error message that says: The path must not start with slash, should probably be a bit more helpful ;)
Nat.
We were playing with some domain accounts at the time, and the problem went away once we stopped. I have to assume that error had something to do with that -- I didn't do anything specific to resolve it.
I surely need your help TOO. I met the same "unauthorized" error. I cannot use this kind of url:
server: "http://localhost/reportserver"
report path:"/MyReports/VSTestReport"
because it will show 404 Not found error. I used:
server: "http://localhost/reportserver?"
report path:"/MyReports/VSTestReport"
and got the "unauthorized" error. Which version of visual studio are you using? I'm using 2005 beta 2.
I have tried different settings for the reportserver, even implemented IReportServerCredentials, but no luck at all. There is absolutely NO problem when I connect directly to http://localhost/reportserver?/MyReports/VSTestReport
using browser. But when using reportviewer, always "unauthorized". I'm crazy with it now. Can you post your exact codes so that I can try on my machine? Thanks.|||
Camms
I had the same trouble you did. This is what I did to make it work.
reportViewer1.ServerReport.ReportServerUrl = new System.Uri("http://localhost/reportserver");
reportViewer1.ServerReport.ReportPath = reportPath;
reportViewer1.RefreshReport();
-JW
|||could you tell me how you solved authentication problem?|||i have the authentication problem too...
|||
I got it running by Just putting following
<rsweb:ReportViewer ID="ReportViewer1" runat="server" Font-Names="Verdana" Font-Size="8pt"
Height="400px"ProcessingMode="Remote"Width="400px">
<ServerReportReportPath="/WebReport/warmup"
ReportServerUrl="http://localhost/reportserver"/>
</rsweb:ReportViewer>
|||I think that as long you are doing it on localhost, it will work.I am using a web app on another iss than the on hosting the sql2005.
I have to pass some authentication, but I need a step by step code example. Can anybody please please help?|||
I have the same problem
IIS / ASP.net on Server1, SQL Server 2005 Standard and Reporting Services on Server2
My web app uses forms authentication with the ASP.net SqlAuthenticationProvider. So my users are stored in a table in Sql Server 2005
How do I have to pass a authentication if I like to use the ReportViewer Control in my Website?
Thanks,
Dirk
|||I am having the same problem, my Reporting Services is also in a different server.
Currently, if I open the the reporting services using a web browser it prompts for a windows login, which I think I need to pass the same information using a ReportViewer control inside a code.
Example:
ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote;
// Get the Report Server endpoint from the config file
ReportViewer1.ServerReport.ReportServerUrl = new Uri(ConfigurationManager.AppSettings["ReportServerEndPoint"]);
ReportViewer1.ServerReport.ReportPath = "DailyCensus";
// Need to a code to pass the windows authentication....
//ReportViewer1.ServerReport.ReportServerCredentials
ReportViewer control
trying to build a test page with a single ReportViewer control
<rsweb:ReportViewer ID="ReportViewer1" ProcessingMode="remote" runat="server">
<ServerReport DisplayName="VSTestReport" ReportPath="MyReports/VSTestReport" ReportServerUrl="http://pugrs/reportserver"/>
</rsweb:ReportViewer>
build fails with 401: Unauthorized.
Not even sure where to begin troubleshooting this one. Any ideas?
Thanks!
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.Net.WebException: The request failed with HTTP status 401: Unauthorized.
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:
Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.GetSecureMethods() +240
Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.IsSecureMethod(String methodname) +86
Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.SetConnectionSSLForMethod(String methodname) +33
Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.LoadReport(String Report, String HistoryID) +152
Microsoft.Reporting.WebForms.ServerReport.GetExecutionInfo() +249
Microsoft.Reporting.WebForms.ServerReport.GetParameters() +40
Microsoft.Reporting.WebForms.ParametersArea.GetMetaDataFromReport(Boolean useCurrentValues) +138
Microsoft.Reporting.WebForms.ReportViewer.OnPreRender(EventArgs e) +182
System.Web.UI.Control.PreRenderRecursiveInternal() +77
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1787 ok. got past the authentication problem... got a new one now:
The path of the item "MyReports/VSTestReport" is not valid. The path must be less than 260 characters long and must not start with slash. Other restrictions apply. > The path of the item "MyReports/VSTestReport" is not valid. The path must be less than 260 characters long and must not start with slash. Other restrictions apply.
|||
I believe the problem is in the placement of your "/"
When naming the the server is should look like "http://localhost/reportserver"
then when naming the report path it would be "/MyReports/VSTestReport"
Good Luck
-JW
Got the same problem as you had with the authentication. It was probably pretty easy to solve but I'm a newbie so I'm glad for any help. What did you do to make it work? I have no clue where to begin searching for this one.
Thanks for your answer in advance.
Nat|||Thanks JW. -- adding a slash did work the error message that says: The path must not start with slash, should probably be a bit more helpful ;)
Nat.
We were playing with some domain accounts at the time, and the problem went away once we stopped. I have to assume that error had something to do with that -- I didn't do anything specific to resolve it.
I surely need your help TOO. I met the same "unauthorized" error. I cannot use this kind of url:
server: "http://localhost/reportserver"
report path:"/MyReports/VSTestReport"
because it will show 404 Not found error. I used:
server: "http://localhost/reportserver?"
report path:"/MyReports/VSTestReport"
and got the "unauthorized" error. Which version of visual studio are you using? I'm using 2005 beta 2.
I have tried different settings for the reportserver, even implemented IReportServerCredentials, but no luck at all. There is absolutely NO problem when I connect directly to http://localhost/reportserver?/MyReports/VSTestReport
using browser. But when using reportviewer, always "unauthorized". I'm crazy with it now. Can you post your exact codes so that I can try on my machine? Thanks.|||
Camms
I had the same trouble you did. This is what I did to make it work.
reportViewer1.ServerReport.ReportServerUrl = new System.Uri("http://localhost/reportserver");
reportViewer1.ServerReport.ReportPath = reportPath;
reportViewer1.RefreshReport();
-JW
|||could you tell me how you solved authentication problem?|||i have the authentication problem too...
|||
I got it running by Just putting following
<rsweb:ReportViewer ID="ReportViewer1" runat="server" Font-Names="Verdana" Font-Size="8pt"
Height="400px" ProcessingMode="Remote" Width="400px">
<ServerReport ReportPath="/WebReport/warmup"
ReportServerUrl="http://localhost/reportserver" />
</rsweb:ReportViewer>
|||I think that as long you are doing it on localhost, it will work.I am using a web app on another iss than the on hosting the sql2005.
I have to pass some authentication, but I need a step by step code example. Can anybody please please help?|||
I have the same problem
IIS / ASP.net on Server1, SQL Server 2005 Standard and Reporting Services on Server2
My web app uses forms authentication with the ASP.net SqlAuthenticationProvider. So my users are stored in a table in Sql Server 2005
How do I have to pass a authentication if I like to use the ReportViewer Control in my Website?
Thanks,
Dirk
|||I am having the same problem, my Reporting Services is also in a different server.
Currently, if I open the the reporting services using a web browser it prompts for a windows login, which I think I need to pass the same information using a ReportViewer control inside a code.
Example:
ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote;
// Get the Report Server endpoint from the config file
ReportViewer1.ServerReport.ReportServerUrl = new Uri(ConfigurationManager.AppSettings["ReportServerEndPoint"]);
ReportViewer1.ServerReport.ReportPath = "DailyCensus";
// Need to a code to pass the windows authentication....
//ReportViewer1.ServerReport.ReportServerCredentials
ReportViewer control
trying to build a test page with a single ReportViewer control
<rsweb:ReportViewer ID="ReportViewer1" ProcessingMode="remote" runat="server">
<ServerReport DisplayName="VSTestReport" ReportPath="MyReports/VSTestReport" ReportServerUrl="http://pugrs/reportserver"/>
</rsweb:ReportViewer>
build fails with 401: Unauthorized.
Not even sure where to begin troubleshooting this one. Any ideas?
Thanks!
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.Net.WebException: The request failed with HTTP status 401: Unauthorized.
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:
Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.GetSecureMethods() +240
Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.IsSecureMethod(String methodname) +86
Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.SetConnectionSSLForMethod(String methodname) +33
Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.LoadReport(String Report, String HistoryID) +152
Microsoft.Reporting.WebForms.ServerReport.GetExecutionInfo() +249
Microsoft.Reporting.WebForms.ServerReport.GetParameters() +40
Microsoft.Reporting.WebForms.ParametersArea.GetMetaDataFromReport(Boolean useCurrentValues) +138
Microsoft.Reporting.WebForms.ReportViewer.OnPreRender(EventArgs e) +182
System.Web.UI.Control.PreRenderRecursiveInternal() +77
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1787 ok. got past the authentication problem... got a new one now:
The path of the item "MyReports/VSTestReport" is not valid. The path must be less than 260 characters long and must not start with slash. Other restrictions apply. > The path of the item "MyReports/VSTestReport" is not valid. The path must be less than 260 characters long and must not start with slash. Other restrictions apply.|||
I believe the problem is in the placement of your "/"
When naming the the server is should look like "http://localhost/reportserver"
then when naming the report path it would be "/MyReports/VSTestReport"
Good Luck
-JW
Got the same problem as you had with the authentication. It was probably pretty easy to solve but I'm a newbie so I'm glad for any help. What did you do to make it work? I have no clue where to begin searching for this one.
Thanks for your answer in advance.
Nat|||Thanks JW. -- adding a slash did work the error message that says: The path must not start with slash, should probably be a bit more helpful ;)
Nat.
We were playing with some domain accounts at the time, and the problem went away once we stopped. I have to assume that error had something to do with that -- I didn't do anything specific to resolve it.
I surely need your help TOO. I met the same "unauthorized" error. I cannot use this kind of url:
server: "http://localhost/reportserver"
report path:"/MyReports/VSTestReport"
because it will show 404 Not found error. I used:
server: "http://localhost/reportserver?"
report path:"/MyReports/VSTestReport"
and got the "unauthorized" error. Which version of visual studio are you using? I'm using 2005 beta 2.
I have tried different settings for the reportserver, even implemented IReportServerCredentials, but no luck at all. There is absolutely NO problem when I connect directly to http://localhost/reportserver?/MyReports/VSTestReport
using browser. But when using reportviewer, always "unauthorized". I'm crazy with it now. Can you post your exact codes so that I can try on my machine? Thanks.|||
Camms
I had the same trouble you did. This is what I did to make it work.
reportViewer1.ServerReport.ReportServerUrl = new System.Uri("http://localhost/reportserver");
reportViewer1.ServerReport.ReportPath = reportPath;
reportViewer1.RefreshReport();
-JW
|||could you tell me how you solved authentication problem?|||i have the authentication problem too...
|||
I got it running by Just putting following
<rsweb:ReportViewer ID="ReportViewer1" runat="server" Font-Names="Verdana" Font-Size="8pt"
Height="400px" ProcessingMode="Remote" Width="400px">
<ServerReport ReportPath="/WebReport/warmup"
ReportServerUrl="http://localhost/reportserver" />
</rsweb:ReportViewer>
|||I think that as long you are doing it on localhost, it will work.
I am using a web app on another iss than the on hosting the sql2005.
I have to pass some authentication, but I need a step by step code example. Can anybody please please help?|||
I have the same problem
IIS / ASP.net on Server1, SQL Server 2005 Standard and Reporting Services on Server2
My web app uses forms authentication with the ASP.net SqlAuthenticationProvider. So my users are stored in a table in Sql Server 2005
How do I have to pass a authentication if I like to use the ReportViewer Control in my Website?
Thanks,
Dirk
|||I am having the same problem, my Reporting Services is also in a different server.
Currently, if I open the the reporting services using a web browser it prompts for a windows login, which I think I need to pass the same information using a ReportViewer control inside a code.
Example:
ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote;
// Get the Report Server endpoint from the config file
ReportViewer1.ServerReport.ReportServerUrl = new Uri(ConfigurationManager.AppSettings["ReportServerEndPoint"]);
ReportViewer1.ServerReport.ReportPath = "DailyCensus";
// Need to a code to pass the windows authentication....
//ReportViewer1.ServerReport.ReportServerCredentials
ReportViewer control
trying to build a test page with a single ReportViewer control
<rsweb:ReportViewer ID="ReportViewer1" ProcessingMode="remote" runat="server">
<ServerReport DisplayName="VSTestReport" ReportPath="MyReports/VSTestReport" ReportServerUrl="http://pugrs/reportserver"/>
</rsweb:ReportViewer>
build fails with 401: Unauthorized.
Not even sure where to begin troubleshooting this one. Any ideas?
Thanks!
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.Net.WebException: The request failed with HTTP status 401: Unauthorized.
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:
Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.GetSecureMethods() +240
Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.IsSecureMethod(String methodname) +86
Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.SetConnectionSSLForMethod(String methodname) +33
Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.LoadReport(String Report, String HistoryID) +152
Microsoft.Reporting.WebForms.ServerReport.GetExecutionInfo() +249
Microsoft.Reporting.WebForms.ServerReport.GetParameters() +40
Microsoft.Reporting.WebForms.ParametersArea.GetMetaDataFromReport(Boolean useCurrentValues) +138
Microsoft.Reporting.WebForms.ReportViewer.OnPreRender(EventArgs e) +182
System.Web.UI.Control.PreRenderRecursiveInternal() +77
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1787 ok. got past the authentication problem... got a new one now:
The path of the item "MyReports/VSTestReport" is not valid. The path must be less than 260 characters long and must not start with slash. Other restrictions apply. > The path of the item "MyReports/VSTestReport" is not valid. The path must be less than 260 characters long and must not start with slash. Other restrictions apply.|||
I believe the problem is in the placement of your "/"
When naming the the server is should look like "http://localhost/reportserver"
then when naming the report path it would be "/MyReports/VSTestReport"
Good Luck
-JW
Got the same problem as you had with the authentication. It was probably pretty easy to solve but I'm a newbie so I'm glad for any help. What did you do to make it work? I have no clue where to begin searching for this one.
Thanks for your answer in advance.
Nat|||Thanks JW. -- adding a slash did work the error message that says: The path must not start with slash, should probably be a bit more helpful ;)
Nat.
We were playing with some domain accounts at the time, and the problem went away once we stopped. I have to assume that error had something to do with that -- I didn't do anything specific to resolve it.
I surely need your help TOO. I met the same "unauthorized" error. I cannot use this kind of url:
server: "http://localhost/reportserver"
report path:"/MyReports/VSTestReport"
because it will show 404 Not found error. I used:
server: "http://localhost/reportserver?"
report path:"/MyReports/VSTestReport"
and got the "unauthorized" error. Which version of visual studio are you using? I'm using 2005 beta 2.
I have tried different settings for the reportserver, even implemented IReportServerCredentials, but no luck at all. There is absolutely NO problem when I connect directly to http://localhost/reportserver?/MyReports/VSTestReport
using browser. But when using reportviewer, always "unauthorized". I'm crazy with it now. Can you post your exact codes so that I can try on my machine? Thanks.|||
Camms
I had the same trouble you did. This is what I did to make it work.
reportViewer1.ServerReport.ReportServerUrl = new System.Uri("http://localhost/reportserver");
reportViewer1.ServerReport.ReportPath = reportPath;
reportViewer1.RefreshReport();
-JW
|||could you tell me how you solved authentication problem?|||i have the authentication problem too...
|||
I got it running by Just putting following
<rsweb:ReportViewer ID="ReportViewer1" runat="server" Font-Names="Verdana" Font-Size="8pt"
Height="400px" ProcessingMode="Remote" Width="400px">
<ServerReport ReportPath="/WebReport/warmup"
ReportServerUrl="http://localhost/reportserver" />
</rsweb:ReportViewer>
|||I think that as long you are doing it on localhost, it will work.
I am using a web app on another iss than the on hosting the sql2005.
I have to pass some authentication, but I need a step by step code example. Can anybody please please help?|||
I have the same problem
IIS / ASP.net on Server1, SQL Server 2005 Standard and Reporting Services on Server2
My web app uses forms authentication with the ASP.net SqlAuthenticationProvider. So my users are stored in a table in Sql Server 2005
How do I have to pass a authentication if I like to use the ReportViewer Control in my Website?
Thanks,
Dirk
|||I am having the same problem, my Reporting Services is also in a different server.
Currently, if I open the the reporting services using a web browser it prompts for a windows login, which I think I need to pass the same information using a ReportViewer control inside a code.
Example:
ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote;
// Get the Report Server endpoint from the config file
ReportViewer1.ServerReport.ReportServerUrl = new Uri(ConfigurationManager.AppSettings["ReportServerEndPoint"]);
ReportViewer1.ServerReport.ReportPath = "DailyCensus";
// Need to a code to pass the windows authentication....
//ReportViewer1.ServerReport.ReportServerCredentials