Skip to Content
0
Former Member
Feb 28, 2011 at 10:39 AM

Crystal Report Oracle Logon Problem

75 Views

Hi,

We are using Webforms for launching the reports. When we tried to launch the reports system is prompting for logon information. It states "The report you requested requires further information." followed by text box having Server Name, Database Name, User Name, Password and use integrated security(checkbox).

We are using Oracle backend for connecting the database. Crystal Report RPT is designed using the OLEDB ADO (Database Type) and the provider is u201CMSDAORAu201D.

The same report is working fine when the Internet service manager identity is set as u201CLocal Systemu201D reported problem occurs when the identity is set as u201CNetwork Serviceu201D. How to over come this issue.

Crystal Version : Crystal Reports 2008 is installed

Operating System : Windows server 2003 standard edition

Oracle Version : Oracle 11g

Please Note : Report is fetching data from the crystal report designer in the preview. There is no problem in oracle connectivity.

Code is available below

rpt.Load(@"D:\report\totaldetails_sub_sp_oracle.rpt");

CrystalDecisions.CrystalReports.Engine.Database crDb;

CrystalDecisions.CrystalReports.Engine.Tables crTables;

CrystalDecisions.CrystalReports.Engine.Table crTable;

TableLogOnInfo crTableLogOnInfo;

ConnectionInfo crConnInfo;

crDb = rpt.Database;

crTables = crDb.Tables;

crConnInfo = new CrystalDecisions.Shared.ConnectionInfo();

crConnInfo.ServerName = "< Oracle Service Name>";

crConnInfo.DatabaseName = "";

crConnInfo.UserID = "<Oralce User Name>";

crConnInfo.Password = "<Oracle Password>";

for (int i = 0; i < crTables.Count; i++)

{

crTable = crTables<i>;

crTableLogOnInfo = crTable.LogOnInfo;

crTableLogOnInfo.ConnectionInfo = crConnInfo;

crTable.ApplyLogOnInfo(crTableLogOnInfo);

}

CrViewer.ReportSource = rpt;