The community edition of Reportserver.net provide a large number of useful functions. This include managing user access, download in different formats, user freedom to customise the report and access from different databases.
Here is an example of string query with wildcard and parameters. The $P{email} is a parameter where you can enter a value.
SELECT user_id, email, registration_id, date, venue, type, status
FROM student_registration
WHERE email LIKE '%'||$P{email}||'%'
Another example to apply parameter ${timezone} which is the default handling of variable, in this case to add with date from created_at
SELECT user_id, email, registration_id, created_at::timestamp + ${timezone}::interval as created_at
FROM student_registration