Report expressions solve many formatting and calculation requirements without custom code. Older SSRS tutorials also demonstrate embedding Visual Basic code in report definitions for shared logic.
Choose the right place for logic
Filter and aggregate meaningful business values in the SQL dataset; use report expressions for presentation; use report custom code only when neither is appropriate and supported.
Report expression example
=IIF(IsNothing(Fields!Discount.Value), 0, Fields!Discount.Value)Embedded code considerations
Older SSRS authoring tools supported custom VB.NET snippets under report properties. Check support and code-access limitations in the exact report designer and server version before relying on legacy demonstrations.
Testing
Verify correct output when fields contain NULL, numbers are negative, cultures format decimals differently, and reports render to PDF or Excel. Parameter authorization must be enforced at the data source, not merely hidden in the user interface.
2025 note
Microsoft consolidates on-premises reporting into Power BI Report Server starting with SQL Server 2025; evaluate your target platform before following historical setup instructions.
AI content and reuse notice: Written using AI based on this site’s earlier post (22521), with added explanations and examples. The newly generated text may be reused, edited, or republished with or without attribution. Third-party works and trademarks remain subject to their own rights. AI can make mistakes. Check all code, version-specific features, and operational decisions against current vendor documentation before production use.
