| | |
crystal report parameter in visual basic 6
Please support our Visual Basic 4 / 5 / 6 advertiser: Programming Forums - DaniWeb Sister Site
![]() |
•
•
Join Date: Aug 2008
Posts: 5
Reputation:
Solved Threads: 0
I Wish to pass parameter to Crystal Report. I have Access data base one table named student. I with to select range of data's from that table field named "rno"
i am using visual basic 6
I used following code to view crystal report
================================================
Set rs = New ADODB.Recordset
modConnection.opendb
rs.Open "select * from STUDENT_M order by rno", cn, adOpenStatic, adLockPessimistic
Report.Database.SetDataSource rs
Screen.MousePointer = vbHourglass
CRViewer1.ReportSource = Report
CRViewer1.ViewReport
Screen.MousePointer = vbDefault
==========================================
I am new to crystal report. please guide me how to use parameter in crystal report.
a.Senthil kumar.
i am using visual basic 6
I used following code to view crystal report
================================================
Set rs = New ADODB.Recordset
modConnection.opendb
rs.Open "select * from STUDENT_M order by rno", cn, adOpenStatic, adLockPessimistic
Report.Database.SetDataSource rs
Screen.MousePointer = vbHourglass
CRViewer1.ReportSource = Report
CRViewer1.ViewReport
Screen.MousePointer = vbDefault
==========================================
I am new to crystal report. please guide me how to use parameter in crystal report.
a.Senthil kumar.
![]() |
Similar Threads
- Issue about passing parameter to Crystal Report 11.. (Visual Basic 4 / 5 / 6)
- Is it possible to display report in Visual Basic which is created in Microsoft Access (Visual Basic 4 / 5 / 6)
Other Threads in the Visual Basic 4 / 5 / 6 Forum
- Previous Thread: print loop help
- Next Thread: Data collection from Excel file through VB-6 using record set
| Thread Tools | Search this Thread |
* 6 429 2007 access activex add age append application basic beginner birth bmp calculator cd cells.find click client code college column component connection connectionproblemusingvb6usingoledb copy creat ctrl+f data database datareport date delete dissertations dissertationthesis dissertationtopic edit error excel excelmacro file filename form hardware header iamthwee image inboxinvb internetfiledownload keypress label listbox listview liveperson login looping machine microsoft movingranges number objectinsert open oracle password prime program prompt range-objects readfile reading record refresh remotesqlserverdatabase report retrieve save search sendbyte sites sort sql sql2008 sqlserver subroutine table tags textbox time timer urldownloadtofile vb vb6 vb6.0 vba visual visualbasic visualbasic6 web window windows





