dennisds
Mar 21st, 2003, 03:39 AM
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.
[Highlight=VB]
option Explicit
Private Sub Command1_Click()
deConsolidated.Command1 cmbMonth.Text, cmbYear.Text
drConsolidated.Show
End Sub
[\vbcode]
Pls guide me how to pass the parameters from the above combo box to crystal report designer ( RDC)
Thanking you,
Rgds,
Dennis.
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.
[Highlight=VB]
option Explicit
Private Sub Command1_Click()
deConsolidated.Command1 cmbMonth.Text, cmbYear.Text
drConsolidated.Show
End Sub
[\vbcode]
Pls guide me how to pass the parameters from the above combo box to crystal report designer ( RDC)
Thanking you,
Rgds,
Dennis.