Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Replace function in ssrs Expand / Collapse
Author
Message
Posted Wednesday, January 30, 2013 3:31 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, February 04, 2014 8:11 AM
Points: 78, Visits: 233
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
Posted Wednesday, February 06, 2013 10:08 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, February 04, 2014 8:11 AM
Points: 78, Visits: 233
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 »

Add to briefcase

Permissions Expand / Collapse