Current Position:Home > Crystal Reports 2010 SP1 on IIS 7.0 - Report is not being displayed

Crystal Reports 2010 SP1 on IIS 7.0 - Report is not being displayed

Update:10-11Source: network consolidation
Advertisement
Hi,
Finally, the keycode assembly, BusinessObjects.Licensing.KeycodeDecoder.dll error is gone, after I installed Crystal Runtime 2010 SP1. Also, I tested Crystal Report 2010 SP1 on my Windows 32 application and I can tell that I do not have this error anymore and report is being displayed properly.
But Crystal Report is not being displayed on ASP.NET page on MS Server 2008 standard edition SP2 with IIS 7.0. Database resides on iSeries remote machine.
The MS Server 2008 is virtual machine.
OS system has:
Crystal Report Basic Runtime for Visual Studio 2008
SAP Crystal Reports Runtime engine for .NET Framework 4 (32-bit)
Simply the report is not being displayed at all. No errors are being recorded in the Event Viewer.
Nothing happens; excerpt the page is Loadingu2026 and Waiting for u2018website nameu2019 in the left lower corner of Firefox web browser.
Here is the code behind aspx page with a command button - very simple:
using CrystalDecisions.CrystalReports.Engine;
using CrystalDecisions.Shared;
protected void Button1_Click(object sender, EventArgs e)
ReportDocument crReportDocument;
Database crDatabase;
Tables crTables;
// CrystalDecisions.CrystalReports.Engine.Table crTable;
TableLogOnInfo crTableLogOnInfo;
ConnectionInfo crConnectionInfo;
crConnectionInfo = new ConnectionInfo();
//Set server name
crConnectionInfo.ServerName = this._strServerName;
//set database name
crConnectionInfo.DatabaseName = this._strDatabaseName;
crConnectionInfo.UserID = this._strUserID;
crConnectionInfo.Password = this._strUserPassword;
//Set integrated security
crConnectionInfo.IntegratedSecurity = false;
crReportDocument = new ReportDocument();
crReportDocument.Load(Server.MapPath("~/crystal-reports/TransformerLoad/TransLoadMonthlyMax.rpt"));
crDatabase = crReportDocument.Database;
//Set all tables from current report file
crTables = crReportDocument.Database.Tables;
//crTableLogOnInfo.ConnectionInfo = crConnectionInfo;
//Apply schema name to the table's location
foreach (CrystalDecisions.CrystalReports.Engine.Table _crTable in crTables)
crTableLogOnInfo = _crTable.LogOnInfo;
crTableLogOnInfo.ConnectionInfo = crConnectionInfo;
_crTable.ApplyLogOnInfo(crTableLogOnInfo);
//Check if database table name starts
if (_crTable.Location.StartsWith("XFMRSMAX", StringComparison.CurrentCulture) ||
_crTable.Location.StartsWith("XFMRSMIN", StringComparison.CurrentCulture))
//_crTable.Location = this._strSchemaName + "." + _crTable.Location.Remove(8) + Convert.ToInt32(Request.QueryString\"ReportYear\");
_crTable.Location = "XFMRSMAX09";
else
_crTable.Location = _crTable.Location;
this.CrystalReportViewer1.ReportSource = crReportDocument;
This code runs on my development machine Win XP SP3
OS system has:
Crystal Report Basic Runtime for Visual Studio 2008
SAP Crystal Reports Runtime engine for .NET Framework 4 (32-bit)
This code also runs on another development server - Windows XP SP3 (IIS 5.1)
OS system has:
Crystal Report Basic Runtime for Visual Studio 2008
SAP Crystal Reports Runtime engine for .NET Framework 4 (32-bit)
ispnet_client folder has IUSR user and this user has read permissions to this folder. I even tried to change the permissions to Read & Execute.
I am developing my reports using Crystal Reports 2008 SP2.
Any help would be greatly appreciated.
Serghei

The Best Answer

Advertisement
Hi Ludek,
Thank you for your response.
I checked the web.config file, all http handlers are there. I think the handlers are required to render the images on crystal report viewer but in my case the report viewer is not being rendered.
I have to questions:
1. What exact folders should be under aspnet_client\system_web?
In my case I have structure like this
aspnet_client\system_web\2_0_50727\crystalreportviewers13
aspnet_client\system_web\4_0_30319\crystalreportviewers13
Should I have folders something like this
aspnet_client\system_web\2_0_50727\crystalreportviewers13_1
aspnet_client\system_web\4_0_30319\crystalreportviewers13_1
after I installed Crystal Reports 2010 SP1
Also, in C:\Program Files\SAP BusinessObjects\Crystal Reports for .NET 4.0\Common\Crystal Reports 2011\ there is no folder named as crystalreportviewers13 but instead crystalreportviewers
a.     Should I copy all files from this folder to aspnet_client\system_web\2_0_50727\crystalreportviewers13, or
b.     Should I copy all files from this folder to aspnet_client\system_web\2_0_50727\crystalreportviewers13 and rename this folder to
crystalreportviewers
2. Can you explain how to get a data report?
This is the quote from your previous answer
I'd be interested to see this simplified to a saved data report - no DB logon code - as a test...  
Thank you Serghei
  • Crystal Reports 2010 SP1 on IIS 7.0 - Report is not being displayed Update:10-11

    Hi, Finally, the keycode assembly, BusinessObjects.Licensing.KeycodeDecoder.dll error is gone, after I installed Crystal Runtime 2010 SP1. Also, I tested Crystal Report 2010 SP1 on my Windows 32 application and I can tell that I do not have this erro

  • IE11 - Crystal Reports - PrintMode ActiveX now displaying PDF prompt (instead of printer prompt) Update:10-11

    I asked this question over at stackoverflow and am now taking it here: http://stackoverflow.com/questions/20672254/ie11-crystal-reports-printmode-activex-now-displaying-pdf-prompt-instead-of It's a simple straight-forward question.  IE11 is breaking

  • Visual Studio 2013 Crystal Report V9 does not display in browser Update:10-11

    Hello, I work with Visual Studio 2013, and was anxious for version 13.0.9.1312, glad you came. Well I installed the full version and the report usually opened in VS, but when it does not compile command displays. Published in a local and it worked, b

  • Crystal report viewer 13 are displaying blank page after deploying in web server Update:10-11

    Dear friends, i have designed crystal report (in VS2012 &  CRRuntime_32bit_13_0_8 installed in web server) it's working fine in machine VS2012, but when deploying in web server (Windows Server 2008 R2 64bit) it's getting blank page. I have read the h

  • Crystal Report Toolbar images not displaying properly in IE? Update:10-11

    Hi, I am using VisualStudio 2012 ,crystal report version 13.0.2000.0 and sp5. My problem is that after loading crystal report, toolbar image icons (such as print,export etc) are not showing properly in internet explorer(version ie10). But it is displ

  • Crystal Report 9 - Can't Display UTF-8 Data Update:10-11

    Dear Sir, I am using PHP with Crystal Report 9.2 and has problem displaying UTF-8 data from MSSQL field. It shows weird characters instead. I am very sure the data stored in database is in UTF-8 because when I ouput it into the web browser with encod

  • Crystal Report V9 do not display decimal value HELP! Update:10-11

    <p>I have a field in Informix data type is Decimal(6,2)</p><p>when i used the field in the report, the decimal is not displayed</p><p>example: field1 = 305.50, in crystal report it only displayed 305.00, already setup the for

  • Open programatically Crystal Report Viewer XI to display rpt file Update:10-11

    Thank you in Advance!!!    I got the following VBA code. 1) What library do I need to include to access Crystal Report Viewer XI? 2) How do I declare CRViewer11 to open Crystal Report Viewer XI and a created report?     Please look at ***???     Dim

  • Crystal Reports 9 - Need to Display Spanish Text Update:11-30

    Post Author: Zando CA Forum: General I need to display Spanish text (...accented words, upside down question marks, tildes' over the 'N's, etc...) in Crystal reports 9. The text is coming from an Oracle database that has been updated to an 8-bit char

  • Crystal Report for Enterprise not displaying Long Text from BEx Update:11-30

    Hello, I am creating a report using SAP Crystal Report for Enterprise 4.0 (Version 14.0.2) and the source of data is BEx query via OLAP connection created using IDT. I am using SAP BusinessObjects BI platform 4.0. The Characteristic (which is hierarc