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

How to build a Clickthrough link in Report Builder 2.0

As I mentioned in a previous post, due to resource constraints in this release, Report Builder 2.0 is not a strict superset of RB 2005/1.0. One of the features missing from RB 2.0 is automatic creation of Clickthrough links. You can still get them, of course, by creating the basics of your report in RB 1.0,…

1

A better way to model inheritance

I’ve been playing around with a report model we use internally here in the SQL Server product group. At a conceptual level, the data being modeled makes heavy use of inheritance (EntityA “is a” EntityB), but in working with the model and with Report Builder, I’m finding some significant advantages to using the Role.ExpandInline property…

1

Report Builder 2.0: Whither report models?

Just a quick post to answer the inevitable question when those familiar with Report Builder 2005/1.0 start playing with Report Builder 2.0: Whither report models? The short answer is that they are still available as a data source type, and the report model query designer is included as well, so you can create datasets against…

5