Filtering a Tablix issue
Dear all,
I am trying to use the LIKE operator on my tablix. For that I am using the following
Filter expression: =Fields!A.Value
Filter operator: LIKE
Filter value: rpt*
alternatively: ="rpt*"
This works and return all fields value starting by "rpt", but I do not want all field value starting fro rpt but part of them.
My Fiels.Value content is containing string that have follwoing format :
rpt#StartReel1
rpt#StartReel2
rpt#StartReel3
rpt#EndReel1
rpt#EndReel2
rpt#EndReel3
from this set I need to retriev only rpt#Start but if I apply rpt#Start* to the previous filter value I get no return.
It looks like the # caracter cause trouble.
Any idea ?
Thnaks for help
regards
Serge
Your knowledge is enhanced by that of others.
November 12th, 2010 10:45am
The # caracter was causing trouble. Why I don't know but replacing works okYour knowledge is enhanced by that of others.
Free Windows Admin Tool Kit Click here and download it now
November 12th, 2010 3:22pm
Hi Serge,
I agree with you. It looks like the # character cause the issue. It seems to be a product issue, you can submit a feedback at
https://connect.microsoft.com/sqlserver
Currently, another solution to return only the records that are started from "rpt#Start" is that:
Filter Expression: =InStr(Fields!A.Value, "rpt#Start")
Type: Integer
Filter Operator: =
Filter Valule: 1
The InStr returns an integer specifying the start position of the first occurrence of one string within another.
If you have any more questions, please feel free to ask.
Thanks,
Jin ChenJin Chen - MSFT
November 15th, 2010 12:31am