You are browsing Visual Basic Forum.
SEARCH YOUR SOLUTION HERE  

Decimal format in crystal reports


My database is sql server 2000. I've column Lines decimal(10,2).
The data in this column isn't properly presented in crystal reports.
Eg: the data in the column is 24.34, it is being presented like
345234352
Why this is so When the data type is int, there is no hardy. Because
of this I am not able to disply decimals.
Please assist.
Posted On: Wednesday, November 07, 2012 Total Views: 32
View Complete with Replies


Hi,

This webpage contains content related to Visual Basic. If question related to " Decimal format in crystal reports" is not helpful or you didn't find the question or answer you were looking for then you can ask a new question through contact form. Our development Team will be happy to help you. This article was posted on Wednesday, November 07, 2012 and having 32 views till Friday, October 24, 2014.

Thank You


Related Messages:

How do you Create an empty decimal array - VB 2005  (22 Views)
I am generating a salary survey for school. I've to Create two arrays; a string with a set list of numbers to be presented in a list box and an empty decimal array to store the number of employess who earn salieries in each range.
Here's my code snippet. Am i on the correct path
' String ar
View Replies !
Converting decimal to fractions  (18 Views)
Dim TempWhole TempDen, TempNum, TempFra as string
Dim TempDec as Double
TempDec = 34.09876
TempWhole = NthField(str(TempDec), ".", 1)
TempNum = NthField(str(TempDec), ".", 1)
TempDen = 1
For I as Integer = 0 to Len(TempNum)
TempDen = TempDen + &quo
View Replies !
Exadecimal to decimal conversion  (20 Views)

I wana to ask if anybody knows the code snippet in Visual Basic to convert a
exadecimal number to a decimal number and viceversa
View Replies !
Decimal commas instead of decimal points  (29 Views)
Many people in Europe use decimal commas instead of decimal points.
How do you deal with this hardy I suspect Visual Basic 6.0 might
know it should read numbers with commas but it does not seem to be
trivial.
This ...
View Replies !
Problem with decimal point and Country Settings  (14 Views)
Hello

I'd like to be able to find out if the PC where my software is
executing has got French settings, US settings or any other international
settings.
My concern is to know which character is used (with the current
...
View Replies !
Line up decimal points  (16 Views)
Dim A as single. The range of A can be any where from 0 .000to 10000.000.
When A is printed a column is there any easy way to have all the decimal
points line up:
12.123
123.123
1.123
1234.123
Now I am ...
View Replies !
decimal to fraction  (43 Views)
I wana to write a program that will take a decimal with up to 4 places
and convert it to 1 16 ths. I can sort of do that with:
n = 375 * 16 1000
Print n; " 16"
I ...
View Replies !
Line up decimal points in print outs  (23 Views)
If Data is: -12.3 -1.23, 0.1, 1.2, 12.3, 1.234
In a column of printed data is there a way to have all the decimal points line
up
using: Format(data,"###0.0##") lines up the first character. It does not even
leave a space ...
View Replies !
Anyone know how can i replace a hexadecimal string to regular string in text file?   (17 Views)


I've a text file which contains a hexadecimal string see in hex mode "20 00 00 00 00 20" hexadecimal 20 is a space. I wana to replace all hexadecimal 00 to spaces. Could it be done in VB.Net
View Replies !
Hide an hexadecimal number within an executable file  (18 Views)

In a visual basic .net 2003 software I use an hexadecimal number to
encrypt a file as a symmetric key.
Is it possible to detect within the executable, the number above to
consequently decrypt the same file
How secure ...
View Replies !
The Hexadecimal System and VB  (20 Views)
Hello
I am trying to understand how VB handles the Hexadecimal system to be sure I
know how can i use the waveoutgetvolume and waveoutsetvolume API's.
Hex(-1) returns FFFF but I know I should get FFFFFFFF.
However Hex(-1#) returns FFFFFFFF.
What is ...
View Replies !
adding and subtracting angles (decimal degrees?)  (48 Views)

i want a function to convert angles entered like this 123.2345 so i
can perform math functions like add subtract multiply... I am having
problem maintaining precision doing it... i assume i wana to get it into
decimal degrees then ...
View Replies !
Vb6 hex to decimal Overflow  (20 Views)
Wanted to know if anybody have example or solution to convert &hB3A73CE2FF2 hex to decimal 12345678901234 to avoid overflow
View Replies !
displaying decimal as 32nd  (25 Views)
Hope to find some assist
A1 has 101.265625
In 32nd's this should be 101-084
in B1 is there a formula I can do to display 101-084
This is the formula i am using to TRY to get 101-084
=SUBSTITUTE(DOLLARFR(A1 32), ".", "-") HOWEVER, this returns 101-085 and not 101-084
Any assist<
View Replies !
Convert time to decimal  (38 Views)
Ok i got this hardy im trying to Create a timesheet simulation in vb as part of a new project im doing. I have tried calculating times in various ways using Adddate and more. I just wana to convert the time format into decmial so that i can round it to the nearest half hour worked e.g.
MonIn Mo
View Replies !
removing decimal point only in vba  (52 Views)
I wana to convert numbers into whole numbers with out removing decimal numbers except the decimal point. this is required by the system i'm doing right now. Here's what i wanaed to happlicationen:
1437.21 = 143721
1437.00 = 143700Hope you' ll give attention to my queries.
View Replies !
How to Convert of ASCII hex number to decimal conversion  (46 Views)
I wana to convert ASCII hex number to decimal conversion.
For Example :
1: F01A is converted into Decimal: 61466
2: FFFC64F0 is converted into Decimal: 4294730992
What is the best way to Create a smaller function for the above like conversion.
Pls.send me the complete function in V
View Replies !
Error when inserting decimal number  (21 Views)
if i wan the user to enter just integer number ...
n a msgbox pop out if user enter decimal number ...
if i use if else loop...
if a ..... then
msgbox "Error" 0 + 64 + 0
wad should i type for the "...." Option Explicit
Private Sub cmdAnswer_Click()
Dim a As Integer, b A
View Replies !
Round values in text box to two decimal places  (20 Views)
right this is what ive got at the moment x = Val(PricePerLitre.Text)
y = Val(Text1.Text)
w = x * y
PriceToPay.Text = (w 100) this gives number like 4.2756 for instance 4 decimal places
i only wana to have 2 decimal places basically this format XXX. XX
so i used this which norma
View Replies !
convert from decimal to hexadecimal  (32 Views)
im not sure this s the best algorithm for conversions (from decimal to hexa) and i've done a set of alters that the code snippet s already a mess.
when run,the program results no output
any kind of assist applicationlaudd Private Sub BtnHexa_Click(ByVal sender As System.Object, ByVal e As
View Replies !