Forum Replies Created

Viewing 15 posts - 2,581 through 2,595 (of 5,109 total)

  • RE: "Cannot open user default database. Login failed"

    John Mitchell-245523 - Wednesday, November 15, 2017 4:33 AM

    Are you sure about that, Thom?  It's not documented on the CREATE LOGIN...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: "Cannot open user default database. Login failed"

    coolchaitu - Wednesday, November 15, 2017 4:06 AM

    John Mitchell-245523 - Wednesday, November 15, 2017 3:20 AM

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Sum for year within Tablix

    That dataset doesn't look anything like what you originally posted, hw does it relate? Also, those screenshots are tiny (I very much doubt you have a screen that is only...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Operating system error 5: "5(Access is denied.)".

    GilaMonster - Wednesday, November 15, 2017 1:20 AM

    Eirikur Eiriksson - Wednesday, November 15, 2017 1:10 AM

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Excel drivers for ssis package

    Ahh, the bane in our side that is the "ACE" drivers.

    What version of SSIS are you using? When you're executing the package, how are you doing so,...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Sum for year within Tablix

    cmw 66135 - Tuesday, November 14, 2017 10:04 AM

    The total for the year to date is data. When I do grouping to...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Sum for year within Tablix

    It sounds like your describing that you have totals already in your data as well as the non-aggragated data itself. Are you having to display those sub-totals as well? I'd...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Sum for year within Tablix

    Rather than filtering the data at SP level, or Tablix, filter the Row Group. Add the Totals row to your tablix first, then in your Row Groups Pane put the...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Scope of Variables in Stored Procedure

    drew.allen - Tuesday, November 14, 2017 8:41 AM

    There is no need for a CURSOR here. There is a very efficient method...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: What URL should I give to run the report directly..

    Not sure I'm afraid, I'm not a javascript programmer/developer. At a guess, however, maybe you have Javascript disabled in your browser.

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Add line break to string

    sgmunson - Tuesday, November 14, 2017 8:25 AM

    SSMS will only display the new line, however, when outputting results to Text, and I'm...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: What URL should I give to run the report directly..

    Try using the ReportServer address. Possibly... http://mhpdw2/ReportServer/Pages/ReportViewer.aspx?%2fMyContigo%2fDO_NOT_USE%2fSubReportWithMemberInfoUsedByWaiverFinance&RepParameterSet=50

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Running Balance query

    John Mitchell-245523 - Tuesday, November 14, 2017 3:13 AM

    You're right, Thom - normally there'd be no need.  But since he's doing...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Running Balance query

    VSSGeorge - Tuesday, November 14, 2017 2:52 AM

    GOT IT

    SELECT t2.Date,
       t2.Credit,
       t2.Debit,
       SUM(COALESCE(t1.credit, 0) - COALESCE(t1.debit, 0))...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Running Balance query

    John Mitchell-245523 - Tuesday, November 14, 2017 2:31 AM

    I just typed "running balance query" into my favourite search engine - it's amazing...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

Viewing 15 posts - 2,581 through 2,595 (of 5,109 total)