Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Admin   (RSS)
Monday, April 27, 2009 1:58 PM

Considerations for a large report model

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
Posted by bobmeyers | 4 Comments
Tuesday, April 07, 2009 10:28 PM

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

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
Posted by bobmeyers | 0 Comments
Friday, March 27, 2009 9:26 PM

Help RB 2.0 users find and use shared data sources

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
Posted by bobmeyers | 2 Comments
Attachment(s): DefaultFolders.zip
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
Wednesday, July 05, 2006 7:10 PM

How to get the SQL for a Report Builder report

There are two ways to get the generated SQL for a Report Builder report (or for a model-based query in any RS report): 1) use SQL Profiler to capture the incoming SQL commands, or 2) enable query logging in the report server. To enable query logging on
Posted by bobmeyers | 5 Comments
Filed under: ,
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
Filed under:
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
Filed under: ,
Saturday, March 18, 2006 10:56 AM

Implementing Data Security in a Report Model

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, and opaque expressions. This article describes when and how to use each of these features.
Posted by bobmeyers | 7 Comments
Filed under: ,
 
Page view tracker