7.2. Handling Errors in Reports

As you create more complex reports and use more intricate expressions in those reports, you increase the chance of introducing errors. The Report Designer lets you know you have an error when you try to preview a report. You receive a message in the Preview tab saying, "There are compilation errors. See Task List for details."

Fortunately, the Report Designer also provides tools for dealing with errors. A list of detailed error messages is displayed in both the Build section of the Output window and in the Task List window. In most cases, these error messages provide a pretty good description of the problem. In many cases, the problem is a syntax error in an expression you constructed in a property of a report ...

Get Microsoft SQL Server 2005 Reporting Services, 2nd Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.