Page Comparison

{anchor:top}
{toc: class=contents}
h2. Overview
{styleclass: Class=topLink}[top|#top]{styleclass}
In order to ensure that *User Prompt* filter value selection is as easy as possible for the user, it's a good idea to cache your filters, creating lists, rather than prompting them to enter values manually.

It's also helpful to create dependencies between filters that are related. For example, if you have a *Product Type* and *Product Code* filter, making the Product Code dependent on Product Type will allow the user to nominate a type, and only see the products that belong to that type, rather than the whole list. 

h2. Setup
{styleclass: Class=topLink}[top|#top]{styleclass}
# Add the required filters to your report
## Make sure the filters are listed in order of dependency; this will make it clearer to the user.
## Leave the filters as User Prompt so they are available for the user.
!0101addFilters.png|thumbnail,border=1!
In this example, we've used the Camp Region, Camp - Geo Country, and Camp DemographicName as filters, all set to In List in order to allow the user to select multiple values if required.
# Cache the top level filter of the dependency structure
## On the *Data* Reportor Preview*Output* pagestep, click on the Filters*Filter Formatting* menu at the top of the menu ribbon.
## Select the top level filter from the drop down list provided.
## Open the *Entry Style* menu, set the *Entry Type* to Drop-Down *Value List Selection*, and the values to be *Cached Values*.
## Click *Refresh Now* to generate a list of values for the filter and Save.
!0202level1.png|thumbnail,border=1!
# Set the second level filter to be dependent on the top.
## While in the Filter FiltersFormatting menu on the Report Preview page, select the second level filter from the filters providedlist dropon downthe listleft.
## Open the *Display* menu and set the *Display Dependant On* value to the top level filter. Save.
!0303level2dependant.png|thumbnail,border=1!
# Cache the second level filter as before
## Repeat step 2 instructions for this filter
!0403level2cache.png|thumbnail,border=1!
When{color:#CC0000}*Note:*{color} when the dependency and caching is set up correctly, the second filter will be hidden until a value for the first filter has been selected. Each time values for the first filter are changed, the second filter value list should be refreshed.
# Set the dependency for remaining levels
## For each of the remaining filter levels, you will need set the dependency to the filter level directly above it, and then cache the filter.
!04level3dependant.png|thumbnail,border=1!
!04level3cache.png|thumbnail,border=1!
Once you've completed these steps, you should have filters available on your report that should display once the level above has a selection, and should refresh when that selection is changed. 
In this example, *Europe* has been selected as the !05Region, and the Countries there are records in the database for have been displayed in the second level filter.
!05useLevel1.png|thumbnail,border=1!
In this example, you can see that Camps in Austria cover the Adventure, Culture, Family, Relaxation, and Sport camps, whereas the German Camps only cover Adventure, Culture, and Sport.
!06Next, *Germany* has been selected as the Country, so all the sites within Germany have been displayed.
!05useLevel2.png|thumbnail,border=1!
Finally, the user defines which sites they wish to view and applies the filters.
!05useLevel3.png|thumbnail,border=1!
 
\\
\\
{horizontalrule}
{styleclass: Class=topLink}[top|#top]{styleclass}