Don't understand your question completly but if you're asking how to use the like-clause in SQL server the answer is

not like 'ZAR%'

If you mean an RS-expression its

=iif(condition, true-expression, false-expression)

Apparently, this has somthing to do with the fact that I used the global parameter UserID.

Once I left that out of the report it works fine.

Why? Beats me.

I even have...

It's supposed to work.

Look for info on

http://www.microsoft.com/technet/community/newsgroups/dgbrowser/en-us/default.mspx?dg=microsoft.public.sqlserver.reportingsvcs

I have to add that I've tried it several times, but I can't get it to work. I now write the SQL directly

Not really, I could solve it all by creating special tabeles that allow for fast access. But the appeal of RS was the possibility to cache these reports, and not...

These parameters are not query-parameters, but filter-parameters. But rendering from a snapshot still takes a lot of time (it is a lot of data and a complex report).

Linked reports is...