Hi Peter,
Thanks for getting back to me.
Basically I have a block on the front page which is only visible to Administrators, I have a report listed which shows a list of courses that have checklists etc, this is quite a complicated query and just seems very heavy when I run the report
Now, if I have a where clause in there with something like "WHERE c.fullname = 'Course 101'" the report runs fine.
Now, I need this report to see all courses but only 1 course at a time.
What I would like to be able to do is click on the report, they query does not run until I select a course from the dropdown list and click Apply.
I hope this makes even an ounce of sense.
TIA G!