Forum Replies Created

Viewing 15 posts - 31 through 45 (of 275 total)

  • RE: Need Help on MDX Query..

    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...

    Thanks,
    Chinna

    Its the Journey which gives you Happiness not the Destination-- Dan Millman

    December 6, 2012 at 2:45 pm

    #1566360

  • RE: Alternate line formatting on matrix style reports

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

    Thanks,
    Chinna

    Its the Journey which gives you Happiness not the Destination-- Dan Millman

    December 5, 2012 at 4:59 pm

    #1565969

  • RE: Interactive sort on matrix

    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...

    Thanks,
    Chinna

    Its the Journey which gives you Happiness not the Destination-- Dan Millman

    December 5, 2012 at 3:56 pm

    #1565958

  • RE: SSRS - Opening sub-report in a new window "&" issue

    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'))"

    Thanks,
    Chinna

    Its the Journey which gives you Happiness not the Destination-- Dan Millman

    December 5, 2012 at 2:23 pm

    #1565922

  • RE: SSRS - Opening sub-report in a new window "&" issue

    Can you please post the full link using in ssrs

    Thanks,
    Chinna

    Its the Journey which gives you Happiness not the Destination-- Dan Millman

    December 5, 2012 at 3:04 am

    #1565637

  • RE: SSRS - Opening sub-report in a new window "&" issue

    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/%5B/url%5D

    Thanks,
    Chinna

    Its the Journey which gives you Happiness not the Destination-- Dan Millman

    December 5, 2012 at 2:24 am

    #1565621

  • RE: SSRS - Opening sub-report in a new window "&" issue

    Use ESCAPE function for javascript..

    Thanks,
    Chinna

    Its the Journey which gives you Happiness not the Destination-- Dan Millman

    December 4, 2012 at 5:18 pm

    #1565536

  • RE: Need help with Text qualifier

    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...

    Thanks,
    Chinna

    Its the Journey which gives you Happiness not the Destination-- Dan Millman

    September 21, 2012 at 6:58 am

    #1540655

  • RE: Need the best way of doing it in SSIS...SSIS experts please suggest

    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...

    Thanks,
    Chinna

    Its the Journey which gives you Happiness not the Destination-- Dan Millman

    February 2, 2012 at 5:41 am

    #1441727

  • RE: Need the best way of doing it in SSIS...SSIS experts please suggest

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

    Thanks,
    Chinna

    Its the Journey which gives you Happiness not the Destination-- Dan Millman

    February 2, 2012 at 4:33 am

    #1441665

  • RE: Need the best way of doing it in SSIS...SSIS experts please suggest

    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...

    Thanks,
    Chinna

    Its the Journey which gives you Happiness not the Destination-- Dan Millman

    February 1, 2012 at 6:49 pm

    #1441513

  • RE: Need the best way of doing it in SSIS...SSIS experts please suggest

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

    Snapshot replication or ssis trsfr object task....

    Thanks,
    Chinna

    Its the Journey which gives you Happiness not the Destination-- Dan Millman

    January 30, 2012 at 7:15 am

    #1439973

  • RE: Need the best way of doing it in SSIS...SSIS experts please suggest

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

    Thanks,
    Chinna

    Its the Journey which gives you Happiness not the Destination-- Dan Millman

    January 30, 2012 at 5:36 am

    #1439911

  • RE: query pro's please help me with this...

    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...

    Thanks,
    Chinna

    Its the Journey which gives you Happiness not the Destination-- Dan Millman

    August 1, 2011 at 2:53 pm

    #1361861

  • RE: query pro's please help me with this...

    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:...

    Thanks,
    Chinna

    Its the Journey which gives you Happiness not the Destination-- Dan Millman

    August 1, 2011 at 2:35 pm

    #1361843

Viewing 15 posts - 31 through 45 (of 275 total)