Crystal Report Problem

Printable View

Sep 8th, 2006, 05:24 AM
elixir_5000

Crystal Report Problem
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
VB Code:
```
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
Sep 8th, 2006, 06:58 AM
Hack

Re: Crystal Report Problem

Moved to Reporting Section
Sep 8th, 2006, 07:00 AM
RobDog888

Re: Crystal Report Problem

You will need to modify your RecordSelectionFormula to be able to include both or multiple records that fit your criteria.
Sep 8th, 2006, 11:17 PM
elixir_5000

Re: Crystal Report Problem

sir, can u just give me a simple example of how to insert multiple records in a single reports
plz help
Sep 9th, 2006, 03:24 AM
RobDog888

Re: Crystal Report Problem

I have an example in my signature for VB6/CR/ADO.
Sep 9th, 2006, 05:07 AM
elixir_5000

Re: Crystal Report Problem
VB Code:
```
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