Creating reports and dashboards | Stimulsoft community forum

Hi,

I just dowloaded the latest patch (SR_2007[1].08.24_R2005). The upgrade works OK but the I'm having problem compiling SqlCe Database pack. Here are the errors:

'Stimulsoft.Base.Localization.StiLocalization' does not contain a definition for 'Database' ...\StiSqlCeDatabase.cs 48 43 Stimulsoft.Report.SqlCeDatabase
'Stimulsoft.Base.Localization.StiLocalization' does not contain a definition for 'FormDatabaseEdit' ...\StiSqlCeDatabase.cs 67 62 Stimulsoft.Report.SqlCeDatabase
'Stimulsoft.Base.Localization.StiLocalization' does not contain a definition for 'FormDatabaseEdit' ...\StiSqlCeDatabase.cs 68 50 Stimulsoft.Report.SqlCeDatabase
'Stimulsoft.Base.Localization.StiLocalization' does not contain a definition for 'Adapters' ...\StiSqlCeAdapterService.cs 49 40 Stimulsoft.Report.SqlCeDatabase
'Stimulsoft.Base.Localization.StiLocalization' does not contain a definition for 'PropertyMain' ...\StiSqlCeSource.cs 107 33 Stimulsoft.Report.SqlCeDatabase

Thanks.

Hello,

please get update version of adapter:

www.stimulsoft.com/private/Stimulsoft.R ... tabase.zip

Thank you.

Hi,

I think there is a bug in the updated adapter. I compiled it without error however existing reports connecting directly to SqlCe didn't work any more. I found that in the designer dictionary all tables no longer have any column infomation. The relation seemed to be OK.

I used the following codes to register each table in the database which used to work before the update:

StiSqlCeSource source = new StiSqlCeSource(databaseName, tableName, tableName, "SELECT * FROM " + tableName);
report.Dictionary.DataSources.Add(source);
source.SynchronizeColumns();

Am I missing something?

Thanks.

Sorry for the delay in answers.

We are working now on the 2007.2 official release version.

Thank you.

I fixed the problem, just post the answer here in case someone interested.

In StiSqlCeAdapterService.cs method GetColumnsFromData() has the following codes:

foreach (StiDataColumn column in dataColumns)
{
column.Name = StiNameValidator.CorrectName(column.Name);
}

I found that StiNameValidator.CorrectName() replaces space with '_' causing the report to behave incorrectly in some cases. I commented out this codes and it works OK with release version 7.2

Thank you very much for this explanation.

We will check this behavior once more.

Thank you.

We have corrected our code.
Thank you for your help.