Skip to Content

Crystal Report will pick multiple transaction.

Good Day,

Please help me to show all transaction and i will choose one of them depend on my paramter

{OCRD.CardCode} = {?Customer@ SELECT * FROM OCRD WHERE CardType = 'C' ORDER BY CardCode} and
{JDT1.BalDueDeb} + {JDT1.BalDueCred}<>0 and
{@ToDate} <= {?ToDate} and
{@FromDate} >= {?FromDate} and
{JDT1.Ref1} = {?Transaction@ Select JDT1.Ref1 from JDT1 where JDT1.Shortname=Customer@}

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Feb 19, 2017 at 08:04 AM

    Hello,

    Please describe your question as its not enough to understand what you exactly looking for.

    Thanks,

    Engr. Taseeb Saeed

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Engr. Taseeb Saeed,

      I have 1 more question, This is my parameter

      Reference@ Select JDT1.Ref1 From JDT1 where (JDT1.Shortname='@Customer') and ( (JDT1.BalDueDeb - JDT1.BalDueCred)<>0)

      How can I display JDT1.Ref1,Balance Due in multiple value selection box. Bec JDT1.RefDate only appears.

      thanks