I have some problem with decimal number in my report using an Oracle connection.
Sample query is:
Code: Select all
SELECT 4/3 my_col FROM dual----------------------------
[Customer Explanation]
----------------------------
[General Info]
Application: Stimulsoft Reports
Framework: v4.0.30319
Version: Version: 2016.1.0 from 17 February 2016
OSVersion: Microsoft Windows NT 6.2.9200.0
----------------------------
[Exception Info]
Message: The specified cast is invalid.
Source: Oracle.ManagedDataAccess
StackTrace:
à Oracle.ManagedDataAccess.Client.OracleDataReader.GetDecimal(Int32 i)
à Oracle.ManagedDataAccess.Client.OracleDataReader.GetValue(Int32 i)
à Oracle.ManagedDataAccess.Client.OracleDataReader.GetValues(Object[] values)
à System.Data.ProviderBase.DataReaderContainer.CommonLanguageSubsetDataReader.GetValues(Object[] values)
à System.Data.ProviderBase.SchemaMapping.LoadDataRow()
à System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping)
à System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue)
à System.Data.Common.DataAdapter.Fill(DataTable[] dataTables, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
à Oracle.ManagedDataAccess.Client.OracleDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
à System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
à Stimulsoft.Report.Dictionary.StiSqlSource.RetrieveData(Boolean schemaOnly)
à Stimulsoft.Report.Dictionary.StiSqlAdapterService.ConnectDataSourceToData(StiDictionary dictionary, StiDataSource dataSource, Boolean loadData)
à Stimulsoft.Report.Dictionary.StiDataSource.Connect(StiDataCollection datas, Boolean loadData)
à Stimulsoft.Report.WpfDesign.StiDataStoreSourceEditWindow.tbRunScript_Click(Object sender, RoutedEventArgs e)
----------------------------
[Assemblies]
ADF.Framework.Database, Version = 1.0.0.0
DevExpress.Xpf.Core.v15.2, Version = 15.2.5.0
mscorlib, Version = 4.0.0.0
PresentationCore, Version = 4.0.0.0
PresentationFramework, Version = 4.0.0.0
Stimulsoft.Base, Version = 2016.1.0.0
Stimulsoft.Report, Version = 2016.1.0.0
System, Version = 4.0.0.0
System.Data, Version = 4.0.0.0
System.Drawing, Version = 4.0.0.0
System.Xaml, Version = 4.0.0.0
I know that I can do the following code but it's not very user friendly and I have to hardcode the format...
Code: Select all
SELECT CAST(4/3 as DECIMAL(20,7)) my_col FROM dual