akzocols
asked on
CrystalDecisions.CrystalReports.Engine.DataSourceException: Query Engine Error
Hi, I am receiving this error when i run a report in .net 2003 with CR. I cannot find any solutions for this problem. Here is the error (CODE IS BENEATH ERROR): PLEASE HELP - THANKS!
Query Engine Error: 'C:\WINDOWS\TEMP\temp_5909 cf2a-a62b- 4a2e-8e2f- 13085e7f40 5e.rpt'
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: CrystalDecisions.CrystalRe ports.Engi ne.DataSou rceExcepti on: Query Engine Error: 'C:\WINDOWS\TEMP\temp_5909 cf2a-a62b- 4a2e-8e2f- 13085e7f40 5e.rpt'
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[DataSourceException: Query Engine Error: 'C:\WINDOWS\TEMP\temp_5909 cf2a-a62b- 4a2e-8e2f- 13085e7f40 5e.rpt']
HERE IS MY CODE:
Imports System.Data.SqlClient
Imports CrystalDecisions.CrystalRe ports.Engi ne
-------------------------- ---------- ---------- --
Public creport1 As New CrystalReport1
-------------------------- ---------- ---------- --
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'Put user code to initialize the page here
Dim cnn As New SqlConnection
cnn.ConnectionString = csAframe
cnn.Open()
Dim da As New SqlDataAdapter("Select top 5 * from adhoc_externaluseractivity ", cnn)
Dim ds As New DataSet
da.Fill(ds)
creport1.SetDataSource(ds)
Me.CrystalReportViewer1.Re portSource = creport1
End Sub
Query Engine Error: 'C:\WINDOWS\TEMP\temp_5909
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: CrystalDecisions.CrystalRe
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[DataSourceException: Query Engine Error: 'C:\WINDOWS\TEMP\temp_5909
HERE IS MY CODE:
Imports System.Data.SqlClient
Imports CrystalDecisions.CrystalRe
--------------------------
Public creport1 As New CrystalReport1
--------------------------
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'Put user code to initialize the page here
Dim cnn As New SqlConnection
cnn.ConnectionString = csAframe
cnn.Open()
Dim da As New SqlDataAdapter("Select top 5 * from adhoc_externaluseractivity
Dim ds As New DataSet
da.Fill(ds)
creport1.SetDataSource(ds)
Me.CrystalReportViewer1.Re
End Sub
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I have move this to the Crystal Reports topic where I think you will have a better chance of getting a solution.
COBOLdinosaur
Page Editor, Web Development Software