Incompatibility between PHP-Generated reports and Net-Components.

mietzekotze · Post by **mietzekotze** » Mon Jun 04, 2012 9:41 am

Hello,

we've just changed or ReportEngine from your PHP-Components to the Net ones. Unfortunatly we have discovered, that the PHP-Reports are not able to be displayed by rendering them. We work with ASP, and get following error message:
"Guid should contain 32 digits with 4 dashes"

You can open the templates with the designer, but if you save them, you get the same error when trying to open them again.

This is the full error report:

Code: Select all

[FormatException: GUID muss 32 Ziffern mit 4 Bindestrichen enthalten (xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx).]
   System.Guid.TryParseGuidWithNoStyle(String guidString, GuidResult& result) +3923773
   System.Guid.TryParseGuid(String g, GuidStyles flags, GuidResult& result) +245
   System.Guid..ctor(String g) +107
   MySql.Data.Types.MySqlGuid.MySql.Data.Types.IMySqlValue.ReadValue(MySqlPacket packet, Int64 length, Boolean nullVal) +217
   MySql.Data.MySqlClient.NativeDriver.ReadColumnValue(Int32 index, MySqlField field, IMySqlValue valObject) +174
   MySql.Data.MySqlClient.ResultSet.get_Item(Int32 index) +128
   MySql.Data.MySqlClient.MySqlDataReader.GetFieldValue(Int32 index, Boolean checkNull) +39
   MySql.Data.MySqlClient.MySqlDataReader.GetValue(Int32 i) +66
   MySql.Data.MySqlClient.MySqlDataReader.GetValues(Object[] values) +54
   System.Data.ProviderBase.CommonLanguageSubsetDataReader.GetValues(Object[] values) +13
   System.Data.ProviderBase.SchemaMapping.LoadDataRow() +46
   System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping) +96
   System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue) +164
   System.Data.Common.DataAdapter.Fill(DataTable[] dataTables, IDataReader dataReader, Int32 startRecord, Int32 maxRecords) +285
   System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +175
   System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) +166
   System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) +115
   Stimulsoft.Report.Dictionary.StiMySqlAdapterService.ConnectDataSourceToData(StiDictionary dictionary, StiDataSource dataSource, Boolean loadData) +939
   Stimulsoft.Report.Dictionary.StiDataSource.Connect(StiDataCollection datas, Boolean loadData) +99
   Stimulsoft.Report.Dictionary.StiDataSourcesCollection.Connect(StiDataCollection datas, Boolean loadData) +166
   Stimulsoft.Report.Dictionary.StiDictionary.Connect(Boolean loadData) +163
   Stimulsoft.Report.Engine.StiRenderProviderV2.ConnectToData(StiReport report) +140
   Stimulsoft.Report.Engine.StiRenderProviderV2.Render(StiReport report, StiRenderState state) +4686
   Stimulsoft.Report.Engine.StiReportV2Builder.RenderSingleReport(StiReport masterReport, StiRenderState renderState) +847
   Stimulsoft.Report.StiReport.RenderReport(StiRenderState renderState) +1588
   Stimulsoft.Report.StiReport.Render(StiRenderState renderState, StiGuiMode guiMode) +952
   Stimulsoft.Report.StiReport.Render(Boolean showProgress) +53
   Stimulsoft.Report.Web.StiWebViewer.RenderReport(StiReport report) +120
   Stimulsoft.Report.Web.StiWebViewer.ProcessReport() +1250
   Stimulsoft.Report.Web.StiWebViewer.set_Report(StiReport value) +3190
   _Default.Page_Load(Object sender, EventArgs e) in C:\webroot\sds\reports\ReportViewer.aspx.vb:43
   System.Web.UI.Control.OnLoad(EventArgs e) +91
   System.Web.UI.Control.LoadRecursive() +74
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2207

Thank you

Post by **Ivan** » Tue Jun 05, 2012 4:58 am

Hello,

Can you please send us a sample report template with data, which reproduce the issue?

Thank you.

mietzekotze · Post by **mietzekotze** » Tue Jun 12, 2012 5:16 am

Hello,

due to the fact, that we use a local database, i can't deliver data. But the problem appears indepentent from the database. So i think the error appears while reading the file, since the files have some differences.
I've added a example Report which throws this error (unfortunatly its in german):

c:\Windows\Temp\bziumx5x.0.cs(221,49) : error CS1061: "Reports.Report.V_ReportDataSource" enthält keine Definition für "number", und es konnte keine Erweiterungsmethode "number" gefunden werden, die ein erstes Argument vom Typ "Reports.Report.V_ReportDataSource" akzeptiert (Fehlt eine Using-Direktive oder ein Assemblyverweis?).

Thank you

Post by **Alex K.** » Tue Jun 12, 2012 8:39 am

Hello,

In Text81textbox you write the {V_Report.number} expression.
But the "number" field is not defined in the "V_Report" datasource.
Flex using interpretation mode and this error is ignored, but in .Net report is compiling and these errors not are unacceptable.

Thank you.

mietzekotze · Post by **mietzekotze** » Tue Jun 12, 2012 9:52 am

OK, thank you. And can you tell me whats the problem with the one i've attached on this post? With this one i always get "conversion-errors" because there are already Members with an specific name. Thats the most usual error I get, and i have no idea how to find the cause.

//Edit: There was a little problem with the Attach-Function so i uploaded it here: http://depositfiles.com/rmv/5092667644139934

Post by **Alex K.** » Wed Jun 13, 2012 8:19 am

Hello,

Please check the link. File not found.

Thank you.