Skip to Content

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

how to pass all values to subreport in crystal reports

how to pass all values to subreport in crystal reports. I have a parameter which has default value 'All', I want to pass to sub report. How to pass it?

I am passing through sub report link , I am getting zero value instead of showing all values in the report.

thanks

Former Member
Former Member replied

If Parameter can only have value 'All' or another single value this should work

IF {?p}= 'ALL' AND {?pl1}='ALL' THEN

{pole_.polename} LIKE '' AND {pole_.pl1} LIKE ''

ELSE IF {?p}='ALL' AND {?pl1} <> 'ALL' THEN

{pole_.polename} LIKE '*' AND {pole_.pl1}={?pl1}

ELSE IF COUNT({pole_.polename})=1 AND {?pl1}='ALL' THEN

{pole_.polename}={?p} AND {pole_.pl1} LIKE '*'

ELSE IF COUNT({pole_.polename})=1 AND {?pl1} <> 'ALL' THEN

{pole_.polename}={?p} AND {pole_.pl1}={?pl1} ELSE

FALSE

Ian

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