Skip to Content
0
Former Member
Jun 01, 2007 at 09:12 AM

Crystal Report's CrystalReportViewer doesn't work on SharePoint site

128 Views

Post Author: tomas_hkk

CA Forum: .NET

Hi,I tried to place crystal report's (Crystal Report for VS 2005) CrystalReportViewer control to the sharepoint webpart. When I bind data by: ReportDocument.SetDataSource( DataSet dataSet )I get this message:CrystalDecisions.CrystalReports.Engine.DataSourceException: Unknown Query Engine Error Error in File C:\WINDOWS\TEMP\Customer {E6CF813B-0A4B-4A60-8113-05E6E850454C}.rpt: Unknown Query Engine Error ---> System.Runtime.InteropServices.COMException (0x800002C2): Unknown Query Engine Error Error in File C:\WINDOWS\TEMP\Customer {E6CF813B-0A4B-4A60-8113-05E6E850454C}.rpt: Unknown Query Engine Error at CrystalDecisions.ReportAppServer.Controllers.DatabaseControllerClass.ReplaceConnection(Object oldConnection, Object newConnection, Object parameterFields, Object crDBOptionUseDefault) at CrystalDecisions.CrystalReports.Engine.Table.SetDataSource(Object val, Type type) at CrystalDecisions.CrystalReports.Engine.ReportDocument.SetDataSourceInternal(Object val, Type type) --- End of inner exception stack trace --- at CrystalDecisions.ReportAppServer.ConvertDotNetToErom.ThrowDotNetException(Exception e) at CrystalDecisions.CrystalReports.Engine.ReportDocument.SetDataSourceInternal(Object val, Type type) at CrystalDecisions.CrystalReports.Engine.ReportDocument.SetDataSource(DataSet dataSet) at SPPortal.Reports.PrintJunketStatementReport.ConfigureCrystalReports() at SPPortal.Reports.PrintJunketStatementReport.OnInit(EventArgs e) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Control.AddedControl(Control control, Int32 index) at System.Web.UI.ControlCollection.Add(Control child) at SPPortal.Controls.PPWebPartSimple.CreateChildControls()When I try same stuff on normal asp.net page (not sharepoint) everything works well.I don't know if this is problem from Crystal Report or Sharepoint, but I think there is no reason it shouldn't work.Thanks for help...Tomas