Uploading the report made in visual studio earlier

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 display Data 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 interest Select “Expression…” from the dropdown list From 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” row From 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 necessary Customize 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 example perhaps 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 reports Provide 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 Source Click the “Query Designer” button From Query Designer: Select the desired fields from the “Database view” panel Click the “Add Filter” button Customize the filter in the “Applied filters” panel as required Select the “Parameter” checkbox Verify that the new Parameter has been added to the Parameters node of the Report Data Window.

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture