Sign In
Bob's SQL Reporting Services Blog
Notes, tips, rants, and ruminations on SQL Reporting Services, and Report Builder in particular.
Translate This Page
Translate this page
Powered by
Microsoft® Translator
Options
Email Blog Author
RSS for posts
Atom
RSS for comments
OK
Search
Advanced search options...
Search In:
Everything
Blogs
Forums
People
Groups
Places
Pages
Date range:
All Time
Last Year
Last 6 Months
Last 3 Months
Last Month
Last Week
Last Two Days
Tags
Admin
Clickthrough
Configuration
Filters
Formulas
Grouping
Localization
Model Design
Model Security
Navigation
Pages
Parameters
Presentation
Releases
Report Builder
Report Design
Scale
Schema
Tricks
Archive
Archives
July 2009
(1)
April 2009
(3)
March 2009
(6)
October 2007
(1)
September 2007
(1)
February 2007
(2)
January 2007
(1)
December 2006
(3)
November 2006
(1)
October 2006
(1)
September 2006
(5)
July 2006
(2)
March 2006
(8)
January 2006
(3)
October 2005
(3)
MSDN Blogs
>
Bob's SQL Reporting Services Blog
Posts
Subscribe via RSS
Sort by:
Most Recent
|
Most Views
|
Most Comments
Excerpt View
|
Full Post View
Bob's SQL Reporting Services Blog
Add Excel-like "color scale" conditional formatting to your reports
Posted
over 3 years ago
by
Bob Meyers MSFT
6
Comments
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...
Bob's SQL Reporting Services Blog
Localizing a report model
Posted
over 3 years ago
by
Bob Meyers MSFT
3
Comments
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...
Bob's SQL Reporting Services Blog
Considerations for a large report model
Posted
over 3 years ago
by
Bob Meyers MSFT
5
Comments
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...
Bob's SQL Reporting Services Blog
SQL Server 2008 SP1 available now with important Report Builder 2.0 updates
Posted
over 3 years ago
by
Bob Meyers MSFT
4
Comments
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...
Bob's SQL Reporting Services Blog
Help RB 2.0 users find and use shared data sources
Posted
over 3 years ago
by
Bob Meyers MSFT
2
Comments
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...
Bob's SQL Reporting Services Blog
What is that extra column of 'AB.gAAAA=' values when I run a report model query?
Posted
over 3 years ago
by
Bob Meyers MSFT
6
Comments
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...
Bob's SQL Reporting Services Blog
Call for feedback: What are you doing with report models?
Posted
over 3 years ago
by
Bob Meyers MSFT
3
Comments
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...
Bob's SQL Reporting Services Blog
How to build a Clickthrough link in Report Builder 2.0
Posted
over 3 years ago
by
Bob Meyers MSFT
1
Comments
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,...
Bob's SQL Reporting Services Blog
A better way to model inheritance
Posted
over 3 years ago
by
Bob Meyers MSFT
1
Comments
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...
Bob's SQL Reporting Services Blog
Report Builder 2.0: Whither report models?
Posted
over 3 years ago
by
Bob Meyers MSFT
5
Comments
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...
Bob's SQL Reporting Services Blog
Sorting the values in parameter dropdowns in Report Builder
Posted
over 5 years ago
by
Bob Meyers MSFT
4
Comments
In SQL 2005 the semantic queries generated by Report Builder do not support sorting. This is not a problem in the report itself, because all sorting is defined and implemented in the report definition instead of the query. However, for parameter dropdowns...
Bob's SQL Reporting Services Blog
Filtering on totals in Report Builder
Posted
over 5 years ago
by
Bob Meyers MSFT
2
Comments
Since releasing Report Builder almost two years ago, we've found that many users run into difficulty at some point with filtering on totals . A classic example of this is, "show me a list of customers with more than $5000 in Accessory sales." "Accessory...
Bob's SQL Reporting Services Blog
Requiring Report Builder users to choose a perspective
Posted
over 5 years ago
by
Bob Meyers MSFT
6
Comments
Some customers have report models that are large enough they do not expect any user to ever request the entire model, and would actually prefer to disallow that option, and require them to choose a perspective instead. There is an undocumented and unsupported...
Bob's SQL Reporting Services Blog
Launching Report Builder from the command line
Posted
over 5 years ago
by
Bob Meyers MSFT
4
Comments
A number of people have asked if it is possible to launch RB from the command line. While it is in fact possible, it is an unsupported feature in SQL Server 2005. That said, here's how to do it. You just need to specify what report server to connect to...
Bob's SQL Reporting Services Blog
Using that little checkbox in the Report Builder filter dialog
Posted
over 5 years ago
by
Bob Meyers MSFT
1
Comments
The Filter dialog in Report Builder has a little checkbox near the bottom that many users have asked about. The checkbox label says, "When adding a new condition, apply to all data in my report." The effect of selecting this checkbox is that when subsequent...
Bob's SQL Reporting Services Blog
Creating a role to one of several related items
Posted
over 6 years ago
by
Bob Meyers MSFT
9
Comments
I call this the Primary Address problem, because a classic example is when you have a Customer table and an Address table, and each customer can have many addresses (Primary, Billing, Shipping, etc.), but no more than one of any given type. If you have...
Bob's SQL Reporting Services Blog
I want to reference a parameter (twice!) in a formula filter condition
Posted
over 6 years ago
by
Bob Meyers MSFT
4
Comments
In this release of Report Builder there is no direct support for referencing parameters in the Formula dialog. They will show up if you edit a prompted filter condition as a formula, but there is no way to directly insert a parameter reference. ...
Bob's SQL Reporting Services Blog
Getting grouping right in Report Builder
Posted
over 6 years ago
by
Bob Meyers MSFT
4
Comments
One thing Report Builder users need to be aware of when building a report is the difference between an entity group , which displays exactly one instance for each row in the underlying table, and a value group , which displays one instance for each distinct...
Bob's SQL Reporting Services Blog
SQL Server 2005 SP2 (CTP2) is now available
Posted
over 6 years ago
by
Bob Meyers MSFT
4
Comments
Huge new feature: integrate your RS 2005 report server with SharePoint 12! What's new in SP2? Download here.
Bob's SQL Reporting Services Blog
Enforcing timeouts on Report Builder queries
Posted
over 6 years ago
by
Bob Meyers MSFT
8
Comments
I've attached a sample C# project illustrating how to create a custom data processing extension ( more info ) that enforces a maximum timeout on any SQL queries submitted to it, including those generated from Report Builder. To try it out: Open...
Bob's SQL Reporting Services Blog
Evolving your report model over time
Posted
over 6 years ago
by
Bob Meyers MSFT
2
Comments
Many factors combine to make report models highly likely to change and evolve over time. Sometimes the underlying schema changes. Sometimes new stuff is added. Sometimes you just want to improve how the schema is presented to users. Report models are...
Bob's SQL Reporting Services Blog
Creating a report model that can be used against multiple databases
Posted
over 6 years ago
by
Bob Meyers MSFT
5
Comments
Sometimes it is useful to create a report model that can be used against multiple databases that have the same structure, but reside on different servers and/or have different schema qualifiers. Uploading a second copy of a report model and pointing...
Bob's SQL Reporting Services Blog
Clickthrough reports are the key to integration
Posted
over 6 years ago
by
Bob Meyers MSFT
5
Comments
Clickthrough reports are the special kind of drillthrough reports created by Report Builder. They are "special" because they are linked to the parent report automatically, and are generated on the server from special template reports (or from a built...
Bob's SQL Reporting Services Blog
How to get RB to load a report created in VS Report Designer
Posted
over 6 years ago
by
Bob Meyers MSFT
0
Comments
Loading an arbitrary Report Designer report in Report Builder is not supported in SQL Server 2005. However, if you are trying to make it work for some reason, here are a few tips: - Don't use page headers or footers - Don't use rectangles or lists...
Bob's SQL Reporting Services Blog
How to enable Report Builder for non-domain users
Posted
over 6 years ago
by
Bob Meyers MSFT
2
Comments
Report Builder uses a client technology called ClickOnce to download and launch the application files. This component runs outside of Internet Explorer, so it cannot leverage any credentials that may have been collected by IE to access the report server...
Page 1 of 2 (40 items)
1
2