Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
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..
Hi
Here you can do it.
General tab
Calculation Condition.
Anders
Thanks, But what condition would i type?
Hi
I have done it when one have to select only one country.
count
Maybe that can help you
Anders
(distinct(COUNTRYNAME)) = 1Hi again,
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.
Any ideas?
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.
Regards,
Miha
You should actually try this way:
not
And not IsNull(GetFieldSelections(REGIONAL MANAGER,','))
...
This is a better way, because the previous version did not work if nothing was selected...
Regards,
Miha
IsNull(GetFieldSelections(RETAILER NAME,','))the previous post is messed up, so once again (hope it will be better now ;):