| T O P I C R E V I E W |
| MKD |
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 |
| 5 L A T E S T R E P L I E S (Newest First) |
| admin |
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 |
| MKD |
Posted - 11/14/2011 : 14:55:06
It's the same server. |
| admin |
Posted - 11/14/2011 : 11:50:35
You should set the profiler to the server that you used in your connection (Admin > connections). |
| MKD |
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 |
Posted - 11/13/2011 : 22:03:43
Can you please capture the SQL executed against the server using SQL Server Profiler? |
Report Portal
