Problem opening Crystal Report in vb.net
-
Hello I m using crystal report 9 in my vb.net Application my problem is that when i Called the Report whose Data Source is a text file, from my vb.net application the system gives me the runtime error Query Engine error :HY000 [MICROSOFT][ODBC TEXT DRIVER] THE MICROSOFT JET DATABASE IS CANNOT OPEN THE FILE (UNKNOWN).IT IS ALREADY OPEN EXCLUSIVELY BY ANOTHER USER OR U NEED PERMISSION TO VIEW ITS DATA ERROR IN FILE C:\DOCUMEN~1\USER\LOCALS~1\TEMP\CRRPT.RPT QUERY ENGINE ERROR however i m using the code to for crystal report viewer control as Me.CrystalReportViewer1.Refresh() Dim strPathName As String Dim reportDocument1 As New CrystalDecisions.CrystalReports.Engine.ReportDocument strPathName = "D:\CrReport.rpt" reportDocument1.Load(strPathName) Me.CrystalReportViewer1.ShowExportButton = True Me.CrystalReportViewer1.ShowPageNavigateButtons = True Me.CrystalReportViewer1.ReportSource = reportDocument1 please please help me out
-
Hello I m using crystal report 9 in my vb.net Application my problem is that when i Called the Report whose Data Source is a text file, from my vb.net application the system gives me the runtime error Query Engine error :HY000 [MICROSOFT][ODBC TEXT DRIVER] THE MICROSOFT JET DATABASE IS CANNOT OPEN THE FILE (UNKNOWN).IT IS ALREADY OPEN EXCLUSIVELY BY ANOTHER USER OR U NEED PERMISSION TO VIEW ITS DATA ERROR IN FILE C:\DOCUMEN~1\USER\LOCALS~1\TEMP\CRRPT.RPT QUERY ENGINE ERROR however i m using the code to for crystal report viewer control as Me.CrystalReportViewer1.Refresh() Dim strPathName As String Dim reportDocument1 As New CrystalDecisions.CrystalReports.Engine.ReportDocument strPathName = "D:\CrReport.rpt" reportDocument1.Load(strPathName) Me.CrystalReportViewer1.ShowExportButton = True Me.CrystalReportViewer1.ShowPageNavigateButtons = True Me.CrystalReportViewer1.ReportSource = reportDocument1 please please help me out
Well, I don't use CrystalReports. By the error message either the file you gave the report doesn't exist (or the path to it is wrong), or the file is already held open by some other code in your app or some other external application. Did your code open this file somewhere else and not close it??
A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
2006, 2007