Results 1 to 3 of 3

Thread: Passing a datetime field as a parameter to Cyrstal Reports

  1. #1

    Thread Starter
    New Member
    Join Date
    Oct 2000
    Posts
    5

    Thumbs down

    I need to pass a datetime field to crystal reports as a parameter. I used thecdate function to convert a string datetime value to a date field in VB. But, as the vb datatype is date and cr datatype is datetime.I am getting an error. How do I solve it

  2. #2
    Guest
    You could use something like that:
    Dim Param$
    Dim dates1 As String

    dates1 = Format(meDate1, "YYYY, MM, DD")
    'where meDate1 is the name of MaskEditBox where you enter your date

    Param = "{YourQuery.Date1} in Date (" & dates1 & ") to Date (" & dates1 & ")"
    'YourQuery -is the name of your table/query
    'Date1 -is the field is your table with date

    Call View_Report("Your_Report.rpt", True, Param)

    'code for View_report I posted couple days earlier



  3. #3
    Hyperactive Member nazeem_khan's Avatar
    Join Date
    Nov 2002
    Location
    India
    Posts
    305

    well..

    I tried searching your post but i couldnt find.. can u send me the thread link

    Thanks in advance

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