Skip to Content
0

Crystal Report will pick multiple transaction.

Feb 17, 2017 at 09:20 AM

107

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

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

Hello,

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

Thanks,

Engr. Taseeb Saeed

Show 7 Share
10 |10000 characters needed characters left characters exceeded

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

try.png (22.5 kB)
0
Former Member
Romel Catalogo

Hellom

Please share the code you are using for transaction parameter.

Thanks,

Engr. Taseeb Saeed

0

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}


0
Former Member
Romel Catalogo

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

1

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?

0

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

0

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

0