Answers

According to your description, you have issues with parameter, when you select "All", it returns nothing in report. Right?

In this scenario, it seems you specify some values as Available Values, so when you select "All", it can't return any record which the Fruit called "All". We suggest you just allow multiple values in your parameter so that you can "select All" in the parameter
dropdown list. Add a filter on chart and it will display the values in this chart based on this selection.

All replies

According to your description, you have issues with parameter, when you select "All", it returns nothing in report. Right?

In this scenario, it seems you specify some values as Available Values, so when you select "All", it can't return any record which the Fruit called "All". We suggest you just allow multiple values in your parameter so that you can "select All" in the parameter
dropdown list. Add a filter on chart and it will display the values in this chart based on this selection.

Thanks Simon. Sorry for the late reply. Yes the solution sounds fine. I was trying the earlier method as I have to display the selected prompt value when the report is generated. When the prompt is having many values with long names it becomes a long string.
However, it has its benefits too in selecting multiple values. Having said that please let me know if there is another way out. Thanks again.