Results 1 to 2 of 2

Thread: Crystal reports 8 and Vb??

  1. #1

    Thread Starter
    Member
    Join Date
    Aug 2000
    Posts
    54
    I want to run two reports based on parameters in the report which are dates entered in at the beginning of my program and bypass crystal reports prompts..

    All I can seem to do is set it so that the report still prompts up but with the dates I put in as the default. And to make my life even worse I cant seem to even pass a string variable into the parameters so i have to actually type in the dates in to pass them to the report.

    Heres the code for my nightmare..

    Fdate = c & " ," & a & " ," & b
    Tdate = f & " ," & d & " ," & e

    cr.ParameterFields(0) = "Frdate; Date(Fdate),; FALSE"
    cr.ParameterFields(1) = "Todate; Date(Tdate),; FALSE"
    cr.Action = 1

  2. #2
    Fanatic Member Jerry Grant's Avatar
    Join Date
    Jul 2000
    Location
    Dorset, UK
    Posts
    810
    Remove the parameter fields from the report and use the CR SelectionFormula to pass the date variables to a report from VB. See the Formula builder in CR for syntax.
    Jerry Grant................tnarG yrreJ
    Website: <JG-Design></.net>
    Email: [email protected]
    Working towards a bug free world......
    (Not a Microsoft employee)

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