Parameter and Select expertt

[rwn]

I have a Parameter called Project ID. The purpose is to have the report show data in the Jobs table as per what is entered in the Project ID. However, if no Project ID is entered, I need to have all the data show from that field. The field is User_Values.Text1. So to see all the data I have the user select "ALL". But only data shows if there is data in the Text1 field, it doesn't show any Jobs data if that field is null or empty.

if {?Project ID} = "ALL" then {User_Values.Text1} = {User_Values.Text1}
else {?Project ID} = {User_Values.Text1}

 

[Turkbear]

Hi,
If I understand the issue then try:

if {?Project ID} = "ALL" then 
True
else
{?Project ID} = {User_Values.Text1}

It will bring back all records regardless of the data in the
{User_Values.Text1} field when the ALL option is picked.



To Paraphrase:"The Help you get is proportional to the Help you give.."