WITH

MEMBER [Measures].[Month_to_Show] AS CASE WHEN [Date].[YQM].CURRENTMEMBER.MEMBER_CAPTION = "2011" THEN "2011 AVERAGE" ELSE [Date].[YQM].CURRENTMEMBER.MEMBER_CAPTION END

MEMBER [Measures].[Year_2011_AvgUnits] AS SUM([Date].[YQM].[Year].&[2011],[Measures].[Exf Units])/10

MEMBER [Measures].[Share] AS CASE WHEN [Date].[YQM].CURRENTMEMBER.MEMBER_CAPTION = "2011" THEN 1 ELSE...

Can you post the expression you have used and the new result how it looks lik for better understanding

Click on the Customer text box properties and go to interactive sorting..

In choose what to sort ..Select groups and in dropdown select the row grouping name and sort by column...

Try this format and let me know if it doesnt work ..

="void(window.open('"+ Globals!ReportServerUrl + "?" + Globals!ReportFolder +

"%2fReport_Name&rs:Command=Render" +"&Test='+escape('"+Parameters!Test.Value.ToString() +"') +'&Test1='+escape('"+Parameters!Test1.Value.ToString() +"') + '', 'newwin', 'screenX=0,left=0,screenY=0,top=0,status=1,menubar=1,resizable=1,scrollbars=1,toolbar=1,location=1'))"

Can you please post the full link using in ssrs

escape() function in javascript to substitute the ampersand character with its URI value of %26:

http://www.bp-msbi.com/2008/09/advanced-javascript-in-reporting/[/url]

Use ESCAPE function for javascript..

Thanks Anthony for the response.. I didnt even think of it

Arun-- I can use two single quotes and generate a file but the issue with that would be when they...

Phil,

I am doing it thru transfer sql server objects tasks which was recomended initially in this conversation so going with it as i am unable to do backup and restore...

It has just transfer sql server objects whoch copies all tables data from one server to another .....

Thanks Guys transfer sql server seems working for me...

What can i do to tune the package as i have more than 1000 tables and huge data want to tune it...

Which one would be better when compared to performance ....

Snapshot replication or ssis trsfr object task....

I am using ssis not ssms ....and they want to do it thru ssis ..

Existing logic is if loading any table fails fix it and run the entire package again...

So i want to make enhancements each time we run after failure just run the...

i am not sure if we both are on the same page ...sorry for not explaining it clearly...

Step1 : get the ID

Step2: Get list of table for each group

Step3:...