Help with when to display data

[hopkinsc]

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..

[#2]

Hi

Here you can do it.

General tab

Calculation Condition.

Anders

[hopkinsc]

Thanks, But what condition would i type?

[#4]

Hi

I have done it when one have to select only one country.

count

Maybe that can help you

Anders

(distinct(COUNTRYNAME)) = 1

[hopkinsc]

Hi 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..

[#6]

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

[#7]

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,','))

[#8]

the previous post is messed up, so once again (hope it will be better now ;):

• not IsNull(GetFieldSelections(REGIONAL MANAGER,',')) And not IsNull(GetFieldSelections(RETAILER NAME,','))