Replace function in ssrs report

• niha.736

  Ten Centuries

  Points: 1210

  More actions

  January 30, 2013 at 3:59 am

  #273466

  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:04 am

  #1585044

  Hi , please share your ideas about above expression result..

• Sean Lange

  SSC Guru

  Points: 286590

  More actions

  February 6, 2013 at 10:10 am

  #1585051

  Duplicate post. Direct replies here. http://www.sqlservercentral.com/Forums/Topic1413549-147-1.aspx

  _______________________________________________________________

  Need help? Help us help you.

  Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

  Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

  Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
  Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
  Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
  Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

• niha.736

  Ten Centuries

  Points: 1210

  More actions

  February 7, 2013 at 1:35 am

  #1585245

  Hi, I need to convert a multi valued parameter string value into int/number. example:

  parameter value is [Land DIM].[Land].&[567], [568],[569]....

  but out of this value i just need to pass 567, 568, 569.. values to another parameter in SSRS expression.

  How can we achieve this, please help me in this

  Thanks,

  Niha