Ad Hoc Reports in Report Builder

Question

Post reply

Ad Hoc Reports in Report Builder

Ches Weldishofer

Mr or Mrs. 500

Points: 512
More actions
January 12, 2007 at 2:15 pm

#176442

Has anyone found a good set of tutorials or labs on how to build reports in Report Builder?
Or for that matter how make a very dynamic Model?

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

webooth SSCommitted Points: 1550 More actions · Answer 1

This guy has a lof of good articles, http://www.databasejournal.com/features/mssql/article.php/3598931

or this article, Building Ad-hoc Reporting Solutions with SQL Server 2005 Report Builder and Analysis Services OLAP.

http://msdn2.microsoft.com/en-us/library/aa964121.aspx

swjohnson Hall of Fame Points: 3254 More actions · Answer 2

Two good resources that I have found and use quite extensively.

1. SQL Server 2005 Reporting Services in Action by Bret Updegraff (Manning Publishing) and you can get it as an e-book (PDF) for about half the price of the regular book!

This resource has been helpful on the more advanced topics of RS...such as using SOAP to connect and submit your own reports using the RS service, Performance and scalability, and Subscriptions...

2. Microsoft SQL Server 2005 Reporting Services by Brian Larson.

I have also used http://msdn2.microsoft.com/en-us/library/aa337436.aspx from MS

Good Luck!

SJ

Accepting all invites

Ches Weldishofer Mr or Mrs. 500 Points: 512 More actions · Answer 3

Thank you both for the responses, we now have a fairly complex model developed. One thing we have not been able to get working though is security. We want to use AD Security groups to do Row-level limiting on all tables in the model.

I've found one msdn article on row-level security but I can't get that to work at all (sitting on a RS that has both SP1 and the beta upgrade)

The tables behind our model all have an "origin" field which is a two character field denoting a given country. If an employee of Denmark (for instance) accesses then they should see only origin DE, Spain would see only ES. We could create multiple models limiting each per country, but that would make maintaining the model more complex than necessary, and would mean that every time we added a new country a new model would need to be made. Reuse is good use.

Any ideas?

webooth SSCommitted Points: 1550 More actions · Answer 4

I assume this is the article you mentioned.

Implementing Row- and Cell-Level Security in Classified Databases Using SQL Server 2005

This site might help.

SQL Server 2005 -- Tools for row and cell level security

Here is a commercial product.

Data Nomad® is an affordable set of developer tools that extend the Microsoft SQL Server 2005 platform to provide row-level security and remote access features allowing developers to accurately and efficiently create and manage powerful distributed applications that insure access to information is protected.

Keep us posted please.

Ches Weldishofer Mr or Mrs. 500 Points: 512 More actions · Answer 5

The SQL Server 2005 Tools were actually a path I started down Friday, Having privilege issues getting it installed on the server, but it appears to be able to accomplish what we want.