Replace function in ssrs

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Business Intelligence » Replace function in ssrs

Replace function in ssrs

Rate Topic

Display Mode

Topic Options

Author

Message

niha.736

Posted Wednesday, January 30, 2013 3:31 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 #1413549

niha.736

Posted Wednesday, February 06, 2013 10:08 AM

Valued Member

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

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.

Post #1416628

« Prev Topic | Next Topic »

Permissions