Replace function in ssrs

• niha.736

  Ten Centuries

  Points: 1210

  More actions

  January 30, 2013 at 3:31 am

  #288085

  Hi All,

  am using a Stored Procedure in my report, for that I need to pass 3 parameter @string, @storeKey, @language.

  when am running SP in Management studio, am getting resultset, but not in report.

  In report passing those 3 parameters, for store parameter , expression is below.

  I need to pass Storekey value as int 468.

  I have a doubt about the expression result , can anybody tell the result of this expression when my dim members are like this [Store DIM].[Store].&[10] and parameter store value are like M300, M301 so on..

  =Replace(Replace(Join(Parameters!Store.Value,","),"[Store DIM].[Store].&[",""),"]","")

  Thanks,

  Niha

• niha.736

  Ten Centuries

  Points: 1210

  More actions

  February 6, 2013 at 10:08 am

  #1585048

  please share your ideas , upon above expression result.

  3 parameters 'PONDS', '897','EN' should be like this.

  here 897 is store key for [Store DIM].[Store].[897] dimension member.