Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

Thursday, October 11, 2007 1:44 AM

Sorting the values in parameter dropdowns in Report Builder

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
Posted by bobmeyers | 1 Comments

Attachment(s): SQLReportModelDP.zip
Friday, September 28, 2007 7:06 AM

Filtering on totals in Report Builder

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
Posted by bobmeyers | 2 Comments

Attachment(s): Filtering on totals - Examples.zip
Tuesday, February 27, 2007 11:28 AM

Requiring Report Builder users to choose a perspective

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
Posted by bobmeyers | 4 Comments
Thursday, February 22, 2007 4:04 PM

Launching Report Builder from the command line

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,
Posted by bobmeyers | 3 Comments
Monday, January 15, 2007 10:19 AM

Using that little checkbox in the Report Builder filter dialog

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
Posted by bobmeyers | 1 Comments
Wednesday, December 20, 2006 4:43 PM

Creating a role to one of several related items

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
Posted by bobmeyers | 9 Comments
Wednesday, December 20, 2006 4:32 PM

I want to reference a parameter (twice!) in a formula filter condition

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. However,
Posted by bobmeyers | 2 Comments
Wednesday, December 20, 2006 3:55 PM

Getting grouping right in Report Builder

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
Posted by bobmeyers | 4 Comments
Friday, November 10, 2006 10:46 AM

SQL Server 2005 SP2 (CTP2) is now available

Huge new feature: integrate your RS 2005 report server with SharePoint 12! What's new in SP2? Download here.
Posted by bobmeyers | 0 Comments
Tuesday, October 31, 2006 12:12 PM

Enforcing timeouts on Report Builder queries

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 and build
Posted by bobmeyers | 4 Comments

Attachment(s): SQLTimeoutDP.zip
Thursday, September 28, 2006 11:30 AM

Evolving your report model over time

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
Posted by bobmeyers | 2 Comments
Thursday, September 28, 2006 11:20 AM

Creating a report model that can be used against multiple databases

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 it
Posted by bobmeyers | 5 Comments
Thursday, September 28, 2006 10:15 AM

Clickthrough reports are the key to integration

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-in
Posted by bobmeyers | 3 Comments
Thursday, September 28, 2006 6:02 PM

How to get RB to load a report created in VS Report Designer

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 - Only
Posted by bobmeyers | 0 Comments
Thursday, September 28, 2006 4:26 PM

How to enable Report Builder for non-domain users

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.
Posted by bobmeyers | 2 Comments
More Posts Next page »
 
Page view tracker