Loading in 2 Seconds...
Loading in 2 Seconds...
Building Ad-Hoc Reports using the SQL Server 2005 Reporting Services (SSRS) Report Builder (SQL307). Adrian Rupp Business Intelligence Solutions Specialist iSolve Business Solutions. Agenda. Report Builder Model Designer. Report consumers. Business users. Power users Developers.
Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.
Adrian RuppBusiness Intelligence Solutions Specialist iSolve Business Solutions
Microsoft®SQL Server™ Management Studio
Web services interface
Drillthrough report generation
SQL Server catalog
Report Builder does not strictly display tables and joins
May denormalize relationships, rename, add calculations, etc.
Adding display fields will never eliminate rows from your result set
Group identity is strictly defined (and fixed)
Sales Person group cannot include Sales Order Date, but can include #Sales Orders (an aggregated value from Sales Order)
Fixed group identity affects where fields can be added to report
The primary entity is the entity at the top of the entity explorer at any given time
Your report is “centered around” instances of the primary entity; that is, all data in the report must be related to an instance of the primary entity
The primary entity may change when:
Adding items fields to the design surface
Adding filter clauses in the filter dialog
The primary entity always changes “down”
The primary entity never changes “up” unless your report contains only totals
Standard filtering (“slice-and-dice” approach)
Main filter is applied to all data in the report, including aggregates
Most common scenario, most like competitive tools
Report Builder default
Filter only affects the set of instances (rows) displayed
Is NOT applied to aggregates in the report
Must uncheck option on filter page to enable
Can add different filters to each aggregate in report
Can be used with standard or precision filtering
Right-click on aggregate field in report, select “Edit Formula”, double-click formula to expand and add a filter
“Show me products and sales in 2003” can mean:
Show any product with sales in 2003, and the sales from 2003 (standard filter – affects products shown and sales aggregate)
Show any product with sales in 2003, and all the sales for those products (precision filter, does not affect aggregate)
Show all products and any sales of those products in 2003 (no main filter, filtered aggregate)