report works in VS2003, but not in IE

I have a dirt-simple report that will render perfectly in the IDE, but when
it is deployed and run in the browser, I get the following error:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. (rrRenderingError) Get Online Help
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown.
Index was out of range. Must be non-negative and less than the size of the
collection. Parameter name: index
The report consists of a single textbox and two Line objects. The textbox
receives its value from a query that returns a single field. I have applied
the SSRS SP1.
Other reports work fine. For some reason this simple one fails. Why? I
can post the RDL upon request.Do you have any expressions in your report?
Andy Potter|||"Potter" wrote:
> Do you have any expressions in your report?
> Andy Potter
No, here's the only report item:
<ReportItems>
<Textbox Name="Notes">
<Style>
<PaddingLeft>0in</PaddingLeft>
<BorderColor>
<Default>#000000</Default>
</BorderColor>
<BorderStyle>
<Default>Dashed</Default>
</BorderStyle>
<FontSize>8pt</FontSize>
<LineHeight>13pt</LineHeight>
<Color>#000000</Color>
<PaddingBottom>0in</PaddingBottom>
<PaddingTop>0in</PaddingTop>
<PaddingRight>0in</PaddingRight>
</Style>
<Height>0.2083in</Height>
<Width>10in</Width>
<CanGrow>true</CanGrow>
<CanShrink>true</CanShrink>
<Value>=Fields!RSNotes.Value</Value>
</Textbox>
</ReportItems>
---
The field does need to wrap to multiple lines to display the "RSNotes" text
from the db. The above XML is nested inside <List></List> tags, which is the
only thing inside the Body tags.|||Any parameters or calculated fields?|||"Potter" wrote:
> Any parameters or calculated fields?
No calculated fields. There is one report parameter, "nRecordID", which is
used in the TSQL query as "...where RecordID = @.nRecordID"|||Unusual. Most of the references to this error revolve around exporting
to Excel. While the SP2 readme doesn't identify this as a resolved
issue, it might be worth bumping up to the move recent service pack.
Andy POtter|||"Potter" wrote:
> Unusual. Most of the references to this error revolve around exporting
> to Excel. While the SP2 readme doesn't identify this as a resolved
> issue, it might be worth bumping up to the move recent service pack.
I should have corrected my first post to state we are using SSRS2K SP2. It
is strange that this simplest report fails where much more complex ones are
OK. The report was imported from an Access2000 .mdb file. I will try
recreating it from scratch to see what happens. If all else fails I'll
install a trial of SSRS 05 on a different server and try it there.|||I've been able to reproduce the error. Starting from an empty report, the
body would deploy and print OK. When I added the pageheader from the
imported report, I got the "index out of range" error. Here is the
pageheader that was generated by the "Import report from Access" function:
<PageHeader>
<ReportItems>
<Line Name="Line8">
<Width>0in</Width>
<Style>
<BorderWidth>
<Default>2pt</Default>
</BorderWidth>
<BorderColor>
<Default>#000000</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Line>
</ReportItems>
<PrintOnLastPage>true</PrintOnLastPage>
<PrintOnFirstPage>true</PrintOnFirstPage>
<Style>
<BackgroundColor>#ffffff</BackgroundColor>
</Style>
<Height>0in</Height>
</PageHeader>
With this pageheader removed, the report works. It would seem the import
code does not always produce valid reports, even though the pageheader does
render without error in the IDE.sql

Report with SSIS package having Indirect Package Configuration setup

Deployed Report having SSIS package as source do not work when Indirect Package configuration is used in ETL package. It seems ETL package when called/executed from Report manager does not recognize environment variable to pick up the dtsconfig file.

The Report works when Direct package configuration is used to same dtsconfig file.

What could be the reason? Any solution for this? This will cause our build/deployment to QA and Prod very difficult.

IIS needs to be reset to pickup the new system environment variable.

Also the variable should be of type System.

Thanks

sql

Report Viewer Web Part - Error - Help!

I am trying to integrate reports that I have built with VS 2005 and deployed to my report server locally.

The path to the report is

http://SERVERNAME/Reports/Pages/Report.aspx?ItemPath=%2fBilling+System+Reports%2fBasic+Financial+Reports%2fBasic+Financial+Statistics+-+TimeKeeper+YTD

When I put that into the "Report" parameter the web part display an error:

The report server has encountered a configuration error. See the report server log files for more information

And when I click on the ellipses, I get a pop up with the same error.

I installed SQL2005 SP2 and the RS Add on for MS sharepoint CTP

Any help would be great!

Thanks,

Erik

Assuming your report server is configured in SharePoint integrated mode (which I'm not sure it is). You don't use the report server path for the web part, you use the path to the report in SharePoint. You can get this path from the document library where the report is stored.

|||

What if I just want the web part to act like an iframe into the reporting services web front end, like the web parts for 2000 worked? Are these web parts not designed to work this way? If not, are there any 2005 web parts for viewing reports on the SSRS front end?

Thanks!

sql

Report Viewer to Get Data from RS Deployed on separate Network.

Hi,

I am using Reporting Services in the following way. The application implements a three tier Architecture viz Web Server, Application Server and Database Server. Reporting Services 2005 is installed on the Database Server.

The application uses ReportViewer Control which is part of an ASPX page deployed on the Web Server. For ReportViewer Control to fetch data from Reporting Services using RS API, we have to set ReportServerUrl and Report Path. In this scenario, the web server cannot communicate to the database server directly. The web server is in the DMZ and it can only communicate with the Application Server which is in a separate Network.

How can I use Report Viewer Control to fetch data from Reporting Services which is on the Database Server.

Thanks & Regards,

Rajiv

I am afraid you won't like the answer but the Report Viewer control assumes a direct connection to the Report Server web service. It looks like in your situation, you need to install RS on the application server. A split deployment scenario is also an option (RS middle tier on the application server, while the catalog is on the database server) but you will need two licenses. Finally, in case you wan't to get innovative, try implementing an HttpHandler on the application server that would intercept SOAP and URL requests generated by the ReportViewer and forward them to the database server. I haven't done this but it should be possible. If you decide to try the last option, please post your findings here.|||

Hi,

Thanks for your reply. I am working on the approach that you have suggested. I have created an HttpHandler which is deployed as an Application Gateway on the Application Server. In the process request method of HttpHandler I am using HttpContext to get the current request and create a new request to the reporting server.

I am using windows XP, IIS 5.1. , Microsoft Visual Studio 2005 and Asp.net 2.0.

Scenario : Request an ASP.NET Page from the Webserver... which in turn makes a new request using HttpHandler which invokes Reporting Server.

"abc.aspx" page includes report viewer control. This page is deployed on the web server. The following properties are set for ReportViewer Control.

ReportVwrObj.ServerReport.ReportServerUrl = HTTPHandlerURL;

ReportVwrObj.ServerReport.ReportPath = ConfigurationManager.AppSettings["WebReportResults"].ToString ( ); //report file name and path.

Using Http Handler : I was able to sucessfully create a new request once i get the request from web server........However, I came across few issues related to Response.

Below is the sample code implemented in the ProcessRequest Method of HttpHandler.

public void ProcessRequest ( HttpContext context )

{

context.Response.ContentType = "text/plain";

//Url Request

RequestURL = "http://MahineName/reportserver";

///create the web request to get the remote stream

HttpWebRequest objRequest = ( HttpWebRequest ) WebRequest.Create ( RequestURL );

//objRequest.Credentials = CredentialCache.DefaultNetworkCredentials;

NetworkCredential nt = new NetworkCredential ( "Username", "Password", "Domain." );

objRequest.Credentials = nt;

objRequest.KeepAlive = false;

boolException = false;//clear exception

objResponse = ( HttpWebResponse ) objRequest.GetResponse ( );

if ( ( objResponse.ContentType.ToLower ( ).IndexOf ( "html" ) >= 0 ) || ( objResponse.ContentType.ToLower ( ).IndexOf ( "javascript" ) >= 0 )

||( objResponse.ContentType.ToLower ( ).IndexOf ( "xml" ) >= 0 ) )

{

//this objResponse is HTML Content, so we must parse it

StreamReader objReadStream = new StreamReader ( objReceiveStream, Encoding.Default );

//Uri test = new Uri(strRemoteUrl);

strContent = "";

strContent = objReadStream.ReadToEnd ( );

context.Response.ContentType = objResponse.ContentType;

context.Response.Flush ( );

context.Response.Write ( strContent );

///close streams

objReadStream.Close ( );

objResponse.Close ( );

}

context.Response.End ( );

}

In the above code, I have created a new httpwebrequest to forward the request to the reporting server. For the newly created request i get the response and flush it . I came across the below error while following this approach.

Response is not well-formed XML.

Data at the root level is invalid. Line 1, position 1.

Any Clue on this ?

|||Use a listener such as tcpTrace or SoapUtil to capture the request from the HttpHandler by redirecting to http://MahineName:8080/reportserver. It looks like the XML got distorted or something.

Report Viewer Error after Deployment

I have created a report on my local machine and deployed it on a server. As I am the administrator of the server, I can access the reports with servername\Reports. The report has got three data sets. Out of these three one is a Stored procedure and other two data sets have sql queries. The user selects the 'Business year' and 'sales type' from list box. This report works perfect from my local machine as well as from teh server when I am running it

I have some other users who wish to access these reports. I did the following steps:

Created a new role and assigned it at the Data Source Folder and Reports Folder

I also made the user a Database user on the server.

After doing these steps, the user can access the Reports site by servername\Reports.

The user then can go into the Reports folder. But when the user tries to run the report, he gets an error with:

An error has occurred during report processing. (rsProcessingAborted)

Query execution failed for data set 'BusinessYear'. (rsErrorExecutingCommand)

For more information about this error navigate to the report server on the local server machine, or enable remote errors

Can anyone help me with this? Is htere something to do with setting up of the datasource?

I have tried to search, but could not find relevant info.

Any help/Pointers will be really appreciated.

regards

Joshker

Hi Joshker,

Can you provide us with the RS Log Files so we can look into the error in more detail......

Potenitally you could have a "datatype" issue wrong with the Business Year....

Report Viewer Control to display reports

I have reports designed and deployed at the report server running Sql 2005
SSRS. I want to display those report in a vb.net Windows application using a
report viewer control and I have searched the internet for the past 2 weeks
and I still can not find anything or samples on how to do this. I wonder if
it is doable. Thanks.Paul,
You should find the report viewer reference at
http://msdn2.microsoft.com/en-us/library/microsoft.reporting.winforms(vs.80).aspx .
However, if you want just to show a predefined report for the end users,
Visual Studio offers the basic settings for the control, such as Report
server and report name. It is not a big magic :)
I got this sample, hope it will help for you.
http://www.devx.com/dotnet/Article/30424
Regards,
Janos
"Paul" <paul_mak@.shaw.ca> wrote in message
news:O2CwgFviHHA.5052@.TK2MSFTNGP05.phx.gbl...
>I have reports designed and deployed at the report server running Sql 2005
>SSRS. I want to display those report in a vb.net Windows application using
>a report viewer control and I have searched the internet for the past 2
>weeks and I still can not find anything or samples on how to do this. I
>wonder if it is doable. Thanks.
>|||Some great samples at http://www.gotreportviewer.com
--
Andy Potter
blog : http://sqlreportingservices.spaces.live.com
info@.(NOSPAM)lakeclaireenterprises.com
"Paul" <paul_mak@.shaw.ca> wrote in message
news:O2CwgFviHHA.5052@.TK2MSFTNGP05.phx.gbl...
>I have reports designed and deployed at the report server running Sql 2005
>SSRS. I want to display those report in a vb.net Windows application using
>a report viewer control and I have searched the internet for the past 2
>weeks and I still can not find anything or samples on how to do this. I
>wonder if it is doable. Thanks.
>

Report Viewer access permissions problem

Hi,
I have a Report Viewer intergrated in my application and deployed on server. When I try to access that from internet it says Network/Service account has not enough permission to run that task. Any idea how to give rights to SQL Server 2005 Service account to run reports from internet.

Thanks

add the NT AUTHORITY\NETWORK SERVICE as USER to your db|||

Hi,

Thanks for the reply

I already added NT AUTHORITY\NETWORK SERVICE as user for DB but when loading report from web page that its says that NT AUTHORITY\NETWORK SERVICE dont have enough permission to run that task for report viewer. Please any idea

Thanks

sql

Report Timeout

I have designed a report that hits a large table of over a million rows. The report runs in the development environment as a preview. When deployed, the report runs about 1.5 hours and then returns an error. The report is set not to timeout. What could be causing this behavior?What error is being returned?
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"DJP" <DJP@.discussions.microsoft.com> wrote in message
news:D8468C56-4D72-47FB-AA76-9A82D8A9CDAC@.microsoft.com...
> I have designed a report that hits a large table of over a million rows.
The report runs in the development environment as a preview. When deployed,
the report runs about 1.5 hours and then returns an error. The report is
set not to timeout. What could be causing this behavior?|||The page displayed is: The page cannot be displayed
"Bruce Johnson [MSFT]" wrote:
> What error is being returned?
> --
> Bruce Johnson [MSFT]
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "DJP" <DJP@.discussions.microsoft.com> wrote in message
> news:D8468C56-4D72-47FB-AA76-9A82D8A9CDAC@.microsoft.com...
> > I have designed a report that hits a large table of over a million rows.
> The report runs in the development environment as a preview. When deployed,
> the report runs about 1.5 hours and then returns an error. The report is
> set not to timeout. What could be causing this behavior?
>
>

Report re-opening problem

Hi,

I have created a RDL report and successfully deployed it in reporting server. The following code is used to open the Report.

private void Form1_Load(object sender, EventArgs e){

this.reportViewer1.ProcessingMode = Microsoft.Reporting.WinForms.ProcessingMode.Remote;

this.reportViewer1.ServerReport.ReportServerUrl = new Uri("http://localhost/ReportServer");

this.reportViewer1.ServerReport.ReportPath = "/Import Run Reports/ImportRunReport";

Microsoft.Reporting.WinForms.ReportParameter[] param = new Microsoft.Reporting.WinForms.ReportParameter[2];param[0] = new Microsoft.Reporting.WinForms.ReportParameter("RunId", "195900,195904,195711,195707");param[1] = new Microsoft.Reporting.WinForms.ReportParameter("ReportType", "Summary");

reportViewer1.ServerReport.SetParameters(param);

reportViewer1.RefreshReport();

}

Very first time the Report is opening successfully. Once I close the window and again i am trying to open the report i am getting the following error "The underlying connection was closed: A connection that was expected to be kept alive was closed by the server."

Could you Please help me in this regard.

Dear Ravi,

I had the same issue as you once. I am going to past some code on here that I use for my report viewer.

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Text;

using System.Windows.Forms;

using Microsoft.Reporting.WinForms;

namespace Detail_Report_Viewer

{

public partial class Form1 : Form

{

public Form1()

{

InitializeComponent();

}

private void Form1_Load(object sender, EventArgs e)

{

this.reportViewer1.RefreshReport();

}

private void runReport_Click(object sender, EventArgs e)

{

reportURL.Text = "/Import Run Reports/ImportRunReport";

reportViewer1.ProcessingMode =

Microsoft.Reporting.WinForms.ProcessingMode.Remote;

reportViewer1.ServerReport.ReportServerUrl =

new Uri (@."http://localhost/ReportServer");

reportViewer1.ServerReport.ReportPath = reportURL.Text;

Microsoft.Reporting.WinForms.ReportParameter[] param = new Microsoft.Reporting.WinForms.ReportParameter[2];param[0] = new Microsoft.Reporting.WinForms.ReportParameter("RunId", "195900,195904,195711,195707");param[1] = new

Microsoft.Reporting.WinForms.ReportParameter("ReportType", "Summary");

reportViewer1.ServerReport.SetParameters(param);

reportViewer1.RefreshReport();

}

}

}

I was using a textbox to display the url, but you can remove that if you feel it to be necessary. I updated it with your settings.

Report re-opening problem

Hi,

I have created a RDL report and successfully deployed it in reporting server. The following code is used to open the Report.

private void Form1_Load(object sender, EventArgs e){

this.reportViewer1.ProcessingMode = Microsoft.Reporting.WinForms.ProcessingMode.Remote;

this.reportViewer1.ServerReport.ReportServerUrl = new Uri("http://localhost/ReportServer");

this.reportViewer1.ServerReport.ReportPath = "/Import Run Reports/ImportRunReport";

Microsoft.Reporting.WinForms.ReportParameter[] param = new Microsoft.Reporting.WinForms.ReportParameter[2];param[0] = new Microsoft.Reporting.WinForms.ReportParameter("RunId", "195900,195904,195711,195707");param[1] = new Microsoft.Reporting.WinForms.ReportParameter("ReportType", "Summary");

reportViewer1.ServerReport.SetParameters(param);

reportViewer1.RefreshReport();

}

Very first time the Report is opening successfully. Once I close the window and again i am trying to open the report i am getting the following error "The underlying connection was closed: A connection that was expected to be kept alive was closed by the server."

Could you Please help me in this regard.

Dear Ravi,

I had the same issue as you once. I am going to past some code on here that I use for my report viewer.

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Text;

using System.Windows.Forms;

using Microsoft.Reporting.WinForms;

namespace Detail_Report_Viewer

{

public partial class Form1 : Form

{

public Form1()

{

InitializeComponent();

}

private void Form1_Load(object sender, EventArgs e)

{

this.reportViewer1.RefreshReport();

}

private void runReport_Click(object sender, EventArgs e)

{

reportURL.Text = "/Import Run Reports/ImportRunReport";

reportViewer1.ProcessingMode =

Microsoft.Reporting.WinForms.ProcessingMode.Remote;

reportViewer1.ServerReport.ReportServerUrl =

new Uri (@."http://localhost/ReportServer");

reportViewer1.ServerReport.ReportPath = reportURL.Text;

Microsoft.Reporting.WinForms.ReportParameter[] param = new Microsoft.Reporting.WinForms.ReportParameter[2];param[0] = new Microsoft.Reporting.WinForms.ReportParameter("RunId", "195900,195904,195711,195707");param[1] = new

Microsoft.Reporting.WinForms.ReportParameter("ReportType", "Summary");

reportViewer1.ServerReport.SetParameters(param);

reportViewer1.RefreshReport();

}

}

}

I was using a textbox to display the url, but you can remove that if you feel it to be necessary. I updated it with your settings.

Report Recovery Help ASAP!

Report A has been deployed and works fine and ties out in production. The
design copy of this report in VS has been corrupted. All other backups of
this report have been corrupted. How do I get the rdl. for Report A fixed?In report manager click on the report, then properties tab. Click on Edit
link. Give it a directory on your local PC. Different than where you project
is. Then in your project add an exisiting item to the project. It will copy
it over to the directory with all your other rdl files.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"OriginalStealth" <OriginalStealth@.discussions.microsoft.com> wrote in
message news:DFA101E4-26E6-4D14-BD30-05ECE46A2DF1@.microsoft.com...
> Report A has been deployed and works fine and ties out in production. The
> design copy of this report in VS has been corrupted. All other backups of
> this report have been corrupted. How do I get the rdl. for Report A
> fixed?