Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2006
    Posts
    2

    Unanswered: Crystal Reports selectionformula

    Hi to All
    Does anyone know how to change the ax.selectionformula
    if i tray

    cCODE = form.ENTRYFIELD3.value
    aYDATE = STR(YEAR(form.ENTRYFIELD1.value ))
    aMDATE = STR(MONTH(form.ENTRYFIELD1.value))
    aDDATE = STR(DAY(form.ENTRYFIELD1.value ))

    eYDATE = STR(YEAR(form.ENTRYFIELD2.value ))
    eMDATE = STR(MONTH(form.ENTRYFIELD2.value))
    eDDATE = STR(DAY(form.ENTRYFIELD2.value ))

    ax.selectionformula = "{ktrn.KTR_DATE} in Date (&aYDATE, &aMDATE, &aDDATE) ;
    to Date (&eYDATE, &eMDATE, &eDDATE) ;
    AND {ktrn.CODE} = 301121 "
    ALL OK

    -----------------------------------------

    if cCODE = form.ENTRYFIELD3.value
    OR
    cCODE = 301121 !!!!!!! NOT WORK !!!!!!!
    ------------------------------------------
    aYDATE = STR(YEAR(form.ENTRYFIELD1.value ))
    aMDATE = STR(MONTH(form.ENTRYFIELD1.value))
    aDDATE = STR(DAY(form.ENTRYFIELD1.value ))

    eYDATE = STR(YEAR(form.ENTRYFIELD2.value ))
    eMDATE = STR(MONTH(form.ENTRYFIELD2.value))
    eDDATE = STR(DAY(form.ENTRYFIELD2.value ))

    ax.selectionformula = "{ktrn.KTR_DATE} in Date (&aYDATE, &aMDATE, &aDDATE) ;
    to Date (&eYDATE, &eMDATE, &eDDATE) ;
    AND {ktrn.CODE} = cCODE "

    Thanks.
    John

  2. #2
    Join Date
    Sep 2006
    Posts
    2
    note
    this program in dBase 7.5

    ax.selectionformula = "{ktrn.KTR_DATE} in Date (&aYDATE, &aMDATE, &aDDATE) ;
    to Date (&eYDATE, &eMDATE, &eDDATE) ;
    AND {ktrn.CODE} = &cCODE " !!! Not work !!!!!

    Thanks
    John

Posting Permissions

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