i have a straight table that i only want to populate with results when selections have been made from my selection criteria.
Here is an explanation of what i am trying to do...
I have a RETAILER SELECTION where the user selects 1 or more selections i,e. RETAILER NAME, REGIONAL MANAGER, SOFTWARE VERSION, CUSTOMER TYPE etc
Once at least 1 selections have been made, my STRAIGHT TABLE populates with various retailer information.
I only want the straight table to populate AFTER a selection has been made. So until a selection is made, the straight table will be blank.
Is this easy to do?
Thanks for your help..
That worked, but if i select more than one of the retailer options, it hides all results.
I want it to show results if 1 OR MORE selections have been made, not show results if only 1 selection have been made.
I have tries using <=0 but with no luck..
I think you should write this as Condition:
Count(distinct RETAILER NAME )>= 1
Or Count(distinct REGIONAL MANAGER) >= 1
Or Count(ditinct SOFTWARE VERSION) >= 1
I hope it helps.
You should actually try this way:
And not IsNull(GetFieldSelections(REGIONAL MANAGER,','))
This is a better way, because the previous version did not work if nothing was selected...
the previous post is messed up, so once again (hope it will be better now ;):