Subscribe: Bob's SQL Reporting Services Blog
Added By: Feedage Forager Feedage Grade A rated
Language: English
builder  data sources  data  model  models  report builder  report model  report models  report  reporting services  server  sql server  sql 
Rate this Feed
Rate this feedRate this feedRate this feedRate this feedRate this feed
Rate this feed 1 starRate this feed 2 starRate this feed 3 starRate this feed 4 starRate this feed 5 star

Comments (0)

Feed Details and Statistics Feed Statistics
Preview: Bob's SQL Reporting Services Blog

Bob's SQL Reporting Services Blog

Notes, tips, rants, and ruminations on SQL Reporting Services, and Report Builder in particular.

Last Build Date: Tue, 21 Jul 2015 15:37:21 +0000


Create short lists using the LookupSet function

Mon, 18 Jun 2012 12:19:00 +0000

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,...

TechEd session: Tips and tricks for building rich reports

Mon, 18 Jun 2012 11:56:00 +0000

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...

Media Files:

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

Mon, 27 Feb 2012 10:34:00 +0000

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...

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

Fri, 31 Jul 2009 20:09:00 +0000

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...

Localizing a report model

Mon, 27 Apr 2009 19:15:00 +0000

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...

Considerations for a large report model

Mon, 27 Apr 2009 16:58:00 +0000

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...

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

Wed, 08 Apr 2009 01:28:00 +0000

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...

Help RB 2.0 users find and use shared data sources

Sat, 28 Mar 2009 00:26:00 +0000

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...

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

Fri, 06 Mar 2009 12:36:00 +0000

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...

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

Fri, 06 Mar 2009 12:22:00 +0000

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?...