SSRS: wildcard filter tablix

janhoedt
janhoedt used Ask the Experts™
on
Hii,

I have 2 tablix in SSRS report, building on same dataset:

Tablix1 should show all values which NOT HAVE Code containing
-UAT%
-DEPLOY%
-PUBLISH%
someothervalues

Second tablix should have everything which is not appearing in Tablix1 .

Can't make the wildcards work
Note: with the Tablix filters, I can add Expression Code, operator <> then UatStatusOK etc but not UAT%

J
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Technical Director
Commented:
CReate two temp tables with the data you want and assign to respective tablix

Author

Commented:
Why should I generate two tables? It is administrative overhead and is of no use. Unless it is no possible what I ask?

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial