Rank: Member
Groups: Registered
Joined: 1/30/2020(UTC) Posts: 15 
|
Hello
I can connect to a DB2 database very well
But when I create the report I have the following message:
The arithmetic operation caused an overflow
Can you help me please ?
Thank's
|
|
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209  Thanks: 14 times
Was thanked: 206 time(s) in 199 post(s)
|
this is probably a DB2 data type or some strange data in your database that not supported by the DB2 driver you are using... typically a number with to many decimals or too big. you have to understand which column causes the error, then try to solve it by CAST/CONVERT SQL functions specific to DB2. Edited by user Thursday, January 30, 2020 4:29:29 PM(UTC)
| Reason: Not specified
|
|
|
|
|
|
Rank: Member
Groups: Registered
Joined: 1/30/2020(UTC) Posts: 15
|
thank you for your reply
If I take another SQL processing software with the same driver, I have no problem
This problem is only with seal report
The data type is GRAPHIC
Thank you
|
|
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209 Thanks: 14 times
Was thanked: 206 time(s) in 199 post(s)
|
Seal Report supports only Text,Numeric or Date Type,
if you have special types (like Graphic or Binary), you have to convert it first.
Check the Sample '14-Images and File Download' to see an example with Northwind and MS Access.
|
|
|
|
|
|
Rank: Member
Groups: Registered
Joined: 1/30/2020(UTC) Posts: 15
|
Thank's
Where i must insert the CAST/CONVERT SQL functions ?
On model, on table repository, on connection
|
|
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209 Thanks: 14 times
Was thanked: 206 time(s) in 199 post(s)
|
there are several ways to do it, by sQL it should be in the column definition in order to generate the SQL you want. in the model, you can select your column, then set tje 'Custom SQL' property to change the SQL generated. if you want to display an image from a varbinary, you can also check this post: https://sealreport.org/f...=posts&t=133#post278
|
|
|
|
|
|
Rank: Member
Groups: Registered
Joined: 1/30/2020(UTC) Posts: 15
|
thank you so much
It's OK using CUSTOM SQL
But I have 254 Tables and as many cells in each table
I will have to go over the cells one by one :-)
:-) :-)
|
|
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209 Thanks: 14 times
Was thanked: 206 time(s) in 199 post(s)
|
you may automate this with a few lines of C# in a Task:
open your data source, then loops on the tables and columns, change your SQL, then save the Data Source.
it is easy if you know the Seal models and C#...
|
|
|
|
|
|
Rank: Member
Groups: Registered
Joined: 1/30/2020(UTC) Posts: 15
|
thanks a lot for all these informations
Thank you for the speed of the answers, you helped me a lot.
I found it simpler than going through c #
I join my DB2 tables to an access database, then connect to the mdb database.
I no longer have the thought of conversion
Seal report is awesome
Too bad there is not a tutorial or instructions for use, especially for Dashboard and sub folder
Thanks again
I will definitely go back through the Forum
:-)
Merci beaucoup pour toutes ces informations
Merci pour la rapidité des réponses, vous m'avez beaucoup aidé.
J'ai trouvé plus simple que de passer par du c#
Je joint mes tables DB2 à une base access, puis me connecte sur la base mdb.
Je n'ai plus le soucis de conversion
Seal report est génial
Dommage qu'il n'y ait pas un Tuto ou une notice d'utilisation, surtout pour les Dashboard et les sub folder
Encore Merci
Je repasserai certainement par le Forum
:-)
|
|
|
|
|
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.
