Advice would probably be creating a specific report that only allows selection of a single customer but I'll put it out there just in case there is a creative solution. We have a report with a few bar charts showing sales figures by product category. Users can filter by country, customer, sales rep, period, etc... A user wants the report to display the name of the customer in a text field in the report only if filters applied returns a single customer (e.g. a single customer id is selected). As Text object only returns numeric fields or parameter variables, I was not able to use the Text object. However, I was able to use a list control and apply Rank of Top 1 to return the name of a single customer. This works well if a customer ID is selected and there is only a single account returned. However, there is no way I could use an aggregation (count distinct of customer id returned) in my Advanced Filter to only display the customer name if only a single customer is returned.
... View more