Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Parameters results: How to display string "Numerous" when more then 6

Status
Not open for further replies.

awaria

IS-IT--Management
Sep 16, 2010
100
US
My report has several parameters that display the parameter selections in the header. It gets ugly when one or more of the parameters has numerous results, such as user selects ALL and
there are thousands of records now listed in parameter header.

I need help with code in the parameter in the header to display the string or word "Numerous" when the results in total are more then, let's say 6.

Appreciate your input and assistance.

Thanks,

Andrew
 
Maybe something like this?

=IIF(Parameters!YourField.Count > 6,"Numerous",JOIN(Parameters!YourField.Value,", "))
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top