Post reply

Ad Hoc Reports in Report Builder

  • 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? 

     

  • January 15, 2007 at 7:26 am

    #683215

    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

     

  • January 17, 2007 at 9:32 pm

    #683894

    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

  • January 30, 2007 at 5:22 am

    #686405

    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?

  • January 30, 2007 at 6:47 am

    #686427

    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.

  • January 30, 2007 at 10:35 am

    #686529

    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. 

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

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