Crystal Report will pick multiple transaction.

[former_member264311]

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@}

[Former Member · Accepted solution]

Hello,

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

Thanks,

Engr. Taseeb Saeed

[former_member264311 · Accepted solution]

Hi Taseeb,

Im looking for a parameter will display all reference no. and will choose what transaction I will print. Like in Incoming payment. Bec. Im creating Statement of Account. But my parameter was Date from and to. and Cardcode. but i want to choose what transaction on that particular customer to print. Like screenshot below but there's no transaction appears :(.

Thank you

[Former Member · Accepted solution]

Hellom

Please share the code you are using for transaction parameter.

Thanks,

Engr. Taseeb Saeed

[former_member264311 · Accepted solution]

Hi Engr. Saeed

Thanks for the reply. Please see my codes below. My requirements is when i select BP Code and Date from and to and when i open transaction will show all JDT1.Reference on that particular BP and date range.

Thanks

{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}

[Former Member · Accepted solution]

Hello,

Please try to modify your parameter query as per following example.

Country@SELECT distinct Country FROM OCST
State@SELECT code, name FROM OCST WHERE (Country = '@Country')

In sample code state is filtered on basis of country parameter.

Hope this will help you alot.

Thanks,

Engr. Taseeb Saeed

[former_member264311 · Accepted solution]

Hi Engr. Saeed,

Thank you so much. What a big help. But how can I make not a drop down list instead like a combox in parameter Country@ in your sample parameter?

[former_member264311 · Accepted solution]

Hi Engr Taseeb Saeed,

Please help me to solve my problem. Please visit link below.

https://answers.sap.com/questions/131299/crystal-report-sum-case-when.html

[former_member264311 · Accepted solution]

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