Justin Cooney

Web Development Tips and Examples

recent posts

about

I am a Senior Applications Programmer / Analyst with years of experience developing enterprise solutions using the Microsoft technology stack including C#, VB.NET, ASP.NET, AJAX, IIS and SQL Server. I specialize in Web application development with a focus on building secure systems, integrating applications, and designing robust database structures.

  • SSRS Adding User Selectable Parameter Options

    SSRS Params Drop Down
    SSRS Params Drop Down

    SQL Server Reporting Services (SSRS) is a handy tool for generating reports quickly. However, like most reporting packages, making the reports dynamic rather than simple static canned reports takes a bit of effort. For example, you may want to let the users of your report choose from a list of options. You could then apply these choices to the report results in various ways such as using the user selections to filter the results, or to hide and show results columns. In general, adding a dynamic, customizable aspect to your reports adds value for your users beyond spitting back a simple canned set of results.

    In this example I will be working with a SQL Server 2008 SSRS set-up, but the general concepts hold true for related versions.

    (more…)

  • SSRS Basics: Set up Visual Studio to Write a New SSRS Report

    SSRS with Visual Studio
    SSRS with Visual Studio

    When first looking into writing SQL Server Reporting Services (SSRS) Reports in Visual Studio, it’s easy to think that creating a report will be possible straight out of the box with one of the existing templates that Visual Studio comes with. Somewhat surprisingly, this is not the case for Visual Studio 2012 and 2013. (more…)

  • 2014 in review

    The WordPress.com stats helper monkeys prepared a 2014 annual report for this blog.

    Here’s an excerpt:

    The Louvre Museum has 8.5 million visitors per year. This blog was viewed about 210,000 times in 2014. If it were an exhibit at the Louvre Museum, it would take about 9 days for that many people to see it.

    Click here to see the complete report.