SQL DB Pros

Category: SSRS (Reporting Services)

  • Tableau – Parse Parameters From URL

    Well, file this under “just because you can doesn’t mean you should.” Search the forums on parsing strings with Tableau and you’ll find a lot of guidance which pretty much says “don’t do it!” and “better to do it in your source!” These people are undoubtedly right. But, what if your source is an existing […]

  • SSRS: Parse parameters column from ExecutionLog

    Ever worked on a quick little project, come across what you assume is a common need and think “I’ll just google up some code that someone else has written and then be off to the races”?  Have you done this and not been able to find the code you’re looking for? Well, that was me […]

  • Find Your SSRS Target Server URL

    If you are looking to deploy your SSRS (SQL Server Reporting Service) reports directly from Visual Studio you will need to set the Target Server URL in the Properties of your project in the deployment section.  The trick here is that this is not the URL for your Report Manager. What you are in fact […]

  • How Do I Figure Out My SSRS ReportServer URL If It Is Not The Default?

    Don’t you love how what should be a simple little tasks can become the most time consuming of the day? While trying to set up Visual Studio so that I could deploy directly to a development server I realized I would need the path to the SSRS ReportServer. Not the Report Manager mind you but […]

  • SSRS Subscription Error: Failure sending mail: The report server has encountered a configuration error. Mail will not be resent.

    So, when a SQL Server Reporting Services subscription gives you an error message like: “Failure sending mail: The report server has encountered a configuration error. Mail will not be resent.” You know exactly what to do to fix it right? Just fix the so called “configuration error”. Problem solved! Another day another dollar. Am I […]

  • Change The Owner Of An SSRS Subscription: The Simple Way

    So you need to change the owner of an SQL Server Reporting Services subscription? No problema. (Why would you need to change it you might ask? Perhaps because you have deactivated the user account that created the subscription and now “strange things are afoot at the Circle K”, and if you know that reference please […]

  • Preventing Failed SSRS Subscriptions: Which user created your subscriptions?

    Check it out my friends. You need to keep an eye on which accounts are creating your SSRS subscriptions. Why? Because buried inside the ReportServer database (with no way to change it from the front end) SQL Server Reporting Services  is keeping track of this information. And when one of those user’s account is disabled strange […]

  • SSRS: A Hidden Tablix That Won’t Hide And Wham!

    Here’s a real quick tip after banging my head against the desk for awhile. I had a tablix in SSRS that was supposed to be hidden if there were no rows. It was working fine until, wham, it stopped working. (Oh no. I said “wham”. That obviously leads me to “Wham!”. I had my mom […]

  • Create A List In Your SSRS Tooltip: Not Impossible!

    Warning!  This post is barely finished.  I putting it up as a reminder to myself that I had a hard time finding a post explaining how to do it and I should write a post on it. “It’s impossible” they said.  “It can’t be done!” they claimed.  “You’re mad (but still surprisingly handsome!)” the women […]