ReportViewer in SSRS2000

Is it possible to restrict the ReportViewer export options to only a
select few ?
ThanksOn the SQL Reporting Server, assuming a default install, in the
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportServer directory, open the RSReportServer.config file.
In here there is a section called <RENDER> </RENDER> which lists all
the different export types available.
This will affect all reports on the ReportServer, but you should be
able to do something with this - comment out the entire line, or add a
visible=false; tag
HTH
Jason

ReportViewer HyperlinkTarget Property Problem

I am running a locally processed report in Asp.net The report has a
textbox with a hyperlink property. In the report viewer control I
have set the HyperLink target to "_Blank".
When I look at the resultant page everything works fine for the first
page. If the user clicks on the hyperlink another browser window
opens. Unfortunately, if the user selects the next page in the
report, the Hyperlink target functionality doesn't work. Clicking on
the link results in the clicked link displaying within the report
viewer frame.
Looking at the page source
for page one the A tag is correct.
for page two the A tag is missing the target=_blank
Any suggestions?Hi Chuck,
Welcome to use MSDN Managed Newsgroup Support.
By default, when you use the Jump to URL property in the Navigation tab in
a textbox, it will jump to the web page in the same browser window.
I am not sure where you add the Hyperlink Target, here is a work around may
be help:
1. Create a webpage and add a javascript to jump to the Web Page you want
to with the "_Blank" target.
2. In the report, set the Jump to URL property to the webpage including the
script.
Hope this will be helpful.
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.

ReportViewer Help

I am having trouble populating my reportViewer. Is there a walkthrough that will show me how to do this. I am trying to view reports that reside on my ReportServer. I would really appreciate a point in the right direction
Thanks
-JWThis may help you: http://odetocode.com/Articles/128.aspx

If you are going to do further modifications to the report viewer I've written a post that could also help. http://www.sqlmonster.com/Uwe/Forum.aspx/sql-server-reporting/11593/ReportViewer-and-Click-through-links

Cheers,
Patrick
http://www.patrickperon.com

ReportViewer Help

I use the following code to display a report in the ReportViewer. The report
and the shared datasource are in another .NET solution. The report displays,
but the data does not. Can anyone help me figure out how to make the
report data display?
private DataTable LoadReportData()
{
DataSet ds = new DataSet();
ds.ReadXml("C:\\Reports\\ReportsSharedDataSource.rds");
return ds.Tables[1];
}
protected void Page_Load(object sender, EventArgs e)
{
this.ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.
ProcessingMode.Local;
this.ReportViewer1.LocalReport.ReportPath = "C:\\Reports\\ActivitySummaryReport.rdl";
this.ReportViewer1.LocalReport.DataSources.Add(new Microsoft.
Reporting.WebForms.ReportDataSource("ReportsSharedDataSource",
LoadReportData()));
this.ReportViewer1.LocalReport.EnableExternalImages = true;
}
Thanks,
PaulaAssuming that Tables[1] actually returns data and your report bindings are
correct, try:
reportViewer1.RefreshReport()
--
HTH,
---
Teo Lachev, MVP, MCSD, MCT
"Microsoft Reporting Services in Action"
"Applied Microsoft Analysis Services 2005"
Home page and blog: http://www.prologika.com/
---
"Paula" <pmpayne@.nospam.com> wrote in message
news:abc40aa6399943198835be4ccb90828a@.ureader.com...
>I use the following code to display a report in the ReportViewer. The
>report
> and the shared datasource are in another .NET solution. The report
> displays,
> but the data does not. Can anyone help me figure out how to make the
> report data display?
> private DataTable LoadReportData()
> {
> DataSet ds = new DataSet();
> ds.ReadXml("C:\\Reports\\ReportsSharedDataSource.rds");
> return ds.Tables[1];
> }
> protected void Page_Load(object sender, EventArgs e)
> {
> this.ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.
> ProcessingMode.Local;
> this.ReportViewer1.LocalReport.ReportPath => "C:\\Reports\\ActivitySummaryReport.rdl";
> this.ReportViewer1.LocalReport.DataSources.Add(new Microsoft.
> Reporting.WebForms.ReportDataSource("ReportsSharedDataSource",
> LoadReportData()));
> this.ReportViewer1.LocalReport.EnableExternalImages = true;
> }
> Thanks,
> Paula|||How many tables do you have in your dataset?
Remeber that tables are 0 indexed, so if you had only one table in your
dataset you would want to return Tables[0].
"Paula" <pmpayne@.nospam.com> wrote in message
news:abc40aa6399943198835be4ccb90828a@.ureader.com...
>I use the following code to display a report in the ReportViewer. The
>report
> and the shared datasource are in another .NET solution. The report
> displays,
> but the data does not. Can anyone help me figure out how to make the
> report data display?
> private DataTable LoadReportData()
> {
> DataSet ds = new DataSet();
> ds.ReadXml("C:\\Reports\\ReportsSharedDataSource.rds");
> return ds.Tables[1];
> }
> protected void Page_Load(object sender, EventArgs e)
> {
> this.ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.
> ProcessingMode.Local;
> this.ReportViewer1.LocalReport.ReportPath => "C:\\Reports\\ActivitySummaryReport.rdl";
> this.ReportViewer1.LocalReport.DataSources.Add(new Microsoft.
> Reporting.WebForms.ReportDataSource("ReportsSharedDataSource",
> LoadReportData()));
> this.ReportViewer1.LocalReport.EnableExternalImages = true;
> }
> Thanks,
> Paulasql

ReportViewer Height

Hello,

I try to embed my Reports of Reporting Services to ASP .NET Application. I use ReportViewer component of Visual Studio 2005.
When I try to set Height property to 100% there is no report content shown. I tried to set SizeToReportContent property but there wasn't success.
At the same time when I set Height to any particular value e.g. 400px, everything is OK. But of cousre I can't know particular height for every reports.
Did you have any such problems? Can you help me?

Thank you,Xhtml does not treat percentage height the same way as traditional html. Take a look at www.gotreportviewer.com, FAQ #14.|||I also cannot get SizeToReportContent = True to work on my web form report viewer controls. Is this a bug or are we overlooking something?|||SizeToReportContent has no effect when AsyncRendering = true. If you set AsyncRendering = false, which renders the report contents inline (versus being in an iframe), then SizeToReportContent will work.|||I wrote some javascript to size the report after it was loaded, using the AsyncRendering = true.|||

When I set AsyncRendering=true, I get an error message when the user tries to navigate to the second page of my report: " Page navigation is out of range."

When I set AsyncRendering=false, it works correctly.

I am using a remote report.

|||

korggy wrote:

When I set AsyncRendering=true, I get an error message when the user tries to navigate to the second page of my report: " Page navigation is out of range."

When I set AsyncRendering=false, it works correctly.

I am using a remote report.

I figured out a workaround. See this post.

|||

Would it be possible to post your javascript?

I still get scrollbars even when AsyncRendering=false SizeToReportContent=true

|||

dreadjr wrote:

I wrote some javascript to size the report after it was loaded, using the AsyncRendering = true.

Can you please share that with the rest of us please?

|||

This is the script that I am using. If you resize a window, you then have to refresh the page to resize the viewer, but there is probably a workaround for that, too.

css style

.fullheight{margin-bottom:120px;}

javascript

<script language="JavaScript" type="text/JavaScript">

window.onload=function resize(){

var viewer = document.getElementById("<%=ReportViewer1.ClientID %>");

var htmlheight = document.documentElement.clientHeight;

viewer.style.height = (htmlheight - 120) + "px";

}

</script>

<rsweb:ReportViewer ID="ReportViewer1" runat="server" Font-Names="Verdana" Font-Size="8pt"

ProcessingMode="Remote" Width="100%" CssClass="fullheight">

</rsweb:ReportViewer>

ReportViewer Height

Hello,

I try to embed my Reports of Reporting Services to ASP .NET Application. I use ReportViewer component of Visual Studio 2005.
When I try to set Height property to 100% there is no report content shown. I tried to set SizeToReportContent property but there wasn't success.
At the same time when I set Height to any particular value e.g. 400px, everything is OK. But of cousre I can't know particular height for every reports.
Did you have any such problems? Can you help me?

Thank you,Xhtml does not treat percentage height the same way as traditional html. Take a look at www.gotreportviewer.com, FAQ #14.|||I also cannot get SizeToReportContent = True to work on my web form report viewer controls. Is this a bug or are we overlooking something?|||SizeToReportContent has no effect when AsyncRendering = true. If you set AsyncRendering = false, which renders the report contents inline (versus being in an iframe), then SizeToReportContent will work.|||I wrote some javascript to size the report after it was loaded, using the AsyncRendering = true.|||

When I set AsyncRendering=true, I get an error message when the user tries to navigate to the second page of my report: " Page navigation is out of range."

When I set AsyncRendering=false, it works correctly.

I am using a remote report.

|||

korggy wrote:

When I set AsyncRendering=true, I get an error message when the user tries to navigate to the second page of my report: " Page navigation is out of range."

When I set AsyncRendering=false, it works correctly.

I am using a remote report.

I figured out a workaround. See this post.

|||

Would it be possible to post your javascript?

I still get scrollbars even when AsyncRendering=false SizeToReportContent=true

|||

dreadjr wrote:

I wrote some javascript to size the report after it was loaded, using the AsyncRendering = true.

Can you please share that with the rest of us please?

|||

This is the script that I am using. If you resize a window, you then have to refresh the page to resize the viewer, but there is probably a workaround for that, too.

css style

.fullheight{margin-bottom:120px;}

javascript

<script language="JavaScript" type="text/JavaScript">

window.onload=function resize(){

var viewer = document.getElementById("<%=ReportViewer1.ClientID %>");

var htmlheight = document.documentElement.clientHeight;

viewer.style.height = (htmlheight - 120) + "px";

}

</script>

<rsweb:ReportViewer ID="ReportViewer1" runat="server" Font-Names="Verdana" Font-Size="8pt"

ProcessingMode="Remote" Width="100%" CssClass="fullheight">

</rsweb:ReportViewer>

|||thanks for pointing me in the right direction. I wrote this to get rid of the duplicate scrollbars in async mode.

<body>

<script language="JavaScript" type="text/JavaScript">

window.onload=function RemoveScrollbars()

{

document.getElementById("<%=ReportViewer1.ClientID %>").lastChild.firstChild.style.overflow = "visible";

}

</script>

<form runat="server" action="Report.aspx" >

<rsweb:ReportViewer

ID="ReportViewer1"

runat="server"

ProcessingMode="Remote"

AsyncRendering="false"

SizeToReportContent="true" />

</form>

</body>

I gleened this navagation from the nifty tree view in the IE Developer Toolbar.

works like a charm!

ReportViewer Height

Hello,

I try to embed my Reports of Reporting Services to ASP .NET Application. I use ReportViewer component of Visual Studio 2005.
When I try to set Height property to 100% there is no report content shown. I tried to set SizeToReportContent property but there wasn't success.
At the same time when I set Height to any particular value e.g. 400px, everything is OK. But of cousre I can't know particular height for every reports.
Did you have any such problems? Can you help me?

Thank you,Xhtml does not treat percentage height the same way as traditional html. Take a look at www.gotreportviewer.com, FAQ #14.|||I also cannot get SizeToReportContent = True to work on my web form report viewer controls. Is this a bug or are we overlooking something?|||SizeToReportContent has no effect when AsyncRendering = true. If you set AsyncRendering = false, which renders the report contents inline (versus being in an iframe), then SizeToReportContent will work.|||I wrote some javascript to size the report after it was loaded, using the AsyncRendering = true.|||

When I set AsyncRendering=true, I get an error message when the user tries to navigate to the second page of my report: " Page navigation is out of range."

When I set AsyncRendering=false, it works correctly.

I am using a remote report.

|||

korggy wrote:

When I set AsyncRendering=true, I get an error message when the user tries to navigate to the second page of my report: " Page navigation is out of range."

When I set AsyncRendering=false, it works correctly.

I am using a remote report.

I figured out a workaround. See this post.

|||

Would it be possible to post your javascript?

I still get scrollbars even when AsyncRendering=false SizeToReportContent=true

|||

dreadjr wrote:

I wrote some javascript to size the report after it was loaded, using the AsyncRendering = true.

Can you please share that with the rest of us please?

|||

This is the script that I am using. If you resize a window, you then have to refresh the page to resize the viewer, but there is probably a workaround for that, too.

css style

.fullheight{margin-bottom:120px;}

javascript

<script language="JavaScript" type="text/JavaScript">

window.onload=function resize(){

var viewer = document.getElementById("<%=ReportViewer1.ClientID %>");

var htmlheight = document.documentElement.clientHeight;

viewer.style.height = (htmlheight - 120) + "px";

}

</script>

<rsweb:ReportViewer ID="ReportViewer1" runat="server" Font-Names="Verdana" Font-Size="8pt"

ProcessingMode="Remote" Width="100%" CssClass="fullheight">

</rsweb:ReportViewer>

ReportViewer Height

Hello,

I try to embed my Reports of Reporting Services to ASP .NET Application. I use ReportViewer component of Visual Studio 2005.
When I try to set Height property to 100% there is no report content shown. I tried to set SizeToReportContent property but there wasn't success.
At the same time when I set Height to any particular value e.g. 400px, everything is OK. But of cousre I can't know particular height for every reports.
Did you have any such problems? Can you help me?

Thank you,Xhtml does not treat percentage height the same way as traditional html. Take a look at www.gotreportviewer.com, FAQ #14.|||I also cannot get SizeToReportContent = True to work on my web form report viewer controls. Is this a bug or are we overlooking something?|||SizeToReportContent has no effect when AsyncRendering = true. If you set AsyncRendering = false, which renders the report contents inline (versus being in an iframe), then SizeToReportContent will work.|||I wrote some javascript to size the report after it was loaded, using the AsyncRendering = true.|||

When I set AsyncRendering=true, I get an error message when the user tries to navigate to the second page of my report: " Page navigation is out of range."

When I set AsyncRendering=false, it works correctly.

I am using a remote report.

|||

korggy wrote:

When I set AsyncRendering=true, I get an error message when the user tries to navigate to the second page of my report: " Page navigation is out of range."

When I set AsyncRendering=false, it works correctly.

I am using a remote report.

I figured out a workaround. See this post.

|||

Would it be possible to post your javascript?

I still get scrollbars even when AsyncRendering=false SizeToReportContent=true

|||

dreadjr wrote:

I wrote some javascript to size the report after it was loaded, using the AsyncRendering = true.

Can you please share that with the rest of us please?

|||

This is the script that I am using. If you resize a window, you then have to refresh the page to resize the viewer, but there is probably a workaround for that, too.

css style

.fullheight{margin-bottom:120px;}

javascript

<script language="JavaScript" type="text/JavaScript">

window.onload=function resize(){

var viewer = document.getElementById("<%=ReportViewer1.ClientID %>");

var htmlheight = document.documentElement.clientHeight;

viewer.style.height = (htmlheight - 120) + "px";

}

</script>

<rsweb:ReportViewer ID="ReportViewer1" runat="server" Font-Names="Verdana" Font-Size="8pt"

ProcessingMode="Remote" Width="100%" CssClass="fullheight">

</rsweb:ReportViewer>

ReportViewer Height

Hello,

I try to embed my Reports of Reporting Services to ASP .NET Application. I use ReportViewer component of Visual Studio 2005.
When I try to set Height property to 100% there is no report content shown. I tried to set SizeToReportContent property but there wasn't success.
At the same time when I set Height to any particular value e.g. 400px, everything is OK. But of cousre I can't know particular height for every reports.
Did you have any such problems? Can you help me?

Thank you,Xhtml does not treat percentage height the same way as traditional html. Take a look at www.gotreportviewer.com, FAQ #14.|||I also cannot get SizeToReportContent = True to work on my web form report viewer controls. Is this a bug or are we overlooking something?|||SizeToReportContent has no effect when AsyncRendering = true. If you set AsyncRendering = false, which renders the report contents inline (versus being in an iframe), then SizeToReportContent will work.|||I wrote some javascript to size the report after it was loaded, using the AsyncRendering = true.|||

When I set AsyncRendering=true, I get an error message when the user tries to navigate to the second page of my report: " Page navigation is out of range."

When I set AsyncRendering=false, it works correctly.

I am using a remote report.

|||

korggy wrote:

When I set AsyncRendering=true, I get an error message when the user tries to navigate to the second page of my report: " Page navigation is out of range."

When I set AsyncRendering=false, it works correctly.

I am using a remote report.

I figured out a workaround. See this post.

|||

Would it be possible to post your javascript?

I still get scrollbars even when AsyncRendering=false SizeToReportContent=true

|||

dreadjr wrote:

I wrote some javascript to size the report after it was loaded, using the AsyncRendering = true.

Can you please share that with the rest of us please?

|||

This is the script that I am using. If you resize a window, you then have to refresh the page to resize the viewer, but there is probably a workaround for that, too.

css style

.fullheight{margin-bottom:120px;}

javascript

<scriptlanguage="JavaScript"type="text/JavaScript">

window.onload=function resize(){

var viewer = document.getElementById("<%=ReportViewer1.ClientID %>");

var htmlheight = document.documentElement.clientHeight;

viewer.style.height = (htmlheight - 120) + "px";

}

</script>

<rsweb:ReportViewerID="ReportViewer1"runat="server"Font-Names="Verdana"Font-Size="8pt"

ProcessingMode="Remote"Width="100%"CssClass="fullheight">

</rsweb:ReportViewer>

|||thanks for pointing me in the right direction. I wrote this to get rid of the duplicate scrollbars in async mode.

<body>

<script language="JavaScript" type="text/JavaScript">

window.onload=function RemoveScrollbars()

{

document.getElementById("<%=ReportViewer1.ClientID %>").lastChild.firstChild.style.overflow = "visible";

}

</script>

<form runat="server" action="Report.aspx" >

<rsweb:ReportViewer

ID="ReportViewer1"

runat="server"

ProcessingMode="Remote"

AsyncRendering="false"

SizeToReportContent="true" />

</form>

</body>

I gleened this navagation from the nifty tree view in the IE Developer Toolbar.

works like a charm!

sql

ReportViewer Height

Hello,

I try to embed my Reports of Reporting Services to ASP .NET Application. I use ReportViewer component of Visual Studio 2005.
When I try to set Height property to 100% there is no report content shown. I tried to set SizeToReportContent property but there wasn't success.
At the same time when I set Height to any particular value e.g. 400px, everything is OK. But of cousre I can't know particular height for every reports.
Did you have any such problems? Can you help me?

Thank you,Xhtml does not treat percentage height the same way as traditional html. Take a look at www.gotreportviewer.com, FAQ #14.|||I also cannot get SizeToReportContent = True to work on my web form report viewer controls. Is this a bug or are we overlooking something?|||SizeToReportContent has no effect when AsyncRendering = true. If you set AsyncRendering = false, which renders the report contents inline (versus being in an iframe), then SizeToReportContent will work.|||I wrote some javascript to size the report after it was loaded, using the AsyncRendering = true.|||

When I set AsyncRendering=true, I get an error message when the user tries to navigate to the second page of my report: " Page navigation is out of range."

When I set AsyncRendering=false, it works correctly.

I am using a remote report.

|||

korggy wrote:

When I set AsyncRendering=true, I get an error message when the user tries to navigate to the second page of my report: " Page navigation is out of range."

When I set AsyncRendering=false, it works correctly.

I am using a remote report.

I figured out a workaround. See this post.

|||

Would it be possible to post your javascript?

I still get scrollbars even when AsyncRendering=false SizeToReportContent=true

|||

dreadjr wrote:

I wrote some javascript to size the report after it was loaded, using the AsyncRendering = true.

Can you please share that with the rest of us please?

|||

This is the script that I am using. If you resize a window, you then have to refresh the page to resize the viewer, but there is probably a workaround for that, too.

css style

.fullheight{margin-bottom:120px;}

javascript

<script language="JavaScript" type="text/JavaScript">

window.onload=function resize(){

var viewer = document.getElementById("<%=ReportViewer1.ClientID %>");

var htmlheight = document.documentElement.clientHeight;

viewer.style.height = (htmlheight - 120) + "px";

}

</script>

<rsweb:ReportViewer ID="ReportViewer1" runat="server" Font-Names="Verdana" Font-Size="8pt"

ProcessingMode="Remote" Width="100%" CssClass="fullheight">

</rsweb:ReportViewer>

ReportViewer Height

Hello,

I try to embed my Reports of Reporting Services to ASP .NET Application. I use ReportViewer component of Visual Studio 2005.
When I try to set Height property to 100% there is no report content shown. I tried to set SizeToReportContent property but there wasn't success.
At the same time when I set Height to any particular value e.g. 400px, everything is OK. But of cousre I can't know particular height for every reports.
Did you have any such problems? Can you help me?

Thank you,Xhtml does not treat percentage height the same way as traditional html. Take a look at www.gotreportviewer.com, FAQ #14.|||I also cannot get SizeToReportContent = True to work on my web form report viewer controls. Is this a bug or are we overlooking something?|||SizeToReportContent has no effect when AsyncRendering = true. If you set AsyncRendering = false, which renders the report contents inline (versus being in an iframe), then SizeToReportContent will work.|||I wrote some javascript to size the report after it was loaded, using the AsyncRendering = true.|||

When I set AsyncRendering=true, I get an error message when the user tries to navigate to the second page of my report: " Page navigation is out of range."

When I set AsyncRendering=false, it works correctly.

I am using a remote report.

|||

korggy wrote:

When I set AsyncRendering=true, I get an error message when the user tries to navigate to the second page of my report: " Page navigation is out of range."

When I set AsyncRendering=false, it works correctly.

I am using a remote report.

I figured out a workaround. See this post.

|||

Would it be possible to post your javascript?

I still get scrollbars even when AsyncRendering=false SizeToReportContent=true

|||

dreadjr wrote:

I wrote some javascript to size the report after it was loaded, using the AsyncRendering = true.

Can you please share that with the rest of us please?

|||

This is the script that I am using. If you resize a window, you then have to refresh the page to resize the viewer, but there is probably a workaround for that, too.

css style

.fullheight{margin-bottom:120px;}

javascript

<script language="JavaScript" type="text/JavaScript">

window.onload=function resize(){

var viewer = document.getElementById("<%=ReportViewer1.ClientID %>");

var htmlheight = document.documentElement.clientHeight;

viewer.style.height = (htmlheight - 120) + "px";

}

</script>

<rsweb:ReportViewer ID="ReportViewer1" runat="server" Font-Names="Verdana" Font-Size="8pt"

ProcessingMode="Remote" Width="100%" CssClass="fullheight">

</rsweb:ReportViewer>

ReportViewer graphics and charts do not display in aspx page

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!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 formatting

All,
I am having an issue with a fairly standard implementation of the
ReportViewer control in an Asp.net application.
I have several fairly strait forward reports, but am having problems with
one that contains several tightly aligned textboxes. I am using a grid
spacing of '0.0625in'.
When designed in Visual Studio, or when exported to PDF, the report renders
fine. However, when viewed in the ReportViewer, several of the text boxes
have been resized or moved.
I am wondering if there are some best-practices that I could utilize in
designing this report. Is there a grid spacing that renders better?
Any thoughts/suggestions would be appreciated!
Pierson2 differences that I have discovered:
1) ReportViewer does not consistently render textboxes that overlap(even
slightly) it compensates for this by realigning them. Exports do handle
overlaping textboxes.
2) If you use a bordered textbox as a 'checkbox', change the text size to
1pt. ReportViewer increases the textbox size to fit text, even if there is
no text supplied.
Hope this helps someone!
"Pierson C" wrote:
> All,
> I am having an issue with a fairly standard implementation of the
> ReportViewer control in an Asp.net application.
> I have several fairly strait forward reports, but am having problems with
> one that contains several tightly aligned textboxes. I am using a grid
> spacing of '0.0625in'.
> When designed in Visual Studio, or when exported to PDF, the report renders
> fine. However, when viewed in the ReportViewer, several of the text boxes
> have been resized or moved.
> I am wondering if there are some best-practices that I could utilize in
> designing this report. Is there a grid spacing that renders better?
> Any thoughts/suggestions would be appreciated!
> Pierson|||Make sure that none of the textboxes overlap. We don't support overlapping
items in some renderers and will move/resize items if needed.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Pierson C" <PiersonC@.discussions.microsoft.com> wrote in message
news:ED575E95-145A-401A-BDBB-82659A24580F@.microsoft.com...
> All,
> I am having an issue with a fairly standard implementation of the
> ReportViewer control in an Asp.net application.
> I have several fairly strait forward reports, but am having problems with
> one that contains several tightly aligned textboxes. I am using a grid
> spacing of '0.0625in'.
> When designed in Visual Studio, or when exported to PDF, the report
> renders
> fine. However, when viewed in the ReportViewer, several of the text boxes
> have been resized or moved.
> I am wondering if there are some best-practices that I could utilize in
> designing this report. Is there a grid spacing that renders better?
> Any thoughts/suggestions would be appreciated!
> Pierson

ReportViewer for .NET

I'm a VB6.0 programmer who is new to .Net. I'm having to write a
program in .Net that will call various .rdls in a windows
application. I've done the reports in the Business Intelligence
Studio (2005) pulling from a SQL Server 2005 database, but I don't
have .Net 2005, only Visual Studio 2003 for the VB side. I've read a
lot about using the reportviewer.dll for this, but I can't seem to
find it available for the Visual Studio 2003 or the Express version of
2005. Can someone point me in the right direction?
-wylieThe ReportViewer control assumes the 2.0 Framework and VS2005. It does not
work with 2003. See Chapter 14 of my book for a detailed discussion of this
new control. I also include the ReportViewer control in my (free) INETA
talks and some conference sessions. This is also a good source
http://gotreportviewer.com/.
hth
--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant, Dad, Grandpa
Microsoft MVP
INETA Speaker
www.betav.com
www.betav.com/blog/billva
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
------
"Wylie" <wylie72@.gmail.com> wrote in message
news:1186409091.881661.58640@.l70g2000hse.googlegroups.com...
> I'm a VB6.0 programmer who is new to .Net. I'm having to write a
> program in .Net that will call various .rdls in a windows
> application. I've done the reports in the Business Intelligence
> Studio (2005) pulling from a SQL Server 2005 database, but I don't
> have .Net 2005, only Visual Studio 2003 for the VB side. I've read a
> lot about using the reportviewer.dll for this, but I can't seem to
> find it available for the Visual Studio 2003 or the Express version of
> 2005. Can someone point me in the right direction?
> -wylie
>sql

ReportViewer Find

I have a Local report bound to a ReportViewer control and when I am typing in text in the find text box and I click find I get this message on the report viewer "Object reference not set to an instance of an object" anybody have any idea

This is a known issue with the report viewer control. It is fixed in Visual Studio SP1. See this posting for more information:

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

ReportViewer fails when called direct from production server / works when called indirect

Hi Folks ...

Here is my setup and then I'll detail what is working, not working with the ReportViewer control:

1) Server (Everything is contained on one server right now) sits in the DMZ (Web application available to Internet)

- Win2003 Server

- IIS

Web Site A -www.site1.comWeb Site B -www.site2.comWeb Site C -www.site3.com

- SQL Server 2005

- SQL Server Reporting Services

Each web site has its own SRSS Virtual Reports and ReportServer directories setup for reporting.

2) Development Workstation - inside the firewall.

- Windows XP Professional

- Visual Studio 2005

Ok, you have the setup. Now for the problem. I've created a web application that uses form authentication with user ids and passwords stored in the database that I check to allow authorization in to the web program. I have created reports and deployed them via Visual Studio to the Report Server.

Run Verification:

Successfully runs when I run by keying the web address in to the web browser - am prompted for user id and password, I manually key in the user id and password that I have coded in to the application:http://www.site1.com/ReportServer?/ApplicationName/ReportName

Run from within Visual Studio on Development Machine - note this authenticates properly - note that when run within VS, it still calls report on server:

Successfully runs the report when I have the following code on a form - the ReportViewer control is located within the web page and is named rptMOCLog (I created the MOCReportServerCredentials authentication mechanism to support my Form based authentication based on articles in this Forum and MSDN to create the authentication mechanism that can be passed to ReportServer)

ProtectedSub rptMOCLog_Init(ByVal senderAsObject,ByVal eAs System.EventArgs)Handles rptMOCLog.Init

Dim loParameters(3)As ReportParameter

Me.rptMOCLog.ServerReport.ReportServerCredentials =New ReportServerCredentials("ApplicationReportUser","ApplicationReportUserPassword","")

Me.rptMOCLog.ServerReport.ReportServerUrl =New Uri("http://www.site1.com/ReportServer")

Me.rptMOCLog.ServerReport.ReportPath ="/ApplicationName/ReportName"

loParameters(0) =

New Microsoft.Reporting.WebForms.ReportParameter("corpID", Session("svCorpId").ToString,False)

loParameters(1) =

New Microsoft.Reporting.WebForms.ReportParameter("plantID", Session("svPlantId").ToString,False)

loParameters(2) =

New Microsoft.Reporting.WebForms.ReportParameter("dateBegin", Format(DateAdd(DateInterval.Year, -1, Date.Now()),"d").ToString,True)

loParameters(3) =

New Microsoft.Reporting.WebForms.ReportParameter("dateEnd", Format(DateAdd(DateInterval.Day, 1,Date.Now()),"d").ToString,True) Me.rptMOCLog.ServerReport.SetParameters(loParameters)EndSub

Next I move the entire application up to the IIS Server and attempt to run from there - moved to thewww.site1.com web site on the server.

Application fails to run the report with the following message

The request failed with HTTP status 401: Unauthorized.

I have verified that the ApplicationReportUser is a part of the following groups:

SQLServer2005ReportingServicesWebServiceUser$ENTERPRISE$MSSQLSERVERSQLServer2005ReportServerUser$ENTERPRISE$MSSQLSERVER

Ok, I'm banging my head against the wall and it's starting to hurt. Anyone have any clue on how to make the report run from the production server?

I ended up having to blow away and reinstall the entire SQL Server environment to get rid of my error and have the reports display properly. Don't know what other solutions may exist, but this is the only way I could solve the problem.

Hoping this doesn't happen after I role this in to production ... fingers crossed.

David

ReportViewer Extract DropDown

All,
I am using the ASP.Net ReportViewer control, but I cannot extract data
because the extract format type dropdown is not visible in the control. I
have the ShowExtractControls property set to True and I can see the Extract
link, but it is disabled
Is there something else I need to configure to allow the dropdown to populate?On Dec 19, 4:10 pm, Rex Mahel <Rex Ma...@.discussions.microsoft.com>
wrote:
> All,
> I am using the ASP.Net ReportViewer control, but I cannot extract data
> because the extract format type dropdown is not visible in the control. I
> have the ShowExtractControls property set to True and I can see the Extract
> link, but it is disabled
> Is there something else I need to configure to allow the dropdown to populate?
This link might be helpful.
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1968399&SiteID=1
Also, you might try checking: C:\Program Files\Microsoft SQL Server
\MSSQL.2\Reporting Services\ReportServer\rsreportserver.config (...
\MSSQL.2\... could be ...\MSSQL.3\... based on if you have SSIS/SSAS
installed). Of course, this would be a long shot. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||Looked through the link, checked the cache issue, "Do not save exrypted pages
to disk" was unchecked, checked C:\Windows\Temp security properties and
granted full control to SQLServer2005ReportingServicesWebServiceUser user.
Nothing had any effect.
Any other ideas?
"EMartinez" wrote:
> On Dec 19, 4:10 pm, Rex Mahel <Rex Ma...@.discussions.microsoft.com>
> wrote:
> > All,
> >
> > I am using the ASP.Net ReportViewer control, but I cannot extract data
> > because the extract format type dropdown is not visible in the control. I
> > have the ShowExtractControls property set to True and I can see the Extract
> > link, but it is disabled
> >
> > Is there something else I need to configure to allow the dropdown to populate?
>
> This link might be helpful.
> http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1968399&SiteID=1
> Also, you might try checking: C:\Program Files\Microsoft SQL Server
> \MSSQL.2\Reporting Services\ReportServer\rsreportserver.config (...
> \MSSQL.2\... could be ...\MSSQL.3\... based on if you have SSIS/SSAS
> installed). Of course, this would be a long shot. Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>

ReportViewer exporting

Hi,

When you export a report in localmode using the ReportViewer export function, a new window will pop up with the download. Is there a way to eliminate that new browser window from coming up? Also, I'm having a little trouble writing some custom code to export the report instead of using the export toolbar. I found the following in a previous post...

1Dim bufferAs Byte(), fAs String, fsAs System.IO.FileStream2 f = System.IO.Path.GetTempFileName()3 System.IO.Path.ChangeExtension(f,"xls")4' there is probably a better way to set up the rendered PDF5 ' for redirecting to the Response output, but this one works.67 ' here is the binding bit. Revise to suit your dynamic situation.8 ' if you aren't really dynamically binding data against one9 ' loaded report, but rather changing10 ' reports to suit the user's needs, that will work too.11Dim ReportDataSourceX =New ReportDataSource()12With Me.ReportViewer1.LocalReport13 buffer = .Render("EXCEL", _14Nothing,Nothing,Nothing,Nothing,Nothing,Nothing)15End With1617 fs =New System.IO.FileStream(f, System.IO.FileMode.Create)18 fs.Write(buffer, 0, buffer.Length)19 fs.Close()20 fs.Dispose()2122 Response.ContentType ="Application/vnd.ms-excel"23 Response.WriteFile(f)24 Response.End()25 System.IO.File.Delete(f)

When  I run this and export, the excel file comes up very quarky with all sorts of symbols and such and does not render correctly, e,g,. the rdlc isn't even loaded and it seems like it is taking the whole page into excel from what I can read from the file.

Thanks in advance.

Hi Heyden,

You can do this by usingReportViewer.ExportContentDispositionproperty. UseAlwayInline.

For reference -

http://msdn2.microsoft.com/en-us/library/microsoft.reporting.webforms.reportviewer.exportcontentdisposition(VS.80).aspx

|||

and for custom export functionality check this post -

https://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=139828&SiteID=1

|||

Many thank for the AlwaysInline. Solved my problem. I was either going to use custom exporting or try to find a way to eliminate that page. Thanks a bunch again!

|||

I have the same problem. A new window pops-up when trying to download the report in excel through the export toolbar. I don't want to open the report inline. I need a separate window to open the report but I don't want the pop-up window to be present while downloading the report. Is there any way to eliminate the blank window or any way to close it once the download is done.

Thanks in advance !

Shabs

sql

ReportViewer Export PDF (Huge size) Workaround

If you have a chart or image in your reportviewer and you want to export file in PDF format, you will have an unusable big size pdf file.

Here is a work around fromsnapApps:(1/19/2007)

"snapApps createda solution for this problem. It involves disabling the export featurefrom the reportViewer toolbar and rendering the PDF through a custombutton. That's the easy part. Then you just use our PDFCompress libraryto compress the image streams contained within the PDF. You candownload PDFCompress athttp://www.snapapps.com/Components.aspx."

Hope this helps someone.

Hi,

I found a possible solution for this:

Download Orcas 2 Beta (I used the Virtual PC image, but the regular installation should work)

Look for:

Microsoft.ReportViewer.Common.dll

Microsoft.ReportViewer.WebForms.dll

Microsoft.ReportViewer.ProcessingObjectModel.dll

Note that the ProcessingObjectModel is in the global assembly cache. The way I was able to copy it was by going to the command line and doing adir Microsoft.ReportViewer.ProcessingObjectModel.dll /sin the root of the c drive. Then I found the location of the file, changed directory and copied the file to a previously created directory.

Make sure that the files that you pick are version 9.0.0.0!

Copy all those files and add the references in your VS2005 project. It seems that the ReportViewer version 9.0.0.0 which is in Orca is compatible with .NET 2.0.

Next, replace all references to 8.0.0.0 in any page that uses the report viewer with 9.0.0.0. Also, the web.config file has a reference to report viewer, make sure you substitute 8.0.0.0 for 9.0.0.0.

I have tested this method and it works. Make sure that the bin directory of your deployed application has the three files above.

ReportViewer Export Mode--Local Report

Is there a way to turn off PDF export for the ReportViewer control, while keeping the option to export to Excel?

Please let me know.

Thanks.

Unfortunately there is not. You can, however, turn off the entire export option and provide your own button to perform the Excel export, calling ReportViewer.LocalReport.Render() to get the data.

Reportviewer errror: For security resasons DTD is prohibited in this XML document.

I am using the ReportViewer control and I am receiving the following message:

For security resasons DTD is prohibited in this XML document. To enable DTD processing set the ProhibitDtd property on XmlReaderSettings to false and pass the settings into XmlReader.Create method.

Hi,

From the error message you provided, there are several reasons which may cause the issues:

First, the error with DTD prohibited usually appears as a result of report processing/rendering running out of memory.
(You can refer this thread:http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=128205&SiteID=1)

Second, from the experience of the community members, the error would happen when you are using a IP-address for the SQL Server Reporting Server, so try to use DNS/Machine name to map your SQL Server instead of IP-address to see if it can work.
(See this thread:http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=101047&SiteID=1)

Thanks.

reportviewer error?

I am getting the following error when I call. Any help would be appreciated.
ReportViewer1.ServerReport.Render(format, devInfo, out mimeType, out
encoding, out extension, out streamIds, out warnings);
Error:
"Client found response content type of '', but expected 'text/xml'"
below is the code I use.
MyRS.ReportViewerCredentials rvwCreds = new
MyRS.ReportViewerCredentials(userName, pass,"");
ReportViewer1.ServerReport.ReportServerCredentials = rvwCreds;
ReportViewer1.ServerReport.ReportServerUrl = new
System.Uri(ConfigurationManager.AppSettings.Get("rsUrl"));
ReportViewer1.ServerReport.ReportPath = "/benefit reports/Employee
Roster?sys_id=16&effdt=" +
HttpContext.Current.Request.QueryString.Get("asof").ToString();
string encoding = "";
string mimeType;
Microsoft.Reporting.WebForms.Warning[] warnings;
string[] streamIds;
string format = "HTML4.0";
string extension = "";
string devInfo = @."<DeviceInfo>" +
"<Toolbar>True</Toolbar>" +
"<Parameters>True</Parameters>" +
"<DocMap>True</DocMap>" +
"<Zoom>100</Zoom>" +
"</DeviceInfo>";
ReportViewer1.ServerReport.Render(format, devInfo, out mimeType, out
encoding, out extension, out streamIds, out warnings);using the SOAP access you can't provide the parameters in the reportpath
property.
its not an URL access.
the reportpath property must contain ONLY the report path (ie: "/benefit
reports/Employee Roster"
you have to use the parameters objects to send your parameters to the
report.
"dgator" <dgator@.discussions.microsoft.com> wrote in message
news:3DC2CCC0-569F-421B-9D6F-61E0B9459B6B@.microsoft.com...
>I am getting the following error when I call. Any help would be
>appreciated.
> ReportViewer1.ServerReport.Render(format, devInfo, out mimeType, out
> encoding, out extension, out streamIds, out warnings);
> Error:
> "Client found response content type of '', but expected 'text/xml'"
> below is the code I use.
> MyRS.ReportViewerCredentials rvwCreds = new
> MyRS.ReportViewerCredentials(userName, pass,"");
> ReportViewer1.ServerReport.ReportServerCredentials = rvwCreds;
> ReportViewer1.ServerReport.ReportServerUrl = new
> System.Uri(ConfigurationManager.AppSettings.Get("rsUrl"));
> ReportViewer1.ServerReport.ReportPath = "/benefit reports/Employee
> Roster?sys_id=16&effdt=" +
> HttpContext.Current.Request.QueryString.Get("asof").ToString();
> string encoding = "";
> string mimeType;
> Microsoft.Reporting.WebForms.Warning[] warnings;
> string[] streamIds;
> string format = "HTML4.0";
> string extension = "";
> string devInfo = @."<DeviceInfo>" +
> "<Toolbar>True</Toolbar>" +
> "<Parameters>True</Parameters>" +
> "<DocMap>True</DocMap>" +
> "<Zoom>100</Zoom>" +
> "</DeviceInfo>";
>
> ReportViewer1.ServerReport.Render(format, devInfo, out mimeType,
> out
> encoding, out extension, out streamIds, out warnings);
>|||I did as you said and still get this message
"Client found response content type of '', but expected 'text/xml'.\r\nThe
request failed with an empty response."
It throws the error on the SetParameters line now. If I comment out the
setting of parameters, it throws the same error on the "Render" command.
Here is my code
string userName = ConfigurationManager.AppSettings.Get("rptUser").ToString();
string pass =ConfigurationManager.AppSettings.Get("rptPassword").ToString();
MyRS.ReportViewerCredentials rvwCreds = new
MyRS.ReportViewerCredentials(userName, pass,"");
ReportViewer1.ServerReport.ReportServerCredentials = rvwCreds;
ReportViewer1.ServerReport.ReportServerUrl = new
System.Uri(ConfigurationManager.AppSettings.Get("rsUrl"));
ReportViewer1.ServerReport.ReportPath = "/benefit reports/Employee
Roster";
string sys_id =HttpContext.Current.Request.QueryString.Get("sys_id").ToString();
string asof =HttpContext.Current.Request.QueryString.Get("asof").ToString();
ReportParameter param1 = new ReportParameter("sys_id", sys_id);
ReportParameter param2 = new ReportParameter("effdt", asof);
ReportViewer1.ServerReport.SetParameters(new ReportParameter[] {
param1, param2 });
string encoding = "";
string mimeType;
Microsoft.Reporting.WebForms.Warning[] warnings;
string[] streamIds;
string format = "HTML4.0";
string extension = "";
string devInfo = @."<DeviceInfo>" +
"<Toolbar>True</Toolbar>" +
"<Parameters>True</Parameters>" +
"<DocMap>True</DocMap>" +
"<Zoom>100</Zoom>" +
"</DeviceInfo>";
ReportViewer1.ServerReport.Render(format, devInfo, out mimeType, out
encoding, out extension, out streamIds, out warnings);
"Jéjé" wrote:
> using the SOAP access you can't provide the parameters in the reportpath
> property.
> its not an URL access.
> the reportpath property must contain ONLY the report path (ie: "/benefit
> reports/Employee Roster"
> you have to use the parameters objects to send your parameters to the
> report.
>
> "dgator" <dgator@.discussions.microsoft.com> wrote in message
> news:3DC2CCC0-569F-421B-9D6F-61E0B9459B6B@.microsoft.com...
> >I am getting the following error when I call. Any help would be
> >appreciated.
> >
> > ReportViewer1.ServerReport.Render(format, devInfo, out mimeType, out
> > encoding, out extension, out streamIds, out warnings);
> >
> > Error:
> > "Client found response content type of '', but expected 'text/xml'"
> >
> > below is the code I use.
> >
> > MyRS.ReportViewerCredentials rvwCreds = new
> > MyRS.ReportViewerCredentials(userName, pass,"");
> > ReportViewer1.ServerReport.ReportServerCredentials = rvwCreds;
> >
> > ReportViewer1.ServerReport.ReportServerUrl = new
> > System.Uri(ConfigurationManager.AppSettings.Get("rsUrl"));
> > ReportViewer1.ServerReport.ReportPath = "/benefit reports/Employee
> > Roster?sys_id=16&effdt=" +
> > HttpContext.Current.Request.QueryString.Get("asof").ToString();
> >
> > string encoding = "";
> > string mimeType;
> > Microsoft.Reporting.WebForms.Warning[] warnings;
> > string[] streamIds;
> > string format = "HTML4.0";
> > string extension = "";
> > string devInfo = @."<DeviceInfo>" +
> > "<Toolbar>True</Toolbar>" +
> > "<Parameters>True</Parameters>" +
> > "<DocMap>True</DocMap>" +
> > "<Zoom>100</Zoom>" +
> > "</DeviceInfo>";
> >
> >
> > ReportViewer1.ServerReport.Render(format, devInfo, out mimeType,
> > out
> > encoding, out extension, out streamIds, out warnings);
> >
> >
>
>|||do you use RS 2005?
the new reportviewer control works with RS2005 only.
the devinfo parameters are optional, because the control provides a lot of
properties like zoom, showdocmap etc...
also this control do the rendering by himself, there is no need to call the
render method.
Put the control on your asp.net page, change the parameters and options, run
the page and you'll see the result or a more detailed error.
but, maybe there is a problem at the reportserver virtual directory himself.
"dgator" <dgator@.discussions.microsoft.com> wrote in message
news:C0581095-ED38-4960-87C3-E478454B9D33@.microsoft.com...
>I did as you said and still get this message
> "Client found response content type of '', but expected 'text/xml'.\r\nThe
> request failed with an empty response."
> It throws the error on the SetParameters line now. If I comment out the
> setting of parameters, it throws the same error on the "Render" command.
> Here is my code
> string userName => ConfigurationManager.AppSettings.Get("rptUser").ToString();
> string pass => ConfigurationManager.AppSettings.Get("rptPassword").ToString();
> MyRS.ReportViewerCredentials rvwCreds = new
> MyRS.ReportViewerCredentials(userName, pass,"");
> ReportViewer1.ServerReport.ReportServerCredentials = rvwCreds;
> ReportViewer1.ServerReport.ReportServerUrl = new
> System.Uri(ConfigurationManager.AppSettings.Get("rsUrl"));
> ReportViewer1.ServerReport.ReportPath = "/benefit reports/Employee
> Roster";
> string sys_id => HttpContext.Current.Request.QueryString.Get("sys_id").ToString();
> string asof => HttpContext.Current.Request.QueryString.Get("asof").ToString();
> ReportParameter param1 = new ReportParameter("sys_id", sys_id);
> ReportParameter param2 = new ReportParameter("effdt", asof);
> ReportViewer1.ServerReport.SetParameters(new ReportParameter[] {
> param1, param2 });
>
> string encoding = "";
> string mimeType;
> Microsoft.Reporting.WebForms.Warning[] warnings;
> string[] streamIds;
> string format = "HTML4.0";
> string extension = "";
> string devInfo = @."<DeviceInfo>" +
> "<Toolbar>True</Toolbar>" +
> "<Parameters>True</Parameters>" +
> "<DocMap>True</DocMap>" +
> "<Zoom>100</Zoom>" +
> "</DeviceInfo>";
>
> ReportViewer1.ServerReport.Render(format, devInfo, out mimeType,
> out
> encoding, out extension, out streamIds, out warnings);
>
> "Jéjé" wrote:
>> using the SOAP access you can't provide the parameters in the reportpath
>> property.
>> its not an URL access.
>> the reportpath property must contain ONLY the report path (ie: "/benefit
>> reports/Employee Roster"
>> you have to use the parameters objects to send your parameters to the
>> report.
>>
>> "dgator" <dgator@.discussions.microsoft.com> wrote in message
>> news:3DC2CCC0-569F-421B-9D6F-61E0B9459B6B@.microsoft.com...
>> >I am getting the following error when I call. Any help would be
>> >appreciated.
>> >
>> > ReportViewer1.ServerReport.Render(format, devInfo, out mimeType, out
>> > encoding, out extension, out streamIds, out warnings);
>> >
>> > Error:
>> > "Client found response content type of '', but expected 'text/xml'"
>> >
>> > below is the code I use.
>> >
>> > MyRS.ReportViewerCredentials rvwCreds = new
>> > MyRS.ReportViewerCredentials(userName, pass,"");
>> > ReportViewer1.ServerReport.ReportServerCredentials = rvwCreds;
>> >
>> > ReportViewer1.ServerReport.ReportServerUrl = new
>> > System.Uri(ConfigurationManager.AppSettings.Get("rsUrl"));
>> > ReportViewer1.ServerReport.ReportPath = "/benefit
>> > reports/Employee
>> > Roster?sys_id=16&effdt=" +
>> > HttpContext.Current.Request.QueryString.Get("asof").ToString();
>> >
>> > string encoding = "";
>> > string mimeType;
>> > Microsoft.Reporting.WebForms.Warning[] warnings;
>> > string[] streamIds;
>> > string format = "HTML4.0";
>> > string extension = "";
>> > string devInfo = @."<DeviceInfo>" +
>> > "<Toolbar>True</Toolbar>" +
>> > "<Parameters>True</Parameters>" +
>> > "<DocMap>True</DocMap>" +
>> > "<Zoom>100</Zoom>" +
>> > "</DeviceInfo>";
>> >
>> >
>> > ReportViewer1.ServerReport.Render(format, devInfo, out mimeType,
>> > out
>> > encoding, out extension, out streamIds, out warnings);
>> >
>> >
>>|||Yes, I use rs 2005.
I have reduced the code to the following and still get the issue.
ReportViewer1.ServerReport.ReportServerUrl = new
System.Uri(ConfigurationManager.AppSettings.Get("rsUrl"));
ReportViewer1.ServerReport.ReportPath = "/benefit reports/ppl";
ReportViewer1.ProcessingMode = ProcessingMode.Remote;
ReportViewer1.ServerReport.Refresh();
Any other thoughts? What about the settings on the virtual directory. I
have tried this on two different development machines.
Thanks
"Jéjé" wrote:
> do you use RS 2005?
> the new reportviewer control works with RS2005 only.
> the devinfo parameters are optional, because the control provides a lot of
> properties like zoom, showdocmap etc...
> also this control do the rendering by himself, there is no need to call the
> render method.
> Put the control on your asp.net page, change the parameters and options, run
> the page and you'll see the result or a more detailed error.
> but, maybe there is a problem at the reportserver virtual directory himself.
> "dgator" <dgator@.discussions.microsoft.com> wrote in message
> news:C0581095-ED38-4960-87C3-E478454B9D33@.microsoft.com...
> >I did as you said and still get this message
> >
> > "Client found response content type of '', but expected 'text/xml'.\r\nThe
> > request failed with an empty response."
> >
> > It throws the error on the SetParameters line now. If I comment out the
> > setting of parameters, it throws the same error on the "Render" command.
> >
> > Here is my code
> >
> > string userName => > ConfigurationManager.AppSettings.Get("rptUser").ToString();
> > string pass => > ConfigurationManager.AppSettings.Get("rptPassword").ToString();
> >
> > MyRS.ReportViewerCredentials rvwCreds = new
> > MyRS.ReportViewerCredentials(userName, pass,"");
> > ReportViewer1.ServerReport.ReportServerCredentials = rvwCreds;
> >
> > ReportViewer1.ServerReport.ReportServerUrl = new
> > System.Uri(ConfigurationManager.AppSettings.Get("rsUrl"));
> > ReportViewer1.ServerReport.ReportPath = "/benefit reports/Employee
> > Roster";
> >
> > string sys_id => > HttpContext.Current.Request.QueryString.Get("sys_id").ToString();
> > string asof => > HttpContext.Current.Request.QueryString.Get("asof").ToString();
> >
> > ReportParameter param1 = new ReportParameter("sys_id", sys_id);
> >
> > ReportParameter param2 = new ReportParameter("effdt", asof);
> >
> > ReportViewer1.ServerReport.SetParameters(new ReportParameter[] {
> > param1, param2 });
> >
> >
> > string encoding = "";
> > string mimeType;
> > Microsoft.Reporting.WebForms.Warning[] warnings;
> > string[] streamIds;
> > string format = "HTML4.0";
> > string extension = "";
> > string devInfo = @."<DeviceInfo>" +
> > "<Toolbar>True</Toolbar>" +
> > "<Parameters>True</Parameters>" +
> > "<DocMap>True</DocMap>" +
> > "<Zoom>100</Zoom>" +
> > "</DeviceInfo>";
> >
> >
> > ReportViewer1.ServerReport.Render(format, devInfo, out mimeType,
> > out
> > encoding, out extension, out streamIds, out warnings);
> >
> >
> > "Jéjé" wrote:
> >
> >> using the SOAP access you can't provide the parameters in the reportpath
> >> property.
> >> its not an URL access.
> >>
> >> the reportpath property must contain ONLY the report path (ie: "/benefit
> >> reports/Employee Roster"
> >>
> >> you have to use the parameters objects to send your parameters to the
> >> report.
> >>
> >>
> >> "dgator" <dgator@.discussions.microsoft.com> wrote in message
> >> news:3DC2CCC0-569F-421B-9D6F-61E0B9459B6B@.microsoft.com...
> >> >I am getting the following error when I call. Any help would be
> >> >appreciated.
> >> >
> >> > ReportViewer1.ServerReport.Render(format, devInfo, out mimeType, out
> >> > encoding, out extension, out streamIds, out warnings);
> >> >
> >> > Error:
> >> > "Client found response content type of '', but expected 'text/xml'"
> >> >
> >> > below is the code I use.
> >> >
> >> > MyRS.ReportViewerCredentials rvwCreds = new
> >> > MyRS.ReportViewerCredentials(userName, pass,"");
> >> > ReportViewer1.ServerReport.ReportServerCredentials = rvwCreds;
> >> >
> >> > ReportViewer1.ServerReport.ReportServerUrl = new
> >> > System.Uri(ConfigurationManager.AppSettings.Get("rsUrl"));
> >> > ReportViewer1.ServerReport.ReportPath = "/benefit
> >> > reports/Employee
> >> > Roster?sys_id=16&effdt=" +
> >> > HttpContext.Current.Request.QueryString.Get("asof").ToString();
> >> >
> >> > string encoding = "";
> >> > string mimeType;
> >> > Microsoft.Reporting.WebForms.Warning[] warnings;
> >> > string[] streamIds;
> >> > string format = "HTML4.0";
> >> > string extension = "";
> >> > string devInfo = @."<DeviceInfo>" +
> >> > "<Toolbar>True</Toolbar>" +
> >> > "<Parameters>True</Parameters>" +
> >> > "<DocMap>True</DocMap>" +
> >> > "<Zoom>100</Zoom>" +
> >> > "</DeviceInfo>";
> >> >
> >> >
> >> > ReportViewer1.ServerReport.Render(format, devInfo, out mimeType,
> >> > out
> >> > encoding, out extension, out streamIds, out warnings);
> >> >
> >> >
> >>
> >>
> >>
>
>|||have you impersonate your application?
does RS works fine? (http://localhost/reportserver?/benefit reports/ppl)
"dgator" <dgator@.discussions.microsoft.com> wrote in message
news:CDC10304-8DEE-4938-B624-84DAE034F43E@.microsoft.com...
> Yes, I use rs 2005.
> I have reduced the code to the following and still get the issue.
> ReportViewer1.ServerReport.ReportServerUrl = new
> System.Uri(ConfigurationManager.AppSettings.Get("rsUrl"));
> ReportViewer1.ServerReport.ReportPath = "/benefit reports/ppl";
> ReportViewer1.ProcessingMode = ProcessingMode.Remote;
> ReportViewer1.ServerReport.Refresh();
> Any other thoughts? What about the settings on the virtual directory. I
> have tried this on two different development machines.
> Thanks
> "Jéjé" wrote:
>> do you use RS 2005?
>> the new reportviewer control works with RS2005 only.
>> the devinfo parameters are optional, because the control provides a lot
>> of
>> properties like zoom, showdocmap etc...
>> also this control do the rendering by himself, there is no need to call
>> the
>> render method.
>> Put the control on your asp.net page, change the parameters and options,
>> run
>> the page and you'll see the result or a more detailed error.
>> but, maybe there is a problem at the reportserver virtual directory
>> himself.
>> "dgator" <dgator@.discussions.microsoft.com> wrote in message
>> news:C0581095-ED38-4960-87C3-E478454B9D33@.microsoft.com...
>> >I did as you said and still get this message
>> >
>> > "Client found response content type of '', but expected
>> > 'text/xml'.\r\nThe
>> > request failed with an empty response."
>> >
>> > It throws the error on the SetParameters line now. If I comment out
>> > the
>> > setting of parameters, it throws the same error on the "Render"
>> > command.
>> >
>> > Here is my code
>> >
>> > string userName =>> > ConfigurationManager.AppSettings.Get("rptUser").ToString();
>> > string pass =>> > ConfigurationManager.AppSettings.Get("rptPassword").ToString();
>> >
>> > MyRS.ReportViewerCredentials rvwCreds = new
>> > MyRS.ReportViewerCredentials(userName, pass,"");
>> > ReportViewer1.ServerReport.ReportServerCredentials = rvwCreds;
>> >
>> > ReportViewer1.ServerReport.ReportServerUrl = new
>> > System.Uri(ConfigurationManager.AppSettings.Get("rsUrl"));
>> > ReportViewer1.ServerReport.ReportPath = "/benefit
>> > reports/Employee
>> > Roster";
>> >
>> > string sys_id =>> > HttpContext.Current.Request.QueryString.Get("sys_id").ToString();
>> > string asof =>> > HttpContext.Current.Request.QueryString.Get("asof").ToString();
>> >
>> > ReportParameter param1 = new ReportParameter("sys_id", sys_id);
>> >
>> > ReportParameter param2 = new ReportParameter("effdt", asof);
>> >
>> > ReportViewer1.ServerReport.SetParameters(new ReportParameter[] {
>> > param1, param2 });
>> >
>> >
>> > string encoding = "";
>> > string mimeType;
>> > Microsoft.Reporting.WebForms.Warning[] warnings;
>> > string[] streamIds;
>> > string format = "HTML4.0";
>> > string extension = "";
>> > string devInfo = @."<DeviceInfo>" +
>> > "<Toolbar>True</Toolbar>" +
>> > "<Parameters>True</Parameters>" +
>> > "<DocMap>True</DocMap>" +
>> > "<Zoom>100</Zoom>" +
>> > "</DeviceInfo>";
>> >
>> >
>> > ReportViewer1.ServerReport.Render(format, devInfo, out mimeType,
>> > out
>> > encoding, out extension, out streamIds, out warnings);
>> >
>> >
>> > "Jéjé" wrote:
>> >
>> >> using the SOAP access you can't provide the parameters in the
>> >> reportpath
>> >> property.
>> >> its not an URL access.
>> >>
>> >> the reportpath property must contain ONLY the report path (ie:
>> >> "/benefit
>> >> reports/Employee Roster"
>> >>
>> >> you have to use the parameters objects to send your parameters to the
>> >> report.
>> >>
>> >>
>> >> "dgator" <dgator@.discussions.microsoft.com> wrote in message
>> >> news:3DC2CCC0-569F-421B-9D6F-61E0B9459B6B@.microsoft.com...
>> >> >I am getting the following error when I call. Any help would be
>> >> >appreciated.
>> >> >
>> >> > ReportViewer1.ServerReport.Render(format, devInfo, out mimeType, out
>> >> > encoding, out extension, out streamIds, out warnings);
>> >> >
>> >> > Error:
>> >> > "Client found response content type of '', but expected 'text/xml'"
>> >> >
>> >> > below is the code I use.
>> >> >
>> >> > MyRS.ReportViewerCredentials rvwCreds = new
>> >> > MyRS.ReportViewerCredentials(userName, pass,"");
>> >> > ReportViewer1.ServerReport.ReportServerCredentials =>> >> > rvwCreds;
>> >> >
>> >> > ReportViewer1.ServerReport.ReportServerUrl = new
>> >> > System.Uri(ConfigurationManager.AppSettings.Get("rsUrl"));
>> >> > ReportViewer1.ServerReport.ReportPath = "/benefit
>> >> > reports/Employee
>> >> > Roster?sys_id=16&effdt=" +
>> >> > HttpContext.Current.Request.QueryString.Get("asof").ToString();
>> >> >
>> >> > string encoding = "";
>> >> > string mimeType;
>> >> > Microsoft.Reporting.WebForms.Warning[] warnings;
>> >> > string[] streamIds;
>> >> > string format = "HTML4.0";
>> >> > string extension = "";
>> >> > string devInfo = @."<DeviceInfo>" +
>> >> > "<Toolbar>True</Toolbar>" +
>> >> > "<Parameters>True</Parameters>" +
>> >> > "<DocMap>True</DocMap>" +
>> >> > "<Zoom>100</Zoom>" +
>> >> > "</DeviceInfo>";
>> >> >
>> >> >
>> >> > ReportViewer1.ServerReport.Render(format, devInfo, out
>> >> > mimeType,
>> >> > out
>> >> > encoding, out extension, out streamIds, out warnings);
>> >> >
>> >> >
>> >>
>> >>
>> >>
>>sql

ReportViewer error with SSRS2005 on a non-default website

I am facing a problem when trying to access a report using ReportViewer
ASP.NET 2.0 WebForms control. The reportviewer displays an error "The attempt
to connect to the report server failed. Check your connection information and
that the report server is a compatible version. The request failed with HTTP
status 404: Not Found". When I try to access any of the SSRS2005 Web Service
method (For example: ListChildren) with a proxy, I get an error "The request
failed with HTTP status 404: Not Found."
Here are the exception details:
-----
{"The request failed with HTTP status 404: Not Found."}
[System.Net.WebException]: {"The request failed with HTTP status 404:
Not Found."}
Data: {System.Collections.ListDictionaryInternal}
HelpLink: null
InnerException: null
Message: "The request failed with HTTP status 404: Not Found."
Source: "Test.MDC.CRI.SSRS2005.Helper"
StackTrace: " at
Test.MDC.CRI.SSRS2005.Helper.RSHelper.GetChildren(String parentFolder,
Boolean recursive, CatalogItem[]& items) in
C:\\SSRS\\CRI\\Prototype2\\Libraries\\SSRS2005Helper\\RSHelper.cs:line
252\r\n at Test.MDC.CRI.SSRS2005.Helper.RSHelper.GetChildrenByType(String
parentFolder, ItemTypeEnum itemType, Boolean ignoreDatasourceFolder,
SortedList& childItems) in
C:\\SSRS\\CRI\\Prototype2\\Libraries\\SSRS2005Helper\\RSHelper.cs:line
105\r\n at Test.MDC.CRI.SSRS2005.Helper.RSHelper.GetFolders(String
parentFolder, Boolean ignoreDatasourceFolder, SortedList& childFolders) in
C:\\SSRS\\CRI\\Prototype2\\Libraries\\SSRS2005Helper\\RSHelper.cs:line 26\r\n
at BrowseFolders.Page_Load(Object sender, EventArgs e) in
c:\\SSRS\\CRI\\Prototype2\\ReportViewerWebClient\\UserCtls\\BrowseFolders.ascx.cs:line
33\r\n at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp,
Object o, Object t, EventArgs e)\r\n at
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender,
EventArgs e)\r\n at System.Web.UI.Control.OnLoad(EventArgs e)\r\n at
System.Web.UI.Control.LoadRecursive()\r\n at
System.Web.UI.Control.LoadRecursive()\r\n at
System.Web.UI.Control.LoadRecursive()\r\n at
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint,
Boolean includeStagesAfterAsyncPoint)"
TargetSite: {Boolean GetChildren(System.String, Boolean,
Test.MDC.CRI.SSRS2005.WebService.CatalogItem[] ByRef)}
-----
Response object of System.Net.WebException:
-----
{System.Net.HttpWebResponse}
[System.Net.HttpWebResponse]: {System.Net.HttpWebResponse}
base {System.MarshalByRefObject}: {System.Net.HttpWebResponse}
ContentLength: 629
ContentType: "text/html"
Headers: {Pragma: no-cache
Proxy-Connection: Keep-Alive
Connection: Keep-Alive
Content-Length: 629
Cache-Control: no-cache
Content-Type: text/html
}
IsFromCache: false
IsMutuallyAuthenticated: false
ResponseUri:
{http://ssrs.dev.reports.com:8084/ReportServer/ReportService2005.asmx}
-----
My Report Server configuration:
Web Server: Windows 2003 Standard SP1
SQL Server: SQL Enterprise 2005 SP1
Report Server Web Site: Installed on a non-default web site, running under
ASP.NET 2.0, part of app pool with identity NetWork Service
Reporting Services Windows Service running under Local System account
Identity of the web site: Anonymous access disabled, Windows Authentication
checked
Reports virtual directory - Integrated Windows Authentication, Anonymous
disabled
ReportServer virtual directory - Integrated Windows Authentication,
Anonymous disabled
Patches:
1. Disable loopback entry set as per MSKB article:
http://support.microsoft.com/kb/896861/
2. RSWebApplication.config changed as below:
Before:
<UI>
<ReportServerUrl></ReportServerUrl>
<ReportServerVirtualDirectory>ReportServer</ReportServerVirtualDirectory>
<ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
</UI>
After:
<UI>
<ReportServerUrl>http://ssrs.dev.reports.com:8084/ReportServer</ReportServerUrl>
<ReportServerVirtualDirectory></ReportServerVirtualDirectory>
<ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
</UI>
The following sites runs OK.
- http://ssrs.dev.reports.com:8084/ReportServer/ (Able to deploy reports
to this using VS2005 designer. Currently displays the version Microsoft SQL
Server Reporting Services Version 9.00.2047.00)
- http://ssrs.dev.reports.com:8084/Reports/ (Displays deployed reports and
able to browse folders)
If you can help me to fix the issue, it would be of great help. Struggling
for few days already with this issue.
Thanks,
Live_Love_LaughOne more thing to mention:
After playing with SSRS2005 for few days, I figured out that if the
WebApplication is running of file system(ASP.NET 2.0 feature), rather than on
a website I could able to see the results through report viewer control but
as soon as I put it on IIS, I am getting the error "The attempt to connect to
the report server failed. Check your connection information and that the
report server is a compatible version. The request failed with HTTP status
404: Not Found."
Any ideas?
Thanks,
Live_Love_Laugh
"Live_Love_Laugh" wrote:
> I am facing a problem when trying to access a report using ReportViewer
> ASP.NET 2.0 WebForms control. The reportviewer displays an error "The attempt
> to connect to the report server failed. Check your connection information and
> that the report server is a compatible version. The request failed with HTTP
> status 404: Not Found". When I try to access any of the SSRS2005 Web Service
> method (For example: ListChildren) with a proxy, I get an error "The request
> failed with HTTP status 404: Not Found."
> Here are the exception details:
> -----
> {"The request failed with HTTP status 404: Not Found."}
> [System.Net.WebException]: {"The request failed with HTTP status 404:
> Not Found."}
> Data: {System.Collections.ListDictionaryInternal}
> HelpLink: null
> InnerException: null
> Message: "The request failed with HTTP status 404: Not Found."
> Source: "Test.MDC.CRI.SSRS2005.Helper"
> StackTrace: " at
> Test.MDC.CRI.SSRS2005.Helper.RSHelper.GetChildren(String parentFolder,
> Boolean recursive, CatalogItem[]& items) in
> C:\\SSRS\\CRI\\Prototype2\\Libraries\\SSRS2005Helper\\RSHelper.cs:line
> 252\r\n at Test.MDC.CRI.SSRS2005.Helper.RSHelper.GetChildrenByType(String
> parentFolder, ItemTypeEnum itemType, Boolean ignoreDatasourceFolder,
> SortedList& childItems) in
> C:\\SSRS\\CRI\\Prototype2\\Libraries\\SSRS2005Helper\\RSHelper.cs:line
> 105\r\n at Test.MDC.CRI.SSRS2005.Helper.RSHelper.GetFolders(String
> parentFolder, Boolean ignoreDatasourceFolder, SortedList& childFolders) in
> C:\\SSRS\\CRI\\Prototype2\\Libraries\\SSRS2005Helper\\RSHelper.cs:line 26\r\n
> at BrowseFolders.Page_Load(Object sender, EventArgs e) in
> c:\\SSRS\\CRI\\Prototype2\\ReportViewerWebClient\\UserCtls\\BrowseFolders.ascx.cs:line
> 33\r\n at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp,
> Object o, Object t, EventArgs e)\r\n at
> System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender,
> EventArgs e)\r\n at System.Web.UI.Control.OnLoad(EventArgs e)\r\n at
> System.Web.UI.Control.LoadRecursive()\r\n at
> System.Web.UI.Control.LoadRecursive()\r\n at
> System.Web.UI.Control.LoadRecursive()\r\n at
> System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint,
> Boolean includeStagesAfterAsyncPoint)"
> TargetSite: {Boolean GetChildren(System.String, Boolean,
> Test.MDC.CRI.SSRS2005.WebService.CatalogItem[] ByRef)}
> -----
> Response object of System.Net.WebException:
> -----
> {System.Net.HttpWebResponse}
> [System.Net.HttpWebResponse]: {System.Net.HttpWebResponse}
> base {System.MarshalByRefObject}: {System.Net.HttpWebResponse}
> ContentLength: 629
> ContentType: "text/html"
> Headers: {Pragma: no-cache
> Proxy-Connection: Keep-Alive
> Connection: Keep-Alive
> Content-Length: 629
> Cache-Control: no-cache
> Content-Type: text/html
> }
> IsFromCache: false
> IsMutuallyAuthenticated: false
> ResponseUri:
> {http://ssrs.dev.reports.com:8084/ReportServer/ReportService2005.asmx}
> -----
> My Report Server configuration:
> Web Server: Windows 2003 Standard SP1
> SQL Server: SQL Enterprise 2005 SP1
> Report Server Web Site: Installed on a non-default web site, running under
> ASP.NET 2.0, part of app pool with identity NetWork Service
> Reporting Services Windows Service running under Local System account
> Identity of the web site: Anonymous access disabled, Windows Authentication
> checked
> Reports virtual directory - Integrated Windows Authentication, Anonymous
> disabled
> ReportServer virtual directory - Integrated Windows Authentication,
> Anonymous disabled
> Patches:
> 1. Disable loopback entry set as per MSKB article:
> http://support.microsoft.com/kb/896861/
> 2. RSWebApplication.config changed as below:
> Before:
> <UI>
> <ReportServerUrl></ReportServerUrl>
> <ReportServerVirtualDirectory>ReportServer</ReportServerVirtualDirectory>
> <ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
> </UI>
> After:
> <UI>
> <ReportServerUrl>http://ssrs.dev.reports.com:8084/ReportServer</ReportServerUrl>
> <ReportServerVirtualDirectory></ReportServerVirtualDirectory>
> <ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
> </UI>
> The following sites runs OK.
> - http://ssrs.dev.reports.com:8084/ReportServer/ (Able to deploy reports
> to this using VS2005 designer. Currently displays the version Microsoft SQL
> Server Reporting Services Version 9.00.2047.00)
> - http://ssrs.dev.reports.com:8084/Reports/ (Displays deployed reports and
> able to browse folders)
>
> If you can help me to fix the issue, it would be of great help. Struggling
> for few days already with this issue.
> Thanks,
> Live_Love_Laugh

ReportViewer error "Page navigation is out of range"

I am embedding the ReportViewer in an aspx page and the report comes up fine, but when I press the "Next Page" or "Last Page" buttons, I get the 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";

|||thanks! works perfectly..|||That was it exactly. Thanks.|||

Perfect.

You made my day.

Thanx.

ReportViewer error "Page navigation is out of range"

I am embedding the ReportViewer in an aspx page and the report comes up fine, but when I press the "Next Page" or "Last Page" buttons, I get the 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";

|||thanks! works perfectly..|||That was it exactly. Thanks.|||

Perfect.

You made my day.

Thanx.

ReportViewer error "Page navigation is out of range"

I am embedding the ReportViewer in an aspx page and the report comes up fine, but when I press the "Next Page" or "Last Page" buttons, I get the 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";

|||thanks! works perfectly..|||That was it exactly. Thanks.|||

Perfect.

You made my day.

Thanx.

ReportViewer error "Page navigation is out of range"

I am embedding the ReportViewer in an aspx page and the report comes up fine, but when I press the "Next Page" or "Last Page" buttons, I get the 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";

|||thanks! works perfectly..|||That was it exactly. Thanks.|||

Perfect.

You made my day.

Thanx.

sql