Hi guys,
I know there are numerous threads explaining how to create a prompt to dynamicaly select the columns of a list.
However, what I want is the following:
Suppose I have a list with columns like this
Customer 2010 2009 2008 2007
Now I want a prompt on years where If I select 2007 all columns are shown, and when I select 2009 only 2010 and 2009 are shown
The same prompt is also used to filter the data of the report
Any help is appreciated
are you looking for a solution to query all the columns anyways and display only columns based on the prompt,
Yes, exactly.