Microsoft® SQL Server® 2008 Reporting Services Step by Step

Enhancing Reports

Although you might not take the time to format an ad hoc report that you intend to discard after viewing once or twice, you might decide to format a report that you want to share to make it easier to read for others or implement other features that make it easier to use. Report Builder formatting options are basic compared to Report Designer but are typically sufficient for ad hoc reports. You can also enhance your reports by adding a calculation to your report, by adding filters to limit the data in your report, or by providing a default sort order for the data. Finally, if you want, you can disable the interactive sort feature that you saw in the Reseller Sales report or the expand/collapse capability in the Reseller Sales ...