CODEWITHSUNDEEP
crystal-reports
lukesky
lukesky

Reputation: 29

Crystal Reports Optional parameter

I need to display data from column "user_id" which is a main column and column "pocket". User can have many pockets. My input parameters are *user_id and pocket_id.

User_id is mandatory and if there is no pocket_id in input parameter report should display all user_id pockets. But if ther is particular pocket_id report should display user_id and pocket_id from input parameters.

And I should do it without hasValue parameters because its return error in my database. and if I use is null construction data isn't complete.

my current code is:

If isnull{?Pocket ID} then {PocketID}else {?Pocket ID}

Thank you in advance

Upvotes: 0

Views: 436

Answers (1)

Siva
Siva

Reputation: 9101

Change like this

If isnull{?Pocket ID} then {PocketID}={PocketID} else {PocketID} in {?Pocket ID}

Upvotes: 1

Related Questions