8 comments on “How to create Custom Reports for SQL Server Management Studio”

  1. Pingback: How to extract SQL Server non-default configuration settings « Yet another SQL Server blog

  2. Pingback: Sql Server Business Intelligence Development Studio Not Found | Business Intelligence: Information, Software & Tools

  3. The link to the the zipped file of all the reports you provided us with are very helpful. Does it matter if we use it with 2005 or 2008?
    Thanks!

    Reply

    • Hi Komal,
      The only thing that matters is that if you design your own reports you should use BIDS 2005 because of the rendering controls integrated in SQL Server Management Studio. As for the zipped reports – they are already part of the standard reports that you can find in SSMS and work on both SQL Server 2005 and 2008!

      /ivan

      Reply

  4. Have you tried connecting a query parameter to a custom report parameter with a default value.

    I have a query that has a date parameter, @startDate, this is connected to a report parameter called startDate with a default value of 1 day ago. All works fine in BIDS but in SSMS 2005 you get an error say that ‘startDate’ cannot be found. Works in SSMS 2008.

    Reply

    • Well the thing is that when using a query parameter, it is expected this parameter to be somehow entered as an input (in BIDS you can have the Input part when you run the report) while in SSMS everything is predefined and you can use only what is already there. Unfortunately I do not believe there is possibility to add such custom parameters simply because in SSMS the report rendering does not include an Input screen part or something like that.

      Reply

  5. Is there a trick to query a server other than the one that you’re clicking on the objects for? Example: say I save historical information about tables on ServerB. I then make a report with ServerB as a datasource, and it queries my historical table using the parameters.

    I have it working in VS (it displays) but it fails in SSMS – it doesn’t look like it’s using the datasource to query the server. (Invalid object and the like, no hit from profiler) http://stackoverflow.com/questions/12843379/ssms-reports-building-one-that-queries-a-different-server-with-the-object-as-p

    Many thanks!

    Reply

  6. Pingback: SSMS reports – using a different Datasource than the server being reported against?

Leave a comment