Home » DbVisualizer Forums » DbVisualizer » DbVisualizer - Support

Thread: Display amount without exponent in Table Col

This question is answered. Helpful answers available: 2. Correct answers available: 1.


Permlink Replies: 8 - Pages: 1 - Last Post: Oct 16, 2011 10:42 AM Last Post By: zaj
zaj

Posts: 39
Registered: 09/21/11
Display amount without exponent in Table Col
Posted: Oct 5, 2011 11:40 AM
 
   thread.click_reply Reply
 global.attachment d3.gif (20.8 KB )
Hi there,

please see shot

cheers
Zolf
Roger Bjarevall


Posts: 5,172
Registered: 12/17/04
Re: Display amount without exponent in Table Col
Posted: Oct 5, 2011 11:53 PM    global.in_response_to.tooltip in response to: zaj
 
   thread.click_reply Reply
Zolf,

What database are you using and what is the data type definition of the column that show exponent data?

Also what are the settings in the Tools Properties->General->Data Formats?

Regards

Roger
zaj

Posts: 39
Registered: 09/21/11
Re: Display amount without exponent in Table Col
Posted: Oct 8, 2011 9:17 AM    global.in_response_to.tooltip in response to: Roger Bjarevall
 
   thread.click_reply Reply
 global.attachment d4.gif (67.3 KB )
Hi Roger,

please see screenshot.

cheers
Zolf
Roger Bjarevall


Posts: 5,172
Registered: 12/17/04
Re: Display amount without exponent in Table Col
Posted: Oct 8, 2011 11:01 AM    global.in_response_to.tooltip in response to: zaj
 
   thread.click_reply Reply
Zolf,

So it is a Float column.

What are the settings in the Tools Properties->General->Data Formats in DbVisualizer?

Regards

Roger
zaj

Posts: 39
Registered: 09/21/11
Re: Display amount without exponent in Table Col
Posted: Oct 8, 2011 11:27 AM    global.in_response_to.tooltip in response to: Roger Bjarevall
 
   thread.click_reply Reply
 global.attachment d5.gif (31.7 KB )
Roger,

i have attached the properties setting
Roger Bjarevall


Posts: 5,172
Registered: 12/17/04
Re: Display amount without exponent in Table Col
Posted: Oct 12, 2011 7:30 PM    global.in_response_to.tooltip in response to: zaj
 
   thread.click_reply Reply
Zalf,

The unformatted behavior for Float is with exponent displayed.

To have another format please visit Tool Properties->Data Formats and supply your own pattern for Decimal Numbers

Regards

Roger
zaj

Posts: 39
Registered: 09/21/11
Re: Display amount without exponent in Table Col
Posted: Oct 13, 2011 7:50 AM    global.in_response_to.tooltip in response to: Roger Bjarevall
 
   thread.click_reply Reply
Roger,

To have another format please visit Tool Properties->Data Formats and supply your own pattern for Decimal Numbers

can you please give me an example

Roger Bjarevall


Posts: 5,172
Registered: 12/17/04
Re: Display amount without exponent in Table Col
Posted: Oct 14, 2011 6:41 PM    global.in_response_to.tooltip in response to: zaj
 
   thread.click_reply Reply
Zalf,

Open Tools->Tool Properties, then select the General->Data Formats category and then apply the appropriate format for Decimal Numbers. You will also see an example of the result.

Regards

Roger
zaj

Posts: 39
Registered: 09/21/11
Re: Display amount without exponent in Table Col
Posted: Oct 16, 2011 10:42 AM    global.in_response_to.tooltip in response to: Roger Bjarevall
 
   thread.click_reply Reply
Roger,

cheers, it worked

Point your RSS reader here for a feed of the latest messages in all forums