Archive for category: SSRS

SQL Server Reporting Services related musings

Technical Article: Report Model (SMDL) Alternatives in SQL Server 2012

28 August, 2013 (10:00) | Articles, Power Pivot, SSAS, SSRS, Tabular | By: Mark V

It is with tremendous joy that I announce the release of my very first Technical Article! Click the image below to get a copy of your very own. When I first started in the SQL Server business with Digineer about 6.5 years ago, one of my earliest projects was implementing a SQL Server 2005 Report […]

SSRS Cascading Multi-Value Parameters

16 August, 2013 (11:00) | SSRS | By: Mark V

Not too long ago, there was a question posted to #ssrshelp on Twitter regarding having multi-value parameters in SSRS 2005 that ALSO cascade. While I don’t have access to a SQL 2005 instance anymore, I wanted to try it in 2012 since I had an idea how to accomplish it. My idea worked just fine […]

Dynamic SSRS Chart Data Label Visibility

9 May, 2012 (09:30) | SSRS | By: Mark V

The other day, there was a question posted on the #ssrshelp hash tag on Twitter. The question was whether SSRS would allow you to show data labels for a chart, but ONLY on the last item in a series. For example, if you have months ranging from January to December, can you show the data […]

Using Bogus Measures in SSRS Parameter Available Values Lists

3 April, 2012 (10:00) | MDX, SSRS | By: Mark V

I am currently working on a project involving many reports against an Analysis Services 2008 R2 cube that we implemented for the client. The available values lists for the report parameters are largely just lists of members of various dimension attribute hierarchies from the cube. Since we are not going to actually use any measures […]

Announcing the #SSRSHelp Twitter Hashtag

18 October, 2011 (10:00) | PASS, SSRS | By: Mark V

I think it’s clear to anyone with half an eye open that the #SQLHelp hastag has been, and continues to be, a huge boon to the SQL community. It is a fantastic way to get assistance with SQL Server. If I were a DBA, it would be perfect for me. I just returned from the […]

PASSMN June Meeting: What’s New In SSRS 2008 R2

14 June, 2010 (09:11) | PASS, PASSMN, Presentations, Professional Development, SSRS | By: Mark V

I have been lax in promoting my local SQL users group, so here goes. Oh, by the way, it’s Lara’s fault that I am a SQL Server consultant. Thanks Lara! June PASSMN Meeting & Newsletter Sponsored by Magenic There will be books, shirts and other swag at the end of the meeting! Location:    8300 Norman […]

Clarification on Viewing Report Properties in SSRS 2005/2008

14 May, 2010 (09:52) | SSRS | By: Mark V

I have been to two different presentations on SQL Server 2008 R2 Reporting Services enhancements over the past month or so. In both of those presentations, the presenter said just about these exact words: “Now, you can view a report’s properties without having to run it first.” I decided to check Microsoft.com to see if […]

Linked Reports: Getting the Montagues and Capulets To Share

14 January, 2010 (11:13) | SSRS | By: Mark V

Two households, both alike in dignity, In fair Verona, where we lay our scene, From ancient grudge break to new mutiny, Where civil blood makes civil hands unclean.           ~ Romeo and Juliet, William Shakespeare   Those Montagues and Capulets don’t do so well with the sharing thing. They fight. A lot. This causes a […]

Jinkies! Passing MultiValue SSRS Parameters To Stored Procedures

5 January, 2010 (13:08) | SQL, SSRS, T-SQL, XML | By: Mark V

SQL Server Reporting Services provides a great way to allows report users to select more than one value from the available values list in parameters, creating a multivalue parameter. SSRS dynamically creates a comma separated list of the values selected by the user to pass in to the data source. Great. It also dynamically creates […]

Find All Deployed SSRS Reports That Reference A Particular Field

13 November, 2009 (11:14) | SSRS | By: Mark V

This summer I built an SSRS 2008 Report Model for a client. The end users report against the model using Report Builder 2.0. I shall pause here for a rave. <rave> Report Builder 2.0 is just outstanding, in my humble opinion. I built a SQL 2005 Report Model for a different client a few years […]