InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comMon, 17 Jun 2013 22:36:11 GMT20http://www.sqlservercentral.com/Forums/Topic1413549-147-1.aspxplease 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.Wed, 06 Feb 2013 10:08:41 GMTniha.736http://www.sqlservercentral.com/Forums/Topic1413549-147-1.aspxHi 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,NihaWed, 30 Jan 2013 03:31:49 GMTniha.736