SEARCH YOUR SOLUTION HERE  

Decimal format in crystal reports


My db is sql server 2000. I've column Lines decimal(10,2).
The data in this column isn't decently 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 difficulty. Because
of this I am not able to disply decimals.
Pls assist.
Posted On: Wednesday, November 7, 2012 Total Views: 20
View Complete with Replies




Related Messages:

How do you create an empty decimal array - VB 2005  (4 Views)
I'm generating a salary survey for school. I've to generate 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 is my code snippet. Am i on the correct path
' String array stores salary ranges
Dim salaries As String() = New String() { _
"$200-299" "$300-399", "$400-499", "$500-599", _
"$600-699", "$700-799", "$800-899", "$900-999", "1000 +"}
' empty decimal array to store number of employees who earn salies in each range
Dim arrNumbers() As Decimal
View Replies !
Converting decimal to fractions  (2 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 + "0"
...
View Replies !
Exadecimal to decimal conversion  (4 Views)

I'd like to ask if anyone knows the code snippet in Visual Introductory to convert a
exadecimal number to a decimal number and viceversa
View Replies !
Decimal commas instead of decimal points  (3 Views)
Several people in Europe use decimal commas instead of decimal points.
How do u deal By this difficulty I suspect Visual Introductory 6.0 might
know it should read numbers with commas but it does not seem to be
trivial.
This ...
View Replies !
Trouble with decimal point and Country Settings  (3 Views)
Hello

I would like to be able to find out if the PC where my software is
running has got French settings, US settings or any other international
settings.
My concern is to know that character is used (with the current
...
View Replies !
Line up decimal points  (6 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 simple 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  (7 Views)
I need 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  (3 Views)
If Data is: -12.3 -1.23, 0.1, 1.2, 12.3, 1.234
In a column of printed data Is there any method 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 do I replace a hexadecimal string to regular string in text file?   (2 Views)


I have a text file that contains a hexadecimal string see in hex mode "20 00 00 00 00 20" hexadecimal 20 is a space. I want to interchange all hexadecimal 00 to spaces. Could it be done in VB.Net
View Replies !
Hide an hexadecimal number within an executable file  (3 Views)

In a visual introductory .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  (6 Views)
Hello
I'm attempting 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?)  (7 Views)

i want a function to convert angles entered like this 123.2345 so i
can perform math functions like add subtract multiply... I'm having
trouble maintaining precision doing it... i assume i want to receive it into
decimal degrees then ...
View Replies !
Vb6 hex to decimal Overflow  (2 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  (7 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'm using to TRY to receive 101-084
=SUBSTITUTE(DOLLARFR(A1 32), ".", "-") HOWEVER, this returns 101-085 and not 101-084
Any assistance
View Replies !
Convert time to decimal  (6 Views)
Ok i got this difficulty I am trying to generate 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 want to convert the time format into decmial so that i can round it to the nearest half hour worked e.g.
MonIn MonOut Total Hours

7:00:00 11:34:04 4.5
Has someone got any solutions on rounding time to decimal
I have tried just taking away the textbox values

total.Text = Val(mo.Text) - Val(mi.Text) but the formats are various so it returns a 0 value .
View Replies !
removing decimal point only in vba  (6 Views)
I'd like to convert numbers into whole numbers with out removing decimal numbers except the decimal point. this is required by the system I am doing right now. Here is what i wanted to happen:
1437.21 = 143721
1437.00 = 143700Hope u' ll provide attention to my queries.
View Replies !
How do I Convert of ASCII hex number to decimal conversion  (2 Views)
I need to convert ASCII hex number to decimal conversion.
For instance :
1: F01A is converted into Decimal: 61466
2: FFFC64F0 is converted into Decimal: 4294730992
What is the best way to generate a smaller function for the above like conversion.
Please.send me the complete function in VB6[code]
View Replies !
Error when inserting decimal number  (4 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 message" 0 + 64 + 0
wad should i type for the "...." Option Explicit
Private Sub cmdAnswer_Click()
Dim a As Integer, b As Integer, c As String
a = txtOne.Text
b = txtTwo.Text
c = txtThree.Text
Call calculation(a, b, c)
End Sub
Private Sub calculation(a As Integer, b As Integer, c As String)
Select Case c
Case "+"
lblOutput.Caption = a + b
Case "-"
lblOutput.Caption = a - b
Case "*"
lblOutput.Caption = a * b
Case " "
lblOutput.Caption = a b
Case Else
lblOutput.Caption = "invalid"
End Select
End Sub

View Replies !
Round values in text box to two decimal places  (6 Views)
right this is what I have 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 need to have 2 decimal places fundamentally this format XXX. XX
so i used this that normally works
PriceToPay.Text = Format(PriceToPay.Text "000.00") but it still coming out at 4 decimal places when it should only be two with that line of code snippet
ahhh pls assist, i applaud it , Dave
View Replies !
convert from decimal to hexadecimal  (3 Views)
im uncertain this s the best algorithm for conversions (from decimal to hexa) and I have done a set of changes that the code snippet s already a mess.
when execute,the program results no output
any kind of assist comprehended Private Sub BtnHexa_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BtnHexa.Click
Dim c As Integer = 0
Dim Remainder As Integer
Dim HexaArray(c) As Integer
Dim result As Integer
Dim IntegerDiv As Integer
Do While Remainder <> 0
Remainder = IntegerDiv Mod 16
HexaArray(c) = Remainder
IntegerDiv = IntegerDiv 16
result = result & HexaArray(c)
c = c + 1
LoopFor c = 15 To 0 Step -1
If HexaArray(c) >= 10 Then
Select Case HexaArray(c)
Case HexaArray(c) = 10
result = "A"
Case HexaArray(c) = 11
result = "B"
Case HexaArray(c) = 12
result = "C"
Case HexaArray(c) = 13
result = "D"
Case HexaArray(c) = 14
result = "E"
Case HexaArray(c) = 15
result = "F"
TxtBinary.Text = result
End Select
Else
TxtBinary.Text = TxtBinary.Text & HexaArray(c)
End If
NextEnd Sub

View Replies !