.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

IE cannot display the webpage during report execution

Posted By:      Posted Date: August 31, 2010    Points: 0   Category :Sql Server
Hi. I have a problem with a report having some T-SQL and MDX queries. When I execute it during the working hours I have an error about that Internet Explorer cannot display the web page, but in the other hours the execution is completed successfully. I have a look inside RS log but I cannot find any errors; no timeout is set about report execution inside the Report Manager. Any ideas to solve this issue, please? Many thanks

View Complete Post

More Related Resource Links

Cannot Display Image in Report


 I have a report using an image control that needs to display an image inside subfolder "Images\InstitutionLogos\".

On properties of image control i have the following properties set:

MIMEType= "image/png"

Source      = Database

Value        ="\Images\InstitutionLogos\" +Fields!InstitutionID.Value+".png"

Inside subfolder "Images\InstitutionLogos\" each image is named with a number which represents Fields!InstitutionID.,(ex, 1.png, 2.png, 10.png)

However, when i run the report the image just displays an X, what am i missing?

How to display related tables in one crystal report and how to link this report with combobox?


Hi! I want to display a crystal report in my vb.net application. Suppose I have tables named student details, student marks, student address, etc... Now if I want to display all these details (fields of all tables) in one crystal report (with page breaks if necessary) then how will I achieve it. I will be providing a combo box in my application that contains list of student names. How can I link this combo box with the cystal report to dynamically display report for different student on selected index change of combo box? Help me friends. An example would be appreciable.

Display multivalue data in crystal report


i Want to show data for single employee like this like this

Emp Id : xyz

Emp Name : abc


Child name      Date of birth     education

abc                     12/12/2000    o levels

Microsoft Report Viewer control to display data on one page


Hello everyone,

I am wondering if the Microsoft Report Viewer control allows for display changes.  Say for instance a user wants would like to see all the data requested then another time would like to toggle thru the pages of infomation.  So does anyone know if the control allows for display changes from complete view to paginated viewing.  I am using MS VS 2008 with ASP.NET 3.0.  Thanks for your response.


Silverlight gives the error "Internet Explorer cannot display the webpage"

Hello, I'm new to SharePoint 2010.  I have an SP2010 environment up and running.  When I click on a link that activates Silverlight, I get an error that reads "Internet Explorer cannot display the webpage".  The Server is on a different domain. When I use remote desktop to access the server, I can open up the same link using IE and I can see the content no problem. An example would be from the calendar page.  If I choose a date and select 'add', the browser fades and I see a 'loading' screen.  Then the next screen I get the error.  If I follow the same process on the server using remote desktop, everything works. What could the problem be?

T-sql help !!!!! in order to display those extra rows in report....

SiteName SiteID RptSeq     ReportLabel Amount ReconYear     ReconMonth SanAntonioTX 43    1        Aging Prior Month 4763943 2010     8 SanAntonioTX 43 2   Invoices 1542323 2010      8 SanAntonioTX 43 3 Credit Memos -8081.31 2010      8 SanAntonioTX 43 4 Cash Collected - Invoices and Payment on Account -1883460 2010      8 SanAntonioTX 43 5 Katz I/C Payments -174310 2010      8 SanAntonioTX 43 6 NSFs -250 2010           8 SanAntonioTX 43 8 Aging Current Date Selected 4245716 2010      8 Hi My table has these values I need a row where it takes the sum of amount where rptseq <> 8 and rest of ther columns will be same and report label would be SUmOfAmount and there should be another column which wuld be amount of new added row - last row amount where rptseq =8 so these rows i need how is it possible..... please its urgent !!!!!!! if anyone needs extra description please feel free to ask me...

"Internet Explorer cannot display the webpage" from IE7 - ASP.NET Development Server Error?

Dear everybody, I've just installed Microsoft Visual Studio 2008 on Windows Vista Ultimate. I created "New Web Site" and Started Debugging the page to see the blank page rendered. To my surprise, IE 7.0 displayed an error message saying: "Internet Explorer cannot display the webpage". I spent some time investigating and here is the result: The page going to be rendered assumes port 49791: http://localhost:49791/WebSite3/Default.aspx The ASP.NET Development Server operates under different port no: 49793 After changing the url above manually to use the port of ASP.NET Development Server, the webpage gets renderred correctly: http://localhost:49793/WebSite3/Default.aspx ASP.NET Development Server uses dynamic ports. I noticed that Debugging process always assumes port number lower by 2 than the real port number of the ASP.NET DevSer. Therefore Debug process never runs and displays the page. I do not want to manually edit the local host URL after every page rebuild, so my question is following: How to make the "Start Debugging" function to use appropriate port of the ASP.NET Development server? How to make Visual Studio to open the page being debugged? To mention couple of things I tried: I reinstalled Visual Studio2008, tried to disabled IPv6 as some threads recommen

Snapshot report with matrix sometimes does not display data ... rerun report and it does

Hi All, I am having a strange problem with a snapshot report that is scheduled through Report Manager and runs once a day at approximately 18:30 each evening. The report contains a column chart with a textual category, numeric data, and a date series. Above the chart, is a matrix containing the value of the last bar in each series, and the average value of all bars in the series.  Here's a screen capture of what the report looks like: http://img832.imageshack.us/img832/185/wipu.png The problem is that sometimes the matrix is missing.  The chart still displays properly and all the data is correct.  If I rerun the report manually, and save a new snapshot, the matrix re-appears. For the past 6 months this report has been running flawlessly.  In the past 3 weeks, the problem has occurred twice.  I don't know why. Why would the matrix disappear?  What is causing this, and how can I fix it?  Any ideas? I'm using SSRS 2008. Thanks in advance for any insights. Regards, --DanDJAnsc

Display current time (live?) on report?

Is it possible on a report to display a clock showing the current time, ticking? Or, is it possible to display a static picture of an analog clock? I have the current time with an expression, but would love to have it updating real time. Any luck with javascript or anything?

Changes in the values of controls of .cs file not reflecting on .aspx webpage while execution.

In my code I am assigning certain values to labels from data reader.While debugging I can see that proper values are assigned but the changes are not reflecting in the end of debug on the webpage that are executing.// My Code// Question.aspx.csusing System;using System.Collections;using System.Configuration;using System.Data;using System.Linq;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.HtmlControls;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Xml.Linq;using System.Data.SqlClient;public partial class Examinee_Question : System.Web.UI.Page{    ExamFunctions ef = new ExamFunctions();    SqlConnection con,con1;    SqlCommand cmd,cmd1;    SqlDataReader dr,dr1;    String QType="";    int ctr = 1;    protected void Page_Init(object sender, EventArgs e)    {        con = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Db.mdf;Integrated Security=True;User Instance=True");        con.Open();        con1 = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Db.mdf;Integrated Security=True;User Instance=True&qu

Job Execution times / statistics report ...

We have several sites (countries if you may call them) and each site has its own set of ERP databases (Progress database). We have designed ETL layers that are open and which can be invoked for each of these sites. On top of the ETL layers, we scheduled the SSIS packages via SQL jobs for each site and scheduled them to run at various times of the day based on the site operating hours. I want to now present the amount of time it takes to copy data from the ERP system into our SQL 2008 Staging and finally into our DataWarehouse. I can manually right click on the SQL jobs and get the timings, however, I want to automate this report so that we can look at it initially weekly and maybe monthly when things start to run smoothly. Any pointers or ideas? I know I can run SQL Profiler and capture the SQL behind this report, would it actually work? ThanksJagannathan Santhanam

Display an SSRS Report Part on web form

I have a Report Part created on my 2008 SSRS Server.Can I use a Report Viewer to display that part? Or do I have to add that to a report and then display the report? I'd rather not create a report.Any advice is appreciated.

How to display middle value in a RDLC report where count equals 3?

I'm currently using an RDLC report and ReportViewer control to display a report to the user. The report needs to be formatted in a certain way so just creating a table and iterating through won't work. My database is set up to be pretty normalized. For example, two tables I have are a "PersonalData" table with a ID and a "PhoneNumbers" table with a ContractorID that relate to the first table. The "PhoneNumbers" table has essentially two columns of data: Number and Type. Each contractor in the PersonalData table can have multiple phone numbers (home, cell, work, etc.). I'm also passing the ContractorID into the report so I know which records to grab. On the report, I need to display each phone number in a separate text box layed out like so:Home Phone: (555) 555-5555             Cell Phone: (444) 444-4444    Daytime/Local Phone: (333) 333-3333   E-Mail Address: me@somewhere.com  The records are inserted in the database in the following order: Home, Cell, Daytime/Local. I can grab the home phone since I know it will always be the first record in the database (required field) by using:=First(Fields!Number.Value, "DataSet1_PhoneInformation")  And either the Daytime/Local or Cell depending on the element count by using the Last() function. The problem is grabbing and displayi

how to display matrix report with default zero when we are not having data related to it in database

Hi, I am having a matrix report in SSRS 2005 which is parameterized.When I select parameter which is having related data in the database report is working well.But When I select a parameter for which data is not present in database at that particular time.I donot see the matrix on report .So can any one suggest me how to show the matrix report with zeros in data region when user select that parameter   Thanks in advance.

Report Builder 3 - how to display paths that exceed a hemisphere in a map layer



Does anyone have any novel workarounds for displaying geospatial path/line data in a report that exceeds a hemisphere in size. I would like to display path data for vehicles that traverse the globe in a geography map, i.e. satellite, plane or ship paths. One idea is to break the line path into smaller segments based on a time box such as an hour/week or perhaps there's a way to present a point map layer in Report Builder as a connected line? 

Any ideas/suggestions welcome.

Thanks in advance


Issue - The report execution has expired or cannot be found. (rsExecutionNotFound)


Hello Experts,

I am running a huge SSRS 2008 report (that returns 2 million records) and it gets rendered sometimes and sometimes it gives me an error,

"The report execution <some string> has expired or cannot be found. (rsExecutionNotFound)”.

When I see SQL Server log after this issue comes I see following message there;

"A significant part of sql server memory has been paged out. This may result in performance degradation. Duration: 300 seconds. Working set(KB): 97672, memory utilization 42%"

IMPORTANT point to note here is when I am running reports with 1 million records or smaller than that, then I am able to execute them successfully without any issue.

I am using SSRS 2008 64 bit, Win Server 2003 64 bit. RAM is 8GB.

Please help me to know what are these issue, are these two issues related and how to fix it?


Multiple report execution is not in parallel


Hi everybody,

I experienced an issue with Sharepoint Foundation 2010. (Server 2008 and Sharepoint Foundation 2010 64bit)

When I use multiple Reportviewer Web parts on one page, the rendering (and most likely the Query itself) is not executed in parallel, i.e. every web part waits for its predecessor to finish.

I made two screenshots to show the difference in behavior (both are on the exact same hardware)

Sharepoint 2010 (Total execution Time 32 sec) : http://img807.imageshack.us/img807/6712/sp2010.jpg

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend