You are browsing Visual Basic Forum.
SEARCH YOUR SOLUTION HERE 



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 Wednesday, April 23, 2014.
Thank You

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 !

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 !

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 !

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 !

displaying decimal as 32nd (25 Views)
Hope to find some assist A1 has 101.265625 In 32nd's this should be 101084 in B1 is there a formula I can do to display 101084 This is the formula i am using to TRY to get 101084 =SUBSTITUTE(DOLLARFR(A1 32), ".", "") HOWEVER, this returns 101085 and not 101084 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 !



