...it's me...eRiCk

if ur query return like this 123456789 and u want to put decimal to it try this query SELECT CONVERT(VARCHAR(100),CONVERT(MONEY, 123456789), 1) from BOL The following table shows the values for style that can be used for converting money or smallmoney to character data. Value Output 0 (default) No commas every three digits to the left of the decimal point, and two digits to the right of the decimal point; for example, 4235.98. 1 Commas every three digits to the left of the decimal point, and two digits to the right of the decimal point; for example, 3,510.92. 2 No commas every three digits to the left of the decimal point, and four digits to the right of the decimal point; for example, 4235.9819. hope this help see u

if anyone interested what ';' (semicolon) does, here is some explanation.. i've been debug SPROC for 2 hours and it ended up found that someone use semicolon so that the line after that executed as new query :( i read it from here

i have a hard time trying to solve this one scenario: at first, we using Letter format to print Delivery Order and Invoice..it run smoothly and in CR we just using Letter as the Page Setup.. now new paper format is coming which is half of the Letter size at first i thougt it is easy because we only need to create new paper size on Server Properties under Printer and Faxes then use the new size at Paper Size in CR then redesign it to fit but it all when wrong, eventhough it display correctly but when i want to print it, it turn up everything that vertical become horizontal..very2 strange behaviour so i give using CR.PrintReport method..i ended up format it to .rtf then print it using this code Dim oDoc As New ReportDocument Dim sFileName As String = String.Empty oDoc.Load(_ReportPath) 'must use this line to make sure it print using the new size 'credit goes to Ali from dotnet.netindonesia.net Dim printDoc As System.Drawing.Printing.PrintDocument = New System.Dra

if anyone interested..:D u can take a look at this after that, after u install TFS then u must install TFS TeamExplorer first, because i installed it at the very last time and it didn't work for me.. need 4 hours to googling it :(