Crystal Report Problem

[elixir_5000]

I AM USING CR 8.0 WITH VB 6.0
I HAVE A TABLE IN THE DATA BASE FROM WHICH I FILL THE FIELDS IN THE REPORT TILL NOW I WAS HAVING A SINGLE SET OF RECORD IN THAT TABLE BUT NOW I AM HAVING MORE THAN ONE SET OF RECORDS
WHAT I WANT IS THAT IF I HAVE 2 RECORDS IN THE TABLE THEN THE REPORT MUST SHOW 2 PAGES IN PREVIEW


TILL NOW I WAS USING THE FOLLOWING CODE FOR AT THE LOAD OF THE FORM THAT CONTAINED CRYSTAL VIEWER

Private Sub Form_Load()
 
Dim oapp As CRAXDRT.Application
Dim rpt As CRAXDRT.Report
Set oapp = New CRAXDRT.Application
Set rpt = oapp.OpenReport(App.Path & "\tax invoice.rpt", 1)
rpt.RecordSelectionFormula = "{DATA2.inv}='" & val(new1("INV")) & "'"
rpt.RecordSelectionFormula = "{kapil.article}='" & val(new1("anum")) & "'"
cr1.ReportSource = rpt
 
 
cr1.ViewReport
 
End Sub

PLZ TELL ME HOW TO DO THAT

[Hack]

Moved to Reporting Section

[RobDog888]

You will need to modify your RecordSelectionFormula to be able to include both or multiple records that fit your criteria.

[elixir_5000]

sir, can u just give me a simple example of how to insert multiple records in a single reports
plz help

[RobDog888]

I have an example in my signature for VB6/CR/ADO.

[elixir_5000]

oReport.Database.SetDataSource oRs, 3, 1

sir plz can u just explain this line
what is data base
ors is recordsource ?
oreport is a report