Database Logon

[organickarma]

Hi,

I am trying to integrate crystal reports xi into a VB .NET desktop app. I am using VS2005.

The issue I am running into is each time I run a report from the app it asks for the database logon credentials.

I have tried using the

MS driver for oracle and the OLE DB driver

The userid and password are passed throught the default conncection string created when the database connections are specified in Visual Studio

I know my question seems kinda unclear but if anybody has any kind of suggestion please help me here

Thanks

 

[tbojoe]

Hello,

Have you found an answer to this issue? I am experiencing the same problem. Just wanted to know if you were able to solve it.

 

[hilfy]

You need to set the login as part of your code prior to opening the report.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.

 

[tbojoe]

Hilfy,

How do you go about this process? where do you at the code for the credentials. In the report viewer or the VB form? Please help this confused user.

 

[hilfy]

Here's the code that we use (our Code-Behind is in C#, but you should be able to translate to VB...):

Main procedure that lodes the report:

    CrystalDecisions.Shared.ConnectionInfo connectionInfo = new CrystalDecisions.Shared.ConnectionInfo();

    connectionInfo.ServerName = qServer;
    connectionInfo.UserID = qUserID;
    connectionInfo.Password = qPW;

    // set report connection for main report
    SetDBLogonForReport(connectionInfo, crReport, qServer);
    // set report connection for any subreports
    SetDBLogonForSubreports(connectionInfo, crReport, qServer);

SetDBLogonForReport:

 private void SetDBLogonForReport(CrystalDecisions.Shared.ConnectionInfo connectionInfo, ReportDocument reportDocument, string qServer)
  {

    Tables tables = reportDocument.Database.Tables;
    foreach (CrystalDecisions.CrystalReports.Engine.Table table in tables)
    {
      TableLogOnInfo tableLogonInfo = table.LogOnInfo;
      tableLogonInfo.ConnectionInfo = connectionInfo;
      table.ApplyLogOnInfo(tableLogonInfo);
    }
  }

SetDBLogonForSubreports:

private void SetDBLogonForSubreports(CrystalDecisions.Shared.ConnectionInfo connectionInfo, ReportDocument reportDocument, string qServer)
  {
    Sections sections = reportDocument.ReportDefinition.Sections;
    foreach (Section section in sections)
    {
      ReportObjects reportObjects = section.ReportObjects;
      foreach (ReportObject reportObject in reportObjects)
      {
        if (reportObject.Kind == ReportObjectKind.SubreportObject)
        {
          SubreportObject subreportObject = (SubreportObject)reportObject;
          ReportDocument subReportDocument = subreportObject.OpenSubreport(subreportObject.SubreportName);
          SetDBLogonForReport(connectionInfo, subReportDocument, qServer);
        }
      }
    }
  }

Note that you have to set the log in info for each table in both the main report and each subreport.

The basis for this code was found on the Business Objects Developer Library website at [URL unfurl="true"]http://devlibrary.businessobjects.com/BusinessObjectsXIR2/en/devsuite.htm[/url].

-Dell



A computer only does what you actually told it to do - not what you thought you told it to do.