Visual Basic :: Passing Parameter In VB6 To Crystal Report

Passing Parameter To A Crystal Report
i'm using vb6 and crystal reports 8.5. i have a string value that i need to pass to my rpt. here is the sample of my code:

Set CRReport = New CRAXDRT.Report
Set CrxApp = CreateObject("CrystalRunTime.Application")
Set CRReport = CrxApp.OpenReport(vstrReportFile)
CRReport.Database.SetDataSource vPassedADORS, 3, 1
CRViewer1.ReportSource = CRReport
CRReport.ParameterFields(0) = " Par1;" + vstrParameters + " ;true"
CRReport.PrintOut False, 1, True

when i run this code i get the error subscript out of range.

when i create another project that uses the crystal report component i use the following code:

cry1.ParameterFields(0) = " Par1;" + vstrParameters + " ;true"
cry1.printreport

it works fine.

can any one help?

Thank You,
Thomas

Parameter Passing In Crystal Report
I have designed a report in Crystal report 7.0 and wanted to view it thru VB6.0 application. I am using crystal report control. When I refresh my report from crystal report and enter a specific date the report generates for that date but when I refresh it from my VB application and enter any date its not giving anything. Do I need to set some property or something else. please help me. its very urgent.

Kirti

Passing Parameter To Crystal Report
i'm using the CRViewer to view my report. i found out i cannot pass in Date into crystal report from VB. any one can give me help?

sample code:
CrxReport.ParameterFields(1).AddCurrentValue (format(now,"dd/mm/yyyy"))

the parameter in crystal report defined as Date.

thanks.

Parameter Passing In Crystal Report
I am passing parameters to report ,but it is giveing me error "invalid Field ".
do each field have any specific index,or number in the report .I have designed the report already.

Passing Parameter To Crystal Report
i am passing a string value from vb code to crystal report. in crystal report i have created this parameter as "Pyyyymm" receiving string value.

the vb code goes like this

report1.parameterfields(0) = "Pyyyymm;" & m_SelSalMnth & ";true"

where m_SelSalMnth contains '2002/10' or like value but it gives me error "can't find SQL Server" and error no. 20599.

i don't know where i am going wrong.

i am adding crystal report thru component and not thru reference i.e. i am using a crystal report control.

Waiting for a quick reply.

diamond

Problem Passing Parameter IN Crystal Report From Vb 6.0
WEll hi to all

I am new user here.........I really need help in my project

My problem is that i have made a project in Vb6.0 and database in Ms Access

Now i make report in Crystal report 9 and by using Wizard Expert

now what i want to do is i want to pass parameter by using my own design
form in Vb6.0 like i want to pass account no so it will display only the result of that account no i don't know that code exactly and please tell me do i need to use parameter option in crystal report or just pass parameter from Vb from

i will really thankful to those people who help me out in this regard

Sorry for poor english

Passing The Parameter To Crystal Report Using ParameterFieldDefinitions
Hi everyone,

I am get the error in assigning the value to the parameter of parameter1 in crystal reports. It is the string parameter type .I tried with setcurrentvalue and also addcurrentvalue mothod. But i can't able to pass the parameter.

Even though i am using
crRepp.EnableParameterPrompting = False
it prompting for the parameters values......

CrystalReport1 is ICRDesigner object

Dim Report As New CrystalReport1
Private Sub Form_Load()
Dim crApp As New CRAXDRT.Application
Dim crRepp As CRAXDRT.Report
Dim crParamDefs As CRAXDRT.ParameterFieldDefinitions
Dim crParamDef As CRAXDRT.ParameterFieldDefinition
Dim crDBTab As CRAXDRT.DatabaseTable

'Open report file
Set crRepp = crApp.OpenReport(App.Path & "ReportTest.rpt")
'Set location of database based on WhatCompany

crRepp.Database.LogOnServer "p2sodbc.dll", "Testpass", "Northwind", "sa", ""
'Set table location to appropriate company server

For Each crDBTab In crRepp.Database.Tables
crDBTab.SetLogOnInfo "Testpass", "Northwind", "sa", ""
Next
crRepp.DisplayProgressDialog = False
crRepp.EnableParameterPrompting = False

'Fill report parameters
Set crParamDefs = crRepp.ParameterFields
For Each crParamDef In crParamDefs
Select Case crParamDef.ParameterFieldName
Case "Parameter1"
crParamDef.AddCurrentValue "eeeeee"
End Select
Next

DoEvents
CRViewer1.PrintReport

Screen.MousePointer = vbHourglass
CRViewer1.ReportSource = Report
CRViewer1.ViewReport
Screen.MousePointer = vbDefault
End Sub

pls help me to come out the problem
Advance thanks

regards
Tamil

Problen In Crystal Report 8 On Parameter Passing
Dear Group Members

Need some help !

I have created a crystal report 8 name as Report1.rpt, I have alsoinserted a parameter field as NAM in this report, Than I have createda form in Vb6 and put a command button on this form and the code haswritten on this command event as

CrystalReport1.ReportFileName = "C:engg
eport1.rpt"
CrystalReport1.ParameterFields(1) = "NAM;INDORAMA;TRUE"
CrystalReport1.Action = 1

The backend is oracle and have aslo setted the Odbc as Cror7 or Cror8

When I run this form and click on command button then a erroroccurs like

Run time error 20599
Can not open sql server

If I not use the parameter field NAM then this for is work properly

I am not getting that I am not using the Sql server then why it isdisplaying this error

I will be highly oblige if any one will send the solution at earliest

Regards

Dk Varshney

Passing Parameter To Crystal Report (SubReport)
Hi
I have a report and subreport in crystal report. I am able to pass parameter to report but it doesn't work for subreport. I am not sure if there is any method available for this purpose. Any help would appreciate?

Here is my code to passing information to main report

CrxReport.ParameterFields.GetItemByName("SectionName").AddCurrentValue "Business - Solution"

I try to use the same mothod for passing DATE to subreport but I was not successful

Passing Parameter From Text Box To Crystal Report Designer (RDC)
I am new to Crystal Reports. I earlier used Microsoft Data Report but it didnot have the 'Record Number' feature , so I have to re create my reports in Crystal Reports.I am using crystal report 8 designer control ( RDC) for my project on Payroll . I want to create a report which will generate the report based on the month & year.

I have a form containg two combo boxes from where the user will select the month & the year.

I want to pass this to Crystal Report Designer as a parameter.

I used the following query in data report.

select p.empno,e.fname, p.bsal,p.itax,p.netsal,p.mnth,p.yr from emp e, payroll p where e.empno=p.empno and p.mnth= ? and p.yr= ?
order by p.bsal

I used to pass the value for p.mnth & p.yr using the following code in a form which contained the text boxes.

[vbtemp]
option Explicit

Private Sub Command1_Click()
deConsolidated.Command1 cmbMonth.Text, cmbYear.Text
drConsolidated.Show
End Sub

[/vbtemp]

Pls guide me how to pass the parameters from the above combo box to crystal report designer ( RDC)

Thanking you,
Rgds,
Dennis.

Passing Parameter To Crystal
Hey,
I have an application developed with Visual basic 6 and Crystal Reports 9.
I am trying to pass a parameter to a crystal report and just can't seem to get it right.
I am opening the report (the report opens well but loads the saved data in the report) with the following code:

Code:
Module1.OpenDatabase

Dim s_myNumber As String
s_myNumber = Me.txtPurchaseOrderNumber.Text

Dim s_sql As String
sql = "...............WHERE 'POR_PURCHASE_ORDERS'.'ORDER_NUMBER'='" & s_myNumber & "'"

Dim rst As New ADODB.Recordset
rst.Open sql, conn

If Not (rst.EOF) Then
Dim myReport As New CrystalReport1
myReport.Database.SetDataSource (rst)

Dim frm As New Form2
frm.Show
frm.CRViewer91.Refresh
frm.CRViewer91.ReportSource = myReport
frm.CRViewer91.ViewReport
End If
Screen.MousePointer = vbNormal
The parameter "OrderNo" is set to "equal to 0000033960" in the report. What I want to do is pass my own parameter from VB6 and I do not want the pop-up screen that asks for the parameter value to show.

Hope you can help
Thanks

Passing A Parameter To A Crystal Rep
Greetings Babu,
I am using a dataset that consists of a SQL Server Stored procedure with a parameter, I would like to have a bottun on a windows form in my C# app that the user would press to pass in a param, do you know how I can pass in a param to my crystal report? EVerytime I add a param, and run my app, this dialog box pops up and asks for the parameter, i don't want this to happen because I want my text field to take care of passing hte param in? Could you provide any advice?

Thanks!!!
The TreeofWoe

Crystal Reporting And Parameter Passing
I know that it is possible to pass runtime parameters to Crystal. I was just wondering how one would do it a to for example set a textfield object from vb6.

Also my report contains subreports based on saved queries. Any idea if i would be able to change the actual queries at runtime?

Thanks in advance

Crystal Reports Parameter Passing
I want to be able to run a crystal report from visual basic 6.0. I made a report, but it reports all data from the access database. I want to be able to pass a parameter to the crystal report from the vb app and then have the report pull the data linked to that parameter from the database and fill in the correct fields on the report. Is this possible or do I have to make all of the fields on the report parameter fields then pass the correct data to it from the vb app?

Passing Parameter To Crystal Reports
I looked on the Crystal reports site and got some sample code for Passing parameters to crystal reports but it doesn't work. VB doesn't like the .GetItemByName. This option doesn't come up if I just type the '.' after crxReport.ParameterFields so I don't think I have it or don't know if you can do it another way.

Thanks for any help

Passing Parameter Value To Crystal Reports
I have a stored procedure that accepts 2 input parameters.

I designed a report and specified default values for this from crystal reports and it works well, but now I want users to be able to specify values at run time from VB6 environment but all I get is an empty report, I don't know what the problem is, help.

This is the code I used

rpt.StoredProcParam(0) = Trim(Me.cboReportCode.Value)
rpt.StoredProcParam(1) = Me.cboFromPayPeriod.Value
rpt.Action = 1

[SOLVED] Passing Parameter To Crystal
Hey,
I have an application developed with Visual basic 6 and Crystal Reports 9.
I am trying to pass a parameter to a crystal report and just can't seem to get it right.
I am opening the report (the report opens well but loads the saved data in the report) with the following code:
Code: Module1.OpenDatabase

        Dim s_myNumber As String
        s_myNumber = Me.txtPurchaseOrderNumber.Text

        Dim s_sql As String
        sql = "...............WHERE 'POR_PURCHASE_ORDERS'.'ORDER_NUMBER'='" & s_myNumber & "'"

        Dim rst As New ADODB.Recordset
        rst.Open sql, conn

        If Not (rst.EOF) Then
            Dim myReport As New CrystalReport1
            myReport.Database.SetDataSource (rst)

            Dim frm As New Form2
            frm.Show
            frm.CRViewer91.Refresh
            frm.CRViewer91.ReportSource = myReport
            frm.CRViewer91.ViewReport
        End If
        Screen.MousePointer = vbNormal

The parameter "OrderNo" is set to "equal to 0000033960" in the report. What I want to do is pass my own parameter from VB6 and I do not want the pop-up screen that asks for the parameter value to show.

Hope you can help
Thanks

Edited by - Nasty on 10/23/2005 4:21:20 AM

Parameter Passing+ Crystal Reports
Hi,

I want a command button on my VB form to invoke the report(report1) & prompt the user to enter a parameter value on the basis of which the data will be retrived.

Kindly help............its urgent

Crystal 20553 Error When Passing Parameter
I am passing 10 parameters to a stored procedure to run a crystal report. I can plug the parameters into crystal or run the SP in query analyzer and it works fine.

However...

If I try to run the report from VB.. It blows up saying

"Error in file : Report.rpt, Invalid parameter name"
Error 2553

HELP.. Anything I can check or do?

Passing Datetime Parameter To Crystal Reports
i have a crystal report that uses a stored proc and has a parameter that's defined as DateTime. this is the code i'm using to pass the parameter in:

VB Code:
pReport.ParameterFields(i).AddCurrentValue CDate(strParams(i - 1))

but this seems to pass in an empty value (i know that strParams(i - 1) has the value "01/01/01"). if i use Format instead of CDate, if just returns a type mismatch error.

has anyone else experienced this?

Passing A Multiple Value Parameter To Crystal Reports 8
I have designed an invoice as a CR8 Report. It works fine on its own and when I call it in my VB6 app via CrystalReport control.

In my app, I have a grid to list invoices so users can select various invoices and then click on the cmdPrint. I enhanced my report by setting InvoiceNo as a GroupField so that I could pass it multiple InvoiceNos and it runs fine within CR but only accepts single value parameter from VB6.

I tried passing it a comma-delimited string but it wouldn't work, it won't accept an Integer array either.
I've searched this site, Google, and the web but I can't find a VB6-specific example.

Code:Private Sub cmdPrint_Click()
    On Error GoTo ErrHandler

    Dim TaxInvNos As String
    Dim x As Integer

    If MSFlex2.TextMatrix(1, 1) <> "" Then
        If MsgBox("Do you want to Print the Invoice?(Yes/No)", vbYesNo, gstrMessage) = vbNo Then Exit Sub

        For x = 1 To MSFlex2.Rows - 1
            If MSFlex2.TextMatrix(x, 13) = "x" Then TaxInvNos = TaxInvNos + MSFlex2.TextMatrix(x, 0) & ","
        Next x
        If TaxInvNos <> "" Then
            TaxInvNos = "(" & mID(TaxInvNos, 1, Len(TaxInvNos) - 1) & ")"
            Call procreport(TaxInvNos)
        End If
    End If

    Exit Sub
ErrHandler:
    MsgBox Err.number & ":" & Err.Description
End Sub

Private Sub procreport(taxinvno As String)
    On Error GoTo ErrHandler

    'The commented out lines are the other option I tried for the Long array.
    'Dim inv() As Long
    'inv = Split(taxinvno, ",")

    CrystalReport1.Connect = cnn
    CrystalReport1.ReportFileName = App.Path & "
eportsInvoice2.rpt"
    CrystalReport1.ParameterFields(0) = "INVNO;" & taxinvno & ";True"
    'CrystalReport1.ParameterFields(0) = "INVNO;" & inv() & ";True"
    CrystalReport1.Destination = crptToWindow
    CrystalReport1.WindowState = crptMaximized
    CrystalReport1.WindowShowExportBtn = True
    CrystalReport1.WindowShowPrintBtn = True
    CrystalReport1.WindowShowPrintSetupBtn = True
    CrystalReport1.Action = 1
    CrystalReport1.Reset

    Exit Sub
ErrHandler:
    MsgBox Err.number & " : " & Err.Description
End Sub

I really need help.

GoodGuy
Experience is a bad teacher for its exams precede its lessons.

Passing Parameter To Access Report
Hmmm... it's late in the day and brain has stopped working.

I have a report running off a query in Access 2000. I want to print this report from Visual basic except change the criteria for the query b4 printing. Clues gratefully appreciated.

Scrooge

Passing Report Parameter Values
Hi there,

i have designed a report in Crystal repots using Sql Server Stored procedure. i need to pass the parameter value's to the report thru VB.

I tried CrystalReport1.ParameterFields(0) = "fromDate=date(2001,11,1)"
but it gives a error Invalid formula name , i tried attaching {@fromdate} ,{?@fromDate} still the same error creeps up..

Did anyone tried similar thing?.

Your help is appreciated.

Thanx

Parameter Passing In Data Report
Hi All,

     I have created a Data report for listing all the party details, who's party name is between any two alphabets. My query for the command is

Code:
SELECT vchPartyCode, vchRepCode, vchPartyName, vchPartyAddr1, vchPartyAddr2, vchPartyAddr3, vchPartyPincode, vchPhone FROM tbPartyMaster WHERE (vchPartyName >= ? AND vchPartyName <= ?) ORDER BY vchPartyName

My problem is if am passing the parameter as 'a' and 'a' it is not displaying anything. if the parameters are 'a' and 'b' it is displaying only for a alone, it is not displaying the for 'b'. What might be the problem.

  Please guide me.

Thanks

Passing The Parameter To The Data Report Header
Dear Friends,

I have a form which contains 2 combo boxes

1. cmbMonth
2. cmbYear

I want to pass the text it contains to the Data Report Header

How to pass the parameter to the report header in Data Report ie cmbMonth.text & cmbYear.text

I want to use the above in the Account Credit Statement which i prepare on the monthly basis & I require to show the month in the report.

Pls help me,

Thanks,

Dennis.

Passing Parameter To Cyrstal Report From VB Code
I have created a report in Crystal Report which uses two parameter Fields FromDt and ToDt.. I am calling that report from my vb application using a Crystal Control.. I pass the parameter as follows ...

Cry.ParameterFields(0) = "FromDt;" & Format(dtpFrom.Value, "DD/MM/YYYY") & ";False"

Cry.ParameterFields(1) = "ToDt;" & Format(dtpTo.Value, "DD/MM/YYYY") & ";False"

It works fine.. But the problem is while running the report it promts for Parameters even if I am pasing it through code...

Can any one help me... I am waiting for some one to gikve me respose...

Thanks in Advance

What's Logon Parameter To Oracle Server With Vb To Print Report With Crystal Report
Hi all,

How to write a log on parameter to oralce server with using vb to print a report that using crystal report

is it crystalreport1.connect = "Dsn=servername;uid=username;pwd=password"

and how to use the selectionformula

Parameter Passing In PIVOT TABLE & REPORT IN EXCEL
Dear Frinds & Experts

I need assistance for pivot tables & reports in excell, How to pass parameter in runtime using that prameter the report must created

Immediate response are appreciated

Parameter In Crystal Report
Hi,
I am a newcomer in Crystal report. I want to create a report which take a parameter of type date. And all the records of that date should be displayed. The date should be pass from VB6. I dont have any idea of how to do it?
Any help will be appreciated.

Thanx

Parameter In Crystal Report 9
Does anybody have idea how I can get parameter in Crystal report (in Visual Basic 6 application ) from signed variable from module in application.

I want to have one text field on the top of report where will be date which is equel the date from variable in module.

This is my variable in module:

Public myDate As Date

I have error if I sign this under Report_Initialize ...

Text15.Text = myDate

Crystal Report Parameter
Hi!

How can I make sure that my Command SQL inside the Crystal Report can read parameter values.

This is how I've got it:
SELECT * FROM Students WHERE stu_num = '{?stu_num}'

I get a blank report though I'm sending parameters correctly.

Crystal Report - Parameter - Please Help
How do I pass a value from a Text Box to Crystal Report. I am using Crystal Report Version 4.6. I could not find any parameter field. Please help me.

Crystal Report Parameter
How can I pass a value from VB to Crystal Report.

Thanks

Parameter Value To Crystal Report
Hello,

I am calling crystal report from vb6.0, I accept some fields on screen who can i pass these field crystal report for check.
who it will be define in crystal report.

Thanks in advance

Pankaj

Passing Pwd To Crystal Report Through Code To Generate Report On Pwd-protected Db
Hi everyone.

Now, I need to pass password to a report in run-time and generate it. I am using Crystal reports 8.5 and my database (from which I intend to generate report) is db-password protected. My project works very fine after the addition of 'Jet OLEDBatabase Password=myPwd' in the open string.

Please help me as I am in the middle of nowhere. I need to have a code on opening a report by passing the pwd from code and then open it using filters users prefer.

Thanks in advance.

Chirohorit

How To Pass Parameter Value From Vb To Crystal Report?
how to pass parameter value from vb to crystal report?

Crystal Report Parameter Field
Now I've been searching to this forum and Google and found no luck....
I have this crystal report , just named it : report.rpt
and this report got three parameters field that needed to select the record to access the database , namely : prompt0,prompt1,prompt2.
How do I pass the value from the textbox to this parameter field in the report?

I use vb6 and cr 8.5
And I use the activeX Crystal Report in the VB application.

Here is my code :

CrystalReport1.ParameterFields(0) = "prompt0;" + "01" + ";true"
CrystalReport1.ParameterFields(1) = "prompt1;" + " & txtNumber & " + ";true"
CrystalReport1.ParameterFields(2) = "prompt2;" + " & txtNumber & " + ";true"
CrystalReport1.Connect = "DSN=AURORA;UID=UID;PWD=PWD"
CrystalReport1.Action = 1

Everytime I run the code , it gives me the same error code :
"Invalid parameter field value"
When I use the "Val(txtNumber)" , it didn't help.
Please help me.
Thx in advance....

Crystal Report Parameter Problem
Hello everyone. I have this problem in Crystal Report specifically in parameter passing. The report is a Collection Report. Once i chose a month and year, it automatically sets the dateto value four months ahead of the chosen date. So assuming i chose jan and 2004, the range will be jan 1, 2004 to may 31, 2004. But once i use dec for example the range exceeds 1 month as intended. So what appears is dec 1 2004 to may 31, 2004, i cant trace the problem becuase i checked the parameter that i pass and its april 2004 not may 2004.
Here is a segment of my code.

DateFrom = Year(dtYear) & "-" & Month(dtMonth.Value) & "-" & 1
Select Case (Month(dtMonth) + 4)

Case 13
preMonth = 1
preYear = Year(dtYear) + 1
Case 14
preMonth = 2
preYear = Year(dtYear) + 1
Case 15
preMonth = 3
preYear = Year(dtYear) + 1
Case 16
preMonth = 4
preYear = Year(dtYear) + 1
Case Else
preMonth = Month(dtMonth) + 4
MsgBox preMonth
preYear = Year(dtYear.Value)
End Select

MnthEnd2 = Day(EndOfMonth(CDate(preMonth & "/" & 1 & "/" & preYear)))
DateTo = CDate(preYear & "-" & preMonth & "-" & MnthEnd2)

Set crpParamDefs = Rpt.ParameterFields

For Each crpParamDef In crpParamDefs
With crpParamDef
Select Case .ParameterFieldName
Case "@dtFrom"
.ClearCurrentValueAndRange
.SetCurrentValue CDate(DateFrom)
Case "@dtTo"
.ClearCurrentValueAndRange
.SetCurrentValue CDate(DateTo)
End Select
End With
Next

' i used this function to be able to get the last day of the month
Function EndOfMonth(ByVal D As Date)
EndOfMonth = DateSerial(Year(D), Month(D) + 1, 0)
End Function

Help Please.....Thanks

To Pass Parameter From Vb6 To Crystal Report
Hello Friends,

My problem is I want to accept value from user which I am nt storing in databasse. I am using inputbox to get value from user and then I want to print the same value in the crystal report. I am not using crystal report viewer, but I've used crstyal report's ocx and from there i am opening report by using printreport method of the crystal report's ocx control. plz help me.

below is my code which i m using to print report

VB Code:
With crStudList .Connect = strConn .ReportFileName = App.Path & "
eportsStudentList.rpt" .ReportTitle = "Student List" .WindowTitle = "Student List" '.SelectionFormula = "{tblStudent.RegistrationDate}>= DateValue (" & dtpFrom.Value & ") and {tblStudent.RegistrationDate}<= DateValue(" & dtpTo.Value & ")" .SelectionFormula = "{tblStudent.RegistrationDate}>=#" & Format(dStartDate, "dd/MM/yyyy") & "# and {tblStudent.RegistrationDate}<=#" & dEndDate & "#" .Destination = crptToPrinter .PrintReport End With

where crStudList the name of ocx control of crystal report

thanks

Discrete Value In Parameter (crystal Report)
hi,
I am using VB6.0 & access as backend.
I am making one report which will print salesmanwise sales. I want to give option to the user to select the salesman & accordingly the sales will get generated. For that I have used parameter option, in that I have selected the table & in field I have selected salesman.

So far so good, The report is giving what I want, but when I add new Salesman to the table and I generate the report again, It is not showing the newly created salesman in the discrete value, any idea.
Is there any refresh Or like that ?

Thanks

ME

How VB Pass Parameter To Crystal Report
how to pass Parameter to Seagate Crystal report by VB?

I want to pass One or More parameter to Crystal report to meet a certain critera

like i want to select some record by my application given date so report should be contains only those record sort by given date.

Parameter Problem In Crystal Report 8.5?
i have problem in parameter using CR 8.5, when i input the name in preparedby text box i want the parameter to directly out put in crystal report. how can i do that?
pls see attached pictures.

Private Sub cmdPrint_Click()
'on error goto err_handler

Dim strsqlstring As String
Dim strparam1 As String
Dim strparam2 As String

If Opt1.Value = True Then


   If DTPicker1.Value <> "" And DTPicker2.Value <> "" Then
      strsqlstring = "{tbltallyreceipts.dtdate} >= #" & Format(DTPicker1.Value, "mm/dd/yyyy") & "# and {tbltallyreceipts.dtdate} <= #" & Format(DTPicker2.Value, "mm/dd/yyyy") & "# And {tbltallyreceipts.st_services} = '" & cboPrintServices & "'"
      strparam1 = frmPrint.txtpreparedby
      strparam2 = frmPrint.txtnotedby
   End If

  With CrystalReport1

     .ReportFileName = App.Path & "fdata.rpt"
     .Connect = App.Path & "financialdata.mdb"
     .DiscardSavedData = True
     .RetrieveDataFiles
     .ReportSource = 0
     .SQLQuery = "Select *from tbltallyreceipts "
     .WindowTitle = "Financial Data"
     .ReportTitle = "Total Receipts"
     .Destination = crptToWindow
     .PrintFileType = crptCrystal
     .WindowState = crptMaximized
     .WindowMaxButton = False
     .WindowMinButton = False
     .SelectionFormula = strsqlstring
     .ParameterFields(0) = "prpreparedby;" & strparam1 & ";false"
     .ParameterFields(1) = "prnotedby;" & strparam2 & ";false"

     .Action = 1

  End With


     frmPrint.txtnotedby = ""
     frmPrint.txtpreparedby = ""
End If



End Sub

How To Pass A Parameter In Vb Using Crystal Report 9.0
hi,

i'm using vb 6.0 , access 98 & cr 9.0. plz help me how to pass a parameter using vb 6.0 .
in run time.

regards
chitkrish

vikramjb : post moved to the reporting section. Please post in the approriate forums.

Edited by - vikramjb on 12/22/2005 2:08:48 AM

Textbox Parameter In Crystal Report
Can someone show me how to pass a textbox value from vb .net to crystal report?

How can i refresh the report if i change the value in the textbox?

Thanks!!!

Passing Parameter In VB6 To Crystal Report

Hi Babu,I used code that you gave me but there is a error "205539 :Invalid parameter field name".Can you show me clearly? Thanks in advance!

Hi Babu,
I used code that you gave me but there is a error "205539 :Invalid parameter field name".Can you show me clearly? Thanks in advance!