SSRS Alpha Numeric value Search

61 Views Asked by At

My SSRS report is connected to SSAS. I have a parameter called Plant Code. In data base my plant code is in alpha numeric format like '02plant123'. Wen i search the report with a plant code the following error occurs 'plant123' not fount and by default the numerics before the text are getting removed. what kind of conversions are to be made in my MDX so that the numerics are also considered?

0

There are 0 best solutions below