Forum Replies Created

Viewing 15 posts - 1 through 15 (of 32 total)

  • RE: Execute Powershell script from SSIS using UNC Path

    The script also downloads some json files from a webservice. That line was just the first step of archiving the objects before downloading new ones. I'll keep that in my...

  • RE: Vertical alignment issue with SSRS

    So, I think your problem might be related to using a rectangle directly instead of a List. A list will repeat the rectangle for every "group" you designate it for....

  • RE: Data Driven Subscription Time Outs

    No, it's a data driven subscription because each recipient needs their own copy of the report (filtered to their ID). Due to security reasons, we can't allow them to get...

  • RE: ssrs 2012 using nested isnothing statements

    Pretty sure that this would work, or at least get you started.

    =iif(Fields!Language.Value="Spanish"
        ,Switch(isnothing(Fields!SpanishDate.value)=true,"Message 1"
                ,isnothing(Fields!SpanishTime.value)=true,"Message 2"
                ,isnothing(Fields!SpanishLocation.value)=true,"Message 3"
                ,1=1, "Good Spanish Message")
        ,Switch(isnothing(Fields!Date.value)=true,"Message 4"
                ,isnothing(Fields!Time.value)=true,"Message 5"

  • RE: NPER Function from Excel

    Perfect, thanks for the assist!

  • RE: Junk in my tables

    That's what it looks like, it even looks that way when I pull up the note in the application that saved it. I'm pretty sure that's the exact character, just...

  • RE: Junk in my tables

    The column is a varchar(1000), it's a free form user field from a 3rd party app, specifically it's for "notes". There are carriage returns in there, but I've never had...

  • RE: Junk in my tables

    It's SQL Server 2012, so it's BIDS 2010, and I'm opening the file using Excel 2013.

  • RE: Snapshot Isolation Level - Too good to be true?

    Thanks for the heads-up, however what I was considering was leaving the default database isolation level as-is, and instead just declaring the isolation level on all of my SSRS report...

  • RE: Speeding up Report Manager

    Good to know. In the situation I was posting about though, I remember going as far as changing the report layout and changing paramaters just to be as certain as...

  • RE: Speeding up Report Manager

    That shouldn't be the case if I'm changing my sproc and hitting the refresh button right? My understanding was that hitting refresh discarded all cached data and hit the database...

  • RE: Why am I having so much trouble restoring?

    Ha! Wow, thanks for being patient with my me. That fixed it.

    Much appreciated everyone!

  • RE: Why am I having so much trouble restoring?

    Now the new db is stuck as Restoring. This is the query that I ran, and the message that it delivered after. Did I miss something? I've definitely waited long...

  • RE: Backups stored on other server

    Thanks!

  • RE: Timing out scheduled jobs

    I hate to bump an old thread like this, but I have almost exactly the same need and didn't want to post a brand new topic for this. The only...

Viewing 15 posts - 1 through 15 (of 32 total)