Databases
Cloudsocket (actually just me) has announced the creation and delivery of a new knowledge center for database patterns and best practices for database design and development. The Cloudsocket Database Developer Wiki will be open to all to share and collaborate on the databases and the use, performance and development of this important and frequently overlooked technology. The main purpose is to share, educate and inform not only database experts but also the entire software development community to develop, use and maintain better relational databases. We are building a repository for: SQL Server 2005...
One of the things I want in my reports is to have nice headers for my reports. I like to have a logo and the user's report parameters along with other data to show to give more information for the business needs the report needs to clarify. One of the things that Microsoft SQL Server 2005 Reporting Services cannot do natively is show data from a Dataset in the header. This post will explain how to work around this and how easy it is. Create the Report Server Project in the Business Intelligence Projects section and call it AdventureWorksLTReports. ...
A very easy way to create reports with alternating background colors for each row in your table report. Select the TableRow in the report's Table control. In the expression for the TableRow's BackgroundColor property place the following: =iif(RowNumber(Nothing) Mod 2, "Gainsboro", "White") The last 2 parameters are the colors that will alternate for the data rows of the table in the report.
The need to produce reports with a common starting design and format is key to any project involving clients and their reports. I have been working on reports for over 10 years now. This has not been the largest portion of my jobs through the years but it has been a very import one. The key to any report project is not to recreate the mundane aspects of the reports for each but to use templates. The use of templates is not a common task or knowledge for Microsoft's SQL Server Reporting Services. Knowing how to save reports templates so...