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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics