Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Model Design » Tricks   (RSS)
Monday, April 27, 2009 4:15 PM

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”
Posted by bobmeyers | 0 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
Filed under: ,
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 | 3 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 | 8 Comments
Filed under: , ,
 
Page view tracker