How to integrate crystal report using Visual Basic 6.0 1

[SpeakUp]

I had this program using Data Report in Visual Basic and im trying to use Crystal Report 7.0 but the problem is how can i filter the data using visual basic from my Crystal Report.

Any help is greatly appreciated.... Thanks

 

[chelseatech]

I assume you are using the RDC.

Two possibilities.

You can directly modify the record selection formula from VB or you can have paramaters in your report and you can load them via VB. Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm

 

[SpeakUp]

Actually i made the report and it goes like this...

Cr1.ReportFileName=app.path & "\inv.rpt"
Cr1.DiscardSaveData = True
Cr1.WindowState = crptMaximized
Cr1.Action = 1

I have a combobox with branches and the code goes like this...

set rs = db.OpenRecordset("SELECT * FROM tComputers WHERE Branch ='" & combobox & "'&quot

But my problem is i want to filter the data inside the report. I want only the selected branches... How do i do this... Please Help!!!

Thanks!!!

 

[chelseatech]

Looks like you are using the OCX (Crystl32.OCX)

Use
txFormula= "{tComputers.Branch}='" & comboxbox & "'"
cr1.replaceselectionformula txtFormula Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm

 

[SpeakUp]

Thanks Buddy i got it. Its working already...

 

[SpeakUp]

Thanks Buddy i got it. Its working already...