Hi everyone

 

I have a field in my database that has a whole load of different values many of which can logically be grouped together.

 

I can create a formula that will take whatever is in that field and convert it, leaving me with a field that has 100's of distinct values and a formula based on it which only has 10 distinct values.

 

Now I want the user to be able to filter the report based on that formula.  Is there anyway to achieve this as a dynamic parameter?

 

I realise that I could set it up as a static parameter, but I always try to avoid this where possible.

 

Kind Regards

 

Nick

 

nick