When using the %%FILTER_USERS for moodle 1.9 version
To reproduce: create a SQL report, use this code:
SELECT u.username, u.firstname, u.lastname
FROM prefix_user u
%%FILTER_USERS:u.firstname%%
when i click over View report it shows blank page even though data available in moodle DB