Thanks again Sandro,
I've read through the querstring macro doc that you linked to, and I know where the "WHERE" input filter is located at, but I do not understand how I am supposed to know what the querystring key is and how I am meant to put it in the "WHERE" input filter. Could you please help with that?
I have used an altered version of the code mentioned above to populate the filter:
<script type="text/Javascript">
function report(SelectedCategories)
{
window.location.search = 'cat='+SelectedCategories;
}
</script>
<table>
<tr>
<div><h1>Select Category</h1>
<select onchange="report(this.value)" name="FilterPrimaryCategory">
<option value="All">View All</option>
{%foreach(category in SiteObjects.Categories){ ResolveMacros("\r\n {%if (category.CategoryLevel ==0) { %}
</select>
Am I meant to just put {%cat%} or {%category%} in the WHERE filter?