VB with Crystal Report Send parameter at run time

[nithya jayaraman]

Hi, pls clarify these questions.

1. How can I send some values of globla variables from VB to
crystal report.
I want to show these values on report.

my database in MS Access


My query is as follows...

invoice table
customer table
purchase table

using this table when user enter the invoice number in textbox and click report button , the report include the particular invoice detail and take over related customer details also...



I want to send this values dynamically from VB(in the event of showing the
report).
If I use parameter field , System is prompting for the value at run
time.
How can I set this automatically?

[hariharanmca]

every thing is okay, but you never point your CR version?

and you are using Inbuild CR or external (Through VB, Calling that CR Rpt File).

[nithya jayaraman]

Hi, pls clarify these questions.

i am using external CR (Call by CR1.printreport )ver 4


1. How can I send some values of globla variables from VB to
crystal report.
I want to show these values on report.

my database in MS Access


My query is as follows...

invoice table
customer table
purchase table

using this table when user enter the invoice number in textbox and click report button , the report include the particular invoice detail and take over related customer details also...



I want to send this values dynamically from VB(in the event of showing the
report).
If I use parameter field , System is prompting for the value at run
time.
How can I set this automatically?
Hi, pls clarify these questions.

1. How can I send some values of globla variables from VB to
crystal report.
I want to show these values on report.

my database in MS Access


My query is as follows...

invoice table
customer table
purchase table

using this table when user enter the invoice number in textbox and click report button , the report include the particular invoice detail and take over related customer details also...



I want to send this values dynamically from VB(in the event of showing the
report).
If I use parameter field , System is prompting for the value at run
time.
How can I set this automatically?

[hariharanmca]

1. Create a DSN Connection in your system.
2. Make sure connection done properly.

then copy below code.

Note : This is only for External Report and Version 9.

'==================== Globel declaration in any Public Module
Public strReportPath As string ' Report Path with Report Name As String
Public StrRecordSelection As String ' Sql Query To Pase from any forum
 
'==============================In Report forum 
Dim crystal As New CRAXDRT.Application      ' LOADS REPORT FROM FILE
Dim Report As New CRAXDRT.Report      ' Declaring REPORT FROM FILE
 
 
Private Sub Form_Load()
On Error Resume Next
'    Setting
    Set crystal = New CRAXDRT.Application           'MANAGES REPORTS
 
    Set Report = Nothing ' Closing previous report
    Set Report = crystal.OpenReport(strReportPath)  ' OPEN New REPORT With String Path
    '------------------------- Opening Database with the help of DSN Connection.
    Report.Database.LogOnServer "pdsodbc.dll", <strDatabaseNameForSqlServer>, <strDSNName>, <strLoginName>, <strPassWord>
    '-------------------------Checking Condition Sql Query is available   
    If StrRecordSelection <> "" Then
        Report.RecordSelectionFormula = StrRecordSelection ' Passing Recored selection query to report
    End If
    Report.DiscardSavedData   ' CLEARS REPORT SO WE WORK FROM RECORDSET
    Cry.ReportSource = Report  ' LINK VIEWER TO REPORT
    Cry.ViewReport ' Show Report
 
    Cry.Zoom 1
 
    Set crystal = Nothing
 
    StrRecordSelection = "" ' Clear Query in globel variable
    strreportpath = ""      ' Clear Report Path in globel variable
End Sub