Ad:

C# Discussion Thread
Unsolved
Views: 2356

Oct 26th, 2009

Extracting report form oracle database

Expand Post »

hi every body

i have a trouble with viewing the report from using the following environments

C# - Crystalreport - Oracle database

i regularly use the basic way to call a view form the database and extract the data form it like that

C# Syntax (Toggle Plain Text)
cmd.commandtext= "Create view  as select * from table1 where icode = '10'";
 
cmd.excutenonquery();
cmd.commandtext= "Create view  as select * from table1 where icode = '10'";

cmd.excutenonquery();

and then create a report depending on this view

and regally connect your report viewer with this view

and its working with viewing the report via crystalreport
it's absolutely good for access database ans SQL server
but i's so bad when dealing with oracle database

when i use this past method i found a messagebox showing tell me that it need the user password in oracle database

so i have a trouble to make instance from my report in c#

i follow the following method but it also doesn't work !!

C# Syntax (Toggle Plain Text)
OleDbConnection cn = new OleDbConnection();
OleDbCommand cmdtest = new OleDbCommand();
OleDbDataReader drrr;
OleDbDataAdapter ad = new OleDbDataAdapter();
DataTable dt = new DataTable();
if (cn.State == ConnectionState.Closed)
{
cn.ConnectionString = "provider=oraoledb.oracle.1;password=123;user id = system;";
cn.Open();
}
DataSet ds = new DataSet();
cmdtest.Connection = cn;
cmdtest.CommandType = CommandType.Text;
cmdtest.CommandText = "select * from doc ";
drrr = cmdtest.ExecuteReader();
drrr.Close();
CrystalDecisions.CrystalReports.Engine.ReportClass ss = new CrystalDecisions.CrystalReports.Engine.ReportClass();
ad.SelectCommand = cmdtest;
ad.Fill(ds, "doc");
ss.ResourceName = "docreport.rpt";
ss.SetDataSource(ds.Tables["doc"]);
crystalReportViewer1.ReportSource = ss;
OleDbConnection cn = new OleDbConnection();
OleDbCommand cmdtest = new OleDbCommand();
OleDbDataReader drrr;
OleDbDataAdapter ad = new OleDbDataAdapter();
DataTable dt = new DataTable();
if (cn.State == ConnectionState.Closed)
{
cn.ConnectionString = "provider=oraoledb.oracle.1;password=123;user id = system;";
cn.Open();
}
DataSet ds = new DataSet();
cmdtest.Connection = cn;
cmdtest.CommandType = CommandType.Text;
cmdtest.CommandText = "select * from doc ";
drrr = cmdtest.ExecuteReader();
drrr.Close();
CrystalDecisions.CrystalReports.Engine.ReportClass ss = new CrystalDecisions.CrystalReports.Engine.ReportClass();
ad.SelectCommand = cmdtest;
ad.Fill(ds, "doc");
ss.ResourceName = "docreport.rpt";
ss.SetDataSource(ds.Tables["doc"]);
crystalReportViewer1.ReportSource = ss;

so if you have any idea what i'm wrong about please tell me

thanks a lot

Similar Threads

calling oracle report from form builder in Oracle
How to connect Oracle database from JSP page in Java
Accessing Oracle Database from Microsoft Word Macro in Visual Basic 4 / 5 / 6
Need help in showing the report on Vb form in Visual Basic 4 / 5 / 6
Need Crystal report calling Oracle forms 10G in Oracle

samehsenosi

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

10 posts
since Sep 2009

Permalink

Oct 26th, 2009

Re: Extracting report form oracle database

It sounds like you need to set the report's connection info for each of the tables. Try passing in the ReportDocument to this after you have set the table parameters, but before attempting to run/view the report:

C# Syntax (Toggle Plain Text)
        public static void ReportSourceSetup(ReportDocument crDoc, ConnectionInfo crConnectionInfo)
        {
            // Each table in report needs to have logoninfo setup:
            Tables crTables = crDoc.Database.Tables;
            foreach (CrystalDecisions.CrystalReports.Engine.Table crTable in crTables)
            {
                TableLogOnInfo crTableLogonInfo = crTable.LogOnInfo;
                crTableLogonInfo.ConnectionInfo = crConnectionInfo;
                crTable.ApplyLogOnInfo(crTableLogonInfo);
            }
        }
        public static void ReportSourceSetup(ReportDocument crDoc, ConnectionInfo crConnectionInfo)
        {
            // Each table in report needs to have logoninfo setup:
            Tables crTables = crDoc.Database.Tables;
            foreach (CrystalDecisions.CrystalReports.Engine.Table crTable in crTables)
            {
                TableLogOnInfo crTableLogonInfo = crTable.LogOnInfo;
                crTableLogonInfo.ConnectionInfo = crConnectionInfo;
                crTable.ApplyLogOnInfo(crTableLogonInfo);
            }
        }

DdoubleD

Reputation Points: 341

Solved Threads: 233

Posting Shark

Offline

984 posts
since Jul 2009

Permalink

Oct 27th, 2009

Re: Extracting report form oracle database

Hi samehsenosi,

Datasource is not specified in the connection string.

Set the data source and try it again.

Ramesh S

Reputation Points: 165

Solved Threads: 113

Posting Pro

Offline

580 posts
since Jun 2009

Permalink

Oct 27th, 2009

Re: Extracting report form oracle database

hi DdoubleD

most thanks about your share
but if you tell me the complete right way for this problem !!!
cause i try to follow your steps but there's something missing in my steps...

so please tell me the whole way to it

thanks a lot

Click to Expand / Collapse Quote originally posted by DdoubleD ...

It sounds like you need to set the report's connection info for each of the tables. Try passing in the ReportDocument to this after you have set the table parameters, but before attempting to run/view the report:
C# Syntax (Toggle Plain Text)
        public static void ReportSourceSetup(ReportDocument crDoc, ConnectionInfo crConnectionInfo)
        {
            // Each table in report needs to have logoninfo setup:
            Tables crTables = crDoc.Database.Tables;
            foreach (CrystalDecisions.CrystalReports.Engine.Table crTable in crTables)
            {
                TableLogOnInfo crTableLogonInfo = crTable.LogOnInfo;
                crTableLogonInfo.ConnectionInfo = crConnectionInfo;
                crTable.ApplyLogOnInfo(crTableLogonInfo);
            }
        }
public static void ReportSourceSetup(ReportDocument crDoc, ConnectionInfo crConnectionInfo) { // Each table in report needs to have logoninfo setup: Tables crTables = crDoc.Database.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table crTable in crTables) { TableLogOnInfo crTableLogonInfo = crTable.LogOnInfo; crTableLogonInfo.ConnectionInfo = crConnectionInfo; crTable.ApplyLogOnInfo(crTableLogonInfo); } }

samehsenosi

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

10 posts
since Sep 2009

Permalink

Oct 27th, 2009

Re: Extracting report form oracle database

Is this what you are looking for?:

C# Syntax (Toggle Plain Text)
        private void RunMyReport(ReportDocument crDoc)
        {
            ConnectionInfo crConnectionInfo = new ConnectionInfo();
            crConnectionInfo.ServerName = "YOUR SERVER NAME";
            crConnectionInfo.DatabaseName = "YOUR DATABASE NAME";
            crConnectionInfo.UserID = "YOUR DATABASE USERNAME";
            crConnectionInfo.Password = "YOUR DATABASE PASSWORD";
 
            // setup before passing to the viewer...
            ReportSourceSetup(crDoc, crConnectionInfo);
 
            crystalReportViewer1.ReportSource = crDoc;
            crystalReportViewer1.Refresh();
        }
        public static void ReportSourceSetup(ReportDocument crDoc, ConnectionInfo crConnectionInfo)
        {
            // Each table in report needs to have logoninfo setup:
            Tables crTables = crDoc.Database.Tables;
            foreach (CrystalDecisions.CrystalReports.Engine.Table crTable in crTables)
            {
                TableLogOnInfo crTableLogonInfo = crTable.LogOnInfo;
                crTableLogonInfo.ConnectionInfo = crConnectionInfo;
                crTable.ApplyLogOnInfo(crTableLogonInfo);
            }
        }
 
// calling...
        RunMyReport(ss);
        private void RunMyReport(ReportDocument crDoc)
        {
            ConnectionInfo crConnectionInfo = new ConnectionInfo();
            crConnectionInfo.ServerName = "YOUR SERVER NAME";
            crConnectionInfo.DatabaseName = "YOUR DATABASE NAME";
            crConnectionInfo.UserID = "YOUR DATABASE USERNAME";
            crConnectionInfo.Password = "YOUR DATABASE PASSWORD";
            
            // setup before passing to the viewer...
            ReportSourceSetup(crDoc, crConnectionInfo);

            crystalReportViewer1.ReportSource = crDoc;
            crystalReportViewer1.Refresh();
        }
        public static void ReportSourceSetup(ReportDocument crDoc, ConnectionInfo crConnectionInfo)
        {
            // Each table in report needs to have logoninfo setup:
            Tables crTables = crDoc.Database.Tables;
            foreach (CrystalDecisions.CrystalReports.Engine.Table crTable in crTables)
            {
                TableLogOnInfo crTableLogonInfo = crTable.LogOnInfo;
                crTableLogonInfo.ConnectionInfo = crConnectionInfo;
                crTable.ApplyLogOnInfo(crTableLogonInfo);
            }
        }

// calling...
        RunMyReport(ss);

DdoubleD

Reputation Points: 341

Solved Threads: 233

Posting Shark

Offline

984 posts
since Jul 2009

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in C# Forum Timeline: Calling a methond

Next Thread in C# Forum Timeline: how to get the row id of the clicked row in a HTML table using c#

DaniWeb Message

Cancel Changes

User Name
Password