Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Optional parameters in Crystal XI R2

Hi,

I have to create optional parameters in CR XI R2. The column names in database are not nullable. Hence I do not get the check for null button.

I want the parameters to be such that even if user doesnt select some parameters, and runs it only for the date range(mandatory) it will work.

I have created the following if else statements to pass default values. It works for only the first filter criterion and ignores the rest. Its not nested if else, so its failing.

Let me know if anyone has any other idea how to achieve this or if you can identify the flaw in the below logic.

if ({?S1FNAM} = "abc") then True else ({FILM.FSNAME} = {?S1FNAM})

and if ({?S1FLNO}= 0) then True else ({FILM.FFILNO} = {?S1FLNO})

AND if ({?S1CLNO}= 0) then True else ({NAME.NNAMNO} = {?S1CLNO})

AND if ({?S1CLNM}= "") then True else ({NAME.NSNAME} = {?S1CLNM})

AND if ({?S1THNO}= 0) then True else ({BSUP13.B2THNO} = {?S1THNO})

AND if ({?S1THNM}= "") then True else ({THEA.TSNAME} = {?S1THNM})

AND if ({?S1SALZ}= "") then True else ({BSUP13.B2SALZ} = {?S1SALZ})

AND if ({?S1CIRC} = 99999) then True else ({BSUP13.B2CIRC} = {?S1CIRC})

AND if ({?S1BRAN} = "") then True else ({BSUP13.B2BRAN} = {?S1BRAN})

AND if ({?S1TERM} = "") then True else ({BOOK.BBTERM} = {?S1TERM})

Thanks!!

replied

Hi Shalu,

Great !!!

Thanks,

Sastry

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question