Create short lists using the LookupSet function

Sometimes you have a short list of values that you really don’t want to show on individual rows; you’d rather just concatenate them into a list, separated by commas, and put them all in a single row. For example, suppose instead of listing the states in each U.S. Census region each on their own row,…

3

TechEd session: Tips and tricks for building rich reports

Here’s a recording of my TechEd 2012 North America session last week in Orlando: Tips and Tricks For Building Rich Reports The entire session is based on Report Builder 3.0. All content is relevant to both SQL 2008 R2 and SQL 2012. Topics covered: Use a tablix to organize data how you want it Use…

2

When and why the primary entity changes when using a report model

Got a few questions lately on this subject, so I thought I’d post some additional info that may be helpful. First, a few related links that may be partially helpful: The philosophy behind Report Builder data navigation (blog post) Exploring the Primary Entity and Its Related Data (MSDN) Using that little checkbox in the Report…

0

Add Excel-like "color scale" conditional formatting to your reports

I’ve been meaning to do this for a long time, and it looks like David Lean beat me to it earlier this year by posting an incredibly thorough four-part discussion of how to do conditional formatting in Reporting Services. I’ve played with his sample code a bit and put together a variation on his theme…

16

Localizing a report model

Reports and report models can be localized at many levels. Following are some ideas around the current support in SQL Server 2008 for each type of localization.   –          Localized metadata at report design time o   Example: Spanish report author sees “Cliente” instead of “Customer” in model explorer o   Report models do not support multiple…

3

Considerations for a large report model

Customer report models that vary in size from a few to a few hundred entities. Little Northwind with its 10 or so entities comes in around 200K, but we’ve seen models a hundred times that size (over 20 MB). One of the key drivers of model size is the constraint that you cannot build a…

5

SQL Server 2008 SP1 available now with important Report Builder 2.0 updates

SQL Server 2008 SP1 is now available, and includes some important updates related to Report Builder 2.0: – RB 2.0 can now be deployed directly from the report server using ClickOnce. You can also configure whether RB 1.0 or RB 2.0 is launched from the Report Manager and SharePoint UI. – An important fix to…

4

Help RB 2.0 users find and use shared data sources

Report Builder 2.0 makes it easy for business users to browse for and use centrally-defined and managed data sources. It does this by supporting direct connection to a report server as part of the design experience. It also maintains a list of recently-used data sources that show up at the top of the list each…

2

What is that extra column of ‘AB.gAAAA=’ values when I run a report model query?

Most people using Report Builder 2.0 with a report model soon ask the question, what is that extra column I get back with strange values like “AC8AAAA=” in it? Answer: It’s an entity key value. If you’re going to create a group on that entity in your report, you should use this field as the…

7

Call for feedback: What are you doing with report models?

Are you using a report model in your organization? The Reporting Services product team wants to hear from you! What type of organization is using the model (dept/workgroup, small/mid business, enterprise)? How long have you been using your model? What is the backend database for your model? How much data is behind your report model?…

4