Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

VB6+SQL7+CR8=Decimal Problem

Status
Not open for further replies.

jpfo

Programmer
Feb 11, 2002
6
0
0
PT
Hi all,

I have a crystal report with a stored procedure. No problem...

When i preview the report in the design time( in crystal report 8 ) all decimal values are OK, but when i see it in run mode ( call it in VB6 ) all the decimal are set to ",00"!?

The stored Procedure must be OK and the report too (since its seems ok in preview mode...)

In VB i dont see what is wrong since i just give a parameter that just dont have nothing to do with the decimals values ,or the output field itself ... like :

.Parameters.Append .CreateParameter("@Empresa", adVarChar, adParamInput, 2, sEmpresa).

and when i call the report nothing seems wrong...

crrReport.Connect = ConnReport
crrReport.DiscardSavedData = true
crrReport.StoredProcParam(0) = sTContr
crrReport.Destination = crptToWindow
crrReport.WindowState = crptMaximized
crrReport.WindowShowPrintSetupBtn = true
crrReport.Action = 1

Can anyone explain this to me...
Thks in advance.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top