100%(1)1 out of 1 people found this document helpful
This preview shows page 81 - 90 out of 103 pages.
•Uploading the report made in visual studio earlier.•Just click on the Upload button in the report server and find the location.•Now we can run our both reports directly from the server.
Visual Presentation of Data•The SSRS Report Builders provide a wide variety of visual controls for presenting data•The two major categories are:Data Regions (Tablix) –tabular / numeric displayData Visualizations –graphical display•To format a cell in a Tablix:Select the cell Change to the Home tab and change the Category dropdown (ex. Currency)From the Properties Window change the required parameters
Visual Presentation of Data•To add/edit an expression for a cell in a Tablix:Right click the cell of interestSelect “Expression…” from the dropdown listFrom the Expression Window add/modify the expression as required•Note that Data controls can be nested (Nested Regions) which allows us to place controls inside controls
Tables, Lists and Grouping•Which Tablix provides the most information?
The Matrix•The Matrix Tablix allows to group by rows and columns to expand and collapse groups of columns and rows to provide more or less detail as required•Supports a variable number of columns•Similar to Pivot Tables in Excel
Pagination Support•To enable the Column Headers on each page for a table:From the Column Groups dropdown enable “Advanced Mode”From Row Groups, select the top “Static” rowFrom the Properties Window, set the “RepeatOnNewPage” property to True•To enable headers and footers on each page of a report:From the “Insert” Tab, select “Header”->”Add Header” Customize this header with Text Boxes and Images as necessaryCustomize the footer to include page numbers and other necessary information•To do a “Print Preview”Click the “Print Layout” button in the Run Ribbon.
Report Parameters•What if we can not predict what exact subset of data the user is interested in? For exampleperhaps the user is interested in sales over the last year, year to data, last quarter, last month or last week. Perhaps the user is interested in these sales for a specific store, province or country. Perhaps the user is interested only in products of a certain category.•Report parameters allow to dynamically change the WHERE clause based on the user’s requirements. Helps in avoiding having to create multiple similar reportsProvide lots of flexibility for users.
Report Parameters•To add a report parameter:Add an embedded Dataset Using the wizard:Select the “embedded” dataset option and an existing Data SourceClick the “Query Designer” buttonFrom Query Designer:Select the desired fields from the “Database view” panelClick the “Add Filter” buttonCustomize the filter in the “Applied filters” panel as requiredSelect the “Parameter” checkboxVerify that the new Parameter has been added to the Parameters node of the Report Data Window.