run access query for crystal report
Visual Basic
3
Posts
2
Posters
0
Views
1
Watching
-
Hello Experts!! My problem is- "select * from data" i want to show result of this query on to crystal report.......I am using msaccess for a database.
This link will help you: http://www.vbforums.com/showthread.php?p=2686697[^]
Shay Noy
-
This link will help you: http://www.vbforums.com/showthread.php?p=2686697[^]
Shay Noy
I used code from given link....but give error "view report is not member of frmOrder" Dim Report As New frmorder Dim TableName(0) As String Dim QueryString(0) As String TableName(0) = "TableName" 'Pass The Table That you used in the crystal Report QueryString(0) = "SELECT * FROM TableName" ' Pass the Query 'ReportForm.MdiParent = MainForm 'Pass For Mdi True Report.ViewReport("CrystalReport1.rpt", TableName, QueryString, )