| Author |
 Topic  |
|
|
MKD
Poland
31 Posts |
 Posted - 11/13/2011 : 15:28:22
|
I've a problem with Data Entry Report.
Report is connected to table that was created this way
create table test_table(
name varchar(100),
number decimal(5,2)
)
But every time I try to sent some data to number column, I have a message:
Value 33.33 is not numeric for column: number
I tried sending number in different formats: 33,33 and 33.33
Is the problem with Database Collation?
I tried databases with:
SQL_Polish_CP1250_CS_AS
Welsh_100_CI_AS_KS
Latin1_General_100_CI_AS_KS
Is the problem with column type?
I tried: decimal, float, money, numeric |
|
|
admin
1643 Posts |
Posted - 11/13/2011 : 22:03:43
|
| Can you please capture the SQL executed against the server using SQL Server Profiler? |
 |
|
|
MKD
Poland
31 Posts |
Posted - 11/14/2011 : 09:19:51
|
SELECT r.SourceText, r.FolderId, r.ReportName, r.CubeId, r.CubeName, r.ReportDesc, c.ConnectionString, c.DbName, c.ConnectionType FROM Report r INNER JOIN [Connection] c ON r.ConnectionId = c.ConnectionId WHERE r.ReportId = '20'
It's the only thing that shows in SQL Server Profiler after cliking "Add". |
|
|
|
admin
1643 Posts |
Posted - 11/14/2011 : 11:50:35
|
| You should set the profiler to the server that you used in your connection (Admin > connections). |
|
|
|
MKD
Poland
31 Posts |
Posted - 11/14/2011 : 14:55:06
|
| It's the same server. |
|
|
|
admin
1643 Posts |
Posted - 11/14/2011 : 17:05:21
|
| Please right click on the report in the report tree and pick Export. Send the exported file along with the screenshot of the error to support@ReportPortal.com |
|
|
| |
Topic |
|
|
|
Report Portal
Data Entry, problem with number data
