We've posted a new article at wrox.com by Wrox author Paul Turley, excerpted from Professional SQL Server 2005 Reporting Services.
The article Report Solution Patterns and Recipes: Greenbar Reports
is the first of a series of 3 articles we'll excerpt from the 19 solutions and recipes in the "Report Solution Patterns and Recipes" chapter of the book. Here's the beginning of the article:
Report Solution Patterns and Recipes: Greenbar Reports
As we have endeavored to solve various business problems, we've learned to do some interesting things with Reporting Services. On consulting engagements, I often find myself in front of a client who is asking questions like "can you do this or that?" Almost inevitably, the answer is "yes," but the question becomes what the best method would be to meet the requirement. With a little outside-the-box thinking, a lot of interesting things are possible. This may involve some custom programming, embedding report items or using customer application components in concert with Reporting Services.
In the Report Recipes section of the book Professional SQL Server 2005 Reporting Services, I've compiled a description of reporting challenges and solutions we've encountered, developing reports for our clients. For each "solution recipe," I provide a brief list of skills, techniques, and resources needed to apply the report feature. This should give you a good idea about how prepared you may be to use the techniques based on your skill set and the level of complexity. Some of these are easy to duplicate and others require more advanced skills, which may include Transact-SQL and Visual Basic programming. These are not intended to be exercises or step-by-step instructions. I have made a point to provide enough information to demonstrate the concepts and techniques. However, to implement these solutions you will need to apply the skills you learned in the previous chapters of Professional SQL Server 2005 Reporting Services.
Once-upon-a-time, most reports were printed on special continuous-feed paper. This paper is fan folded, with a perforation between each page, making it stackable in the input and output printer bins. The long scroll of pages has pin-feed holes on each side to feed it through and align each row with the mechanical print head. One of the common characteristics of this paper is that it has pre-printed green bars for every-other row data. In more modern reports, this format remains popular to help readers visually separate each row of printed information. This typically involves using a light pastel background color for alternating table rows.
And you can read the rest of the article here.
Senior Acquisitions Editor
Wiley Technology Publishing
Jim's Book of the week: No book this week - Donate to the Red Cross!
Associate Publisher, WROX - A Wiley Brand
Did someone here help you? Click
on their post!