CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2001
    Location
    Portugal
    Posts
    26

    VB6+SQL7+CR8=Decimal Problem

    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.



  2. #2
    Join Date
    Feb 2010
    Posts
    11

    Re: VB6+SQL7+CR8=Decimal Problem

    I´m facing the same problem. Did you solved it?

  3. #3
    Join Date
    Jan 2006
    Location
    Fox Lake, IL
    Posts
    15,007

    Re: VB6+SQL7+CR8=Decimal Problem

    Don't dig up NINE YEAR OLD THREADS please!
    David

    CodeGuru Article: Bound Controls are Evil-VB6
    2013 Samples: MS CODE Samples

    CodeGuru Reviewer
    2006 Dell CSP
    2006, 2007 & 2008 MVP Visual Basic
    If your question has been answered satisfactorily, and it has been helpful, then, please, Rate this Post!

  4. #4
    Join Date
    Feb 2010
    Posts
    11

    Re: VB6+SQL7+CR8=Decimal Problem

    Ok. I´ll post a new one. But then people will complain that I´m repeating topics...

    So... should I bother you or them? That´s a hard one.

    I wouldn´t dig it up if it was closed issue. But it´s not.

    There is no need to yell, or are you a nine years old girl?

  5. #5
    Join Date
    Jan 2006
    Location
    Fox Lake, IL
    Posts
    15,007

    Re: VB6+SQL7+CR8=Decimal Problem

    No. The original poster left it unresolved. Only a MODERATOR can CLOSE a topic (mostly because of abuse)
    David

    CodeGuru Article: Bound Controls are Evil-VB6
    2013 Samples: MS CODE Samples

    CodeGuru Reviewer
    2006 Dell CSP
    2006, 2007 & 2008 MVP Visual Basic
    If your question has been answered satisfactorily, and it has been helpful, then, please, Rate this Post!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  





Click Here to Expand Forum to Full Width

Featured