how to use like with parameter in report

Is it possible to use a parameter with like in the sql query of a report? I can't seem to get it to work.

report

Hi Lawrence

When doing reports in Kentico, it is sometimes worth checking the out of the box reports, you might find a similar scenario.

E.g. The report under Page reports -> Content inventory report uses the following like condition:

WHERE (@name IS NULL OR DocumentName LIKE '%'+@name+'%')

Does this work for you?

1 votesVote for this answer Unmark Correct answer