Replace function in ssrs report

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Reporting Services » Reporting Services 2008 Development » Replace function in ssrs report

Replace function in ssrs report

Rate Topic

Display Mode

Topic Options

Author

Message

niha.736

Posted Wednesday, January 30, 2013 3:59 AM

Valued Member

Group: General Forum Members
Last Login: Friday, May 17, 2013 11:15 AM
Points: 68, Visits: 205

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

Post #1413556

niha.736

Posted Wednesday, February 06, 2013 10:04 AM

Valued Member

Group: General Forum Members
Last Login: Friday, May 17, 2013 11:15 AM
Points: 68, Visits: 205

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

Post #1416624

Sean Lange

Posted Wednesday, February 06, 2013 10:10 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Today @ 2:33 PM
Points: 8,620, Visits: 8,261

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 Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs

Post #1416631

niha.736

Posted Thursday, February 07, 2013 1:35 AM

Valued Member

Group: General Forum Members
Last Login: Friday, May 17, 2013 11:15 AM
Points: 68, Visits: 205

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

Post #1416865

« Prev Topic | Next Topic »

Permissions