Welcome to MSDN Blogs Sign in | Join | Help

March 2006 - Posts

Thursday, March 30, 2006 6:31 PM

Subscriptions to Report Builder reports

Many people are interested in creating subscriptions to Report Builder reports. In SQL Server 2005 this is only possible if the reports can be run unattended by the server . If the report has any user-dependent behavior, then it can only be run live by
Posted by bobmeyers | 0 Comments
Sunday, March 26, 2006 3:57 AM

Using RDL expressions in Report Builder

While not a documented feature, you actually can enter an arbitrary RDL expression into a textbox in a Report Builder report. For example, you could add a textbox that shows the date the report was run by setting the value of the textbox to the following:
Posted by bobmeyers | 10 Comments
Friday, March 24, 2006 7:51 PM

Collapsing a many-to-many relationship in a report model

Often a many-to-many relationship exists between two entities where the intermediate entity has nothing on it except the connecting roles. For example, it might be that an Employee can be assigned to many Regions, and each Region can have many Employees
Posted by bobmeyers | 9 Comments
Friday, March 24, 2006 6:02 PM

How to create a "company" security filter for a hosted application

Several customers have asked how to restrict data visibility in a report model for a hosted application, where every table has a "CompanyID" column, and every user that accesses the system is associated (via some other table) with exactly one company.
Posted by bobmeyers | 2 Comments
Saturday, March 18, 2006 7:03 PM

Article: Implementing Data Security in a Report Model

I just posted the first article on my blog. Here's the abstract: The report models introduced in SQL Server 2005 feature a number of ways to customize the data visible to different users and groups: perspectives, model item security, security filters,
Posted by bobmeyers | 0 Comments
Saturday, March 18, 2006 4:38 PM

SP1 CTP is now available -- Report Builder users should update

The SQL Server 2005 SP1 CTP is now available. This update fixes a number of Report Builder issues in the original 2005 release, including one that is fairly critical. The most critical issue is related to report processing and database collation. Model-based
Posted by bobmeyers | 2 Comments
Thursday, March 16, 2006 4:15 AM

Adding parameters (prompts) to a Report Builder report

You easily can add basic parameters to a Report Builder report using the Filter dialog. For example, to let the user choose which year to view sales data for, add an Order Year filter condition to your report filter, then, instead of specifying a value,
Posted by bobmeyers | 4 Comments
 
Page view tracker