Crystalreport compatability issue fixing

when you create reports with using crystalreport(old version of 8.5), there may be connection issue will come to connect sql2005. you have to run this script to solve this kind of problem.

EXEC sp_dbcmptlevel yourdbname, 80;

how to pass parameter values for crystal report 8.5 in vb6

Public crxApplication As New CRAXDRT.Application
Public CrxReport As New CRAXDRT.Report
Dim CrtParameters As CRAXDRT.ParameterFieldDefinitions
Dim CrtParameter As CRAXDRT.ParameterFieldDefinition


Private Sub PrintReport()
Dim ReportName As String
Dim i As Integer
Dim cParmValue As String
cParmValue = "Me kiep"
ReportName = App.Path & "\RPT\BillControlZ.rpt"
Set CrxReport = crxApplication.OpenReport(ReportName, crOpenReportByTempCopy)
Dim CRTABLE As CRAXDRT.DatabaseTable
i = 1
For i = 1 To CrxReport.Database.Tables.Count
Set CRTABLE = CrxReport.Database.Tables.Item(1)
CRTABLE.SetLogOnInfo gODBCName, gDBDatabaseName, gDBUserName, gDBPassword
Next i


CrxReport.EnableParameterPrompting = False
Set CrtParameters = CrxReport.ParameterFields
For Each CrtParameter In CrtParameters
If CrtParameter.Name = "?strTemp" Then
CrtParameter.AddCurrentValue cParmValue
End If
Next CrtParameter


CRViewer1.Visible = True
CrxReport.DisplayProgressDialog = True
CrxReport.VerifyOnEveryPrint = True
''CrxReport.UseIndexForSpeed = True
''CrxReport.SQLQueryString = strSQL & " order by SalePoint "
CRViewer1.ReportSource = CrxReport
CrxReport.VerifyOnEveryPrint = True
CrxReport.DiscardSavedData
CRViewer1.DisplayGroupTree = False
CRViewer1.ViewReport
CRViewer1.ShowFirstPage
CRViewer1.Zoom 100
Screen.MousePointer = vbDefault
cmdView.Visible = True
cmdPrinter.Visible = True
End Sub

original link
http://www.developerfusion.com/forum/thread/28348/

Dynamic login info to Crystal report : C#

using System;
using System.Windows.Forms;
using CrystalDecisions.CrystalReports.Engine;
using CrystalDecisions.Shared;

namespace WindowsApplication1
{
  public partial class Form1 : Form
  {
      public Form1()
      {
          InitializeComponent();
      }

      private void button1_Click(object sender, EventArgs e)
      {
          ReportDocument cryRpt = new ReportDocument();
          TableLogOnInfos crtableLogoninfos = new TableLogOnInfos();
          TableLogOnInfo crtableLogoninfo = new TableLogOnInfo();
          ConnectionInfo crConnectionInfo = new ConnectionInfo();
          Tables CrTables ;

          cryRpt.Load("PUT CRYSTAL REPORT PATH HERE\CrystalReport1.rpt");

          crConnectionInfo.ServerName = "YOUR SERVER NAME";
          crConnectionInfo.DatabaseName = "YOUR DATABASE NAME";
          crConnectionInfo.UserID = "YOUR DATABASE USERNAME";
          crConnectionInfo.Password = "YOUR DATABASE PASSWORD";

          CrTables = cryRpt.Database.Tables ;
          foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables)
          {
              crtableLogoninfo = CrTable.LogOnInfo;
              crtableLogoninfo.ConnectionInfo = crConnectionInfo;
              CrTable.ApplyLogOnInfo(crtableLogoninfo);
          }

          crystalReportViewer1.ReportSource = cryRpt;
          crystalReportViewer1.Refresh();
      }
  }
}

Crystalreport Tutorials' Sample Code Directory

Tutorials' Sample Code Directory

In this online help, the tutorials provide detailed step procedures that guide you through the completion of complex tasks. The tutorials are also available as completed sample code. See Tutorials.

If you have installed Crystal Reports with the default settings and file paths, sample code is in the directories shown below.

Crystal Reports version	Path to tutorials' sample code
Crystal Reports 11	C:\Program Files\Business Objects\Crystal Reports 11\Developer Files\Help\En\CR_NET_SDK_Tutorial_Sample_Code.zip
Crystal Reports for Visual Studio 2005	C:\Program Files\Microsoft Visual Studio 8\Crystal Reports\Samples\en\Code\TutorialSampleCodeProjects.msi
Crystal Reports Basic for Visual Studio 2008	C:\Program Files\Microsoft Visual Studio 9.0\Crystal Reports\Samples\En\Code\