6/3/2009 11:47:28 AM
I think the most important part of a system is the final interface with the users - it is "where the rubber meets the road". So without getting reporting right, even the best database designed system is doomed. As a group (IT professionals) we often skimp or run short of time on the final reports phase.
So learn some of the best techniques Angry Koala utilise for our own clients, and the best of others from http://reportsurfer.com including
* dynamic grouping
* conditional coloring
* generic reports (based on db metadata)
* SSAS drill-through
* self calling reports
* handling long parameter lists
These sometimes extreme ;) techniques and ideas will give you the tools to nail that next reporting project.
Grant Paisley is a SQL Server MVP, and president of the Sydney SQL Server User Group. With more than 10 years of consulting experience in Business Intelligence and data warehousing Grant has worked on many complex projects and produced a wide range of solutions. Delivered solutions include a Scorecard Reporting System for the Microsoft Australia Enterprise Group. He is sought after as a speaker presenting practical Business Intelligence Solutions advice to the global marketplace at events such as TechEd and user group meetings throughout Australia.
Venue: Mechanics' School of Arts, Level 1, 280 Pitt St, Sydney |
Duration :30pm Share Ideas, Network with your Peers (with Pizza & Drinks) |
On: Tuesday, June 9, 2009