logo

Warning: The forum is now for consultation only. Please use GitHub Discussions to post any questions or comments.


Welcome Guest ! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
Alain  
#1 Posted : Thursday, January 30, 2020 3:41:19 PM(UTC)
Alain

Rank: Member

Groups: Registered
Joined: 1/30/2020(UTC)
Posts: 15
France

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
epf  
#2 Posted : Thursday, January 30, 2020 4:28:42 PM(UTC)
epf

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 1,209
Switzerland

Thanks: 14 times
Was thanked: 205 time(s) in 198 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

Alain  
#3 Posted : Thursday, January 30, 2020 4:35:01 PM(UTC)
Alain

Rank: Member

Groups: Registered
Joined: 1/30/2020(UTC)
Posts: 15
France

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

epf  
#4 Posted : Friday, January 31, 2020 7:53:24 AM(UTC)
epf

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 1,209
Switzerland

Thanks: 14 times
Was thanked: 205 time(s) in 198 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.
Alain  
#5 Posted : Friday, January 31, 2020 10:46:54 AM(UTC)
Alain

Rank: Member

Groups: Registered
Joined: 1/30/2020(UTC)
Posts: 15
France

Thank's

Where i must insert the CAST/CONVERT SQL functions ?

On model, on table repository, on connection
epf  
#6 Posted : Friday, January 31, 2020 1:29:49 PM(UTC)
epf

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 1,209
Switzerland

Thanks: 14 times
Was thanked: 205 time(s) in 198 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

Alain  
#7 Posted : Friday, January 31, 2020 2:13:58 PM(UTC)
Alain

Rank: Member

Groups: Registered
Joined: 1/30/2020(UTC)
Posts: 15
France

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 :-)

:-) :-)

epf  
#8 Posted : Friday, January 31, 2020 4:30:45 PM(UTC)
epf

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 1,209
Switzerland

Thanks: 14 times
Was thanked: 205 time(s) in 198 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#...
Alain  
#9 Posted : Monday, February 3, 2020 8:10:35 AM(UTC)
Alain

Rank: Member

Groups: Registered
Joined: 1/30/2020(UTC)
Posts: 15
France

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
:-)
Users browsing this topic
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.