Integrating custom information into the footer of reports. When deploying multiple reports for user consumption, it’s helpful to users if they have helpful information when traversing the data and that data remains in a consistent location in every report. To illustrate how to accomplish this goal, I’ll begin where the Calculation – Field Formatting article…
Implementing custom logic within a field. To illustrate how to apply specifying formatting based on values, I’ll begin where my Calculation – Field Formatting article left off. As you can see viewing the resultset, the Salaried Flag column displays True/False values which isn’t very intuitive. To translate these values at runtime to more helpful Yes/No…
Applying a custom format to date values. Since most date values returned in a dataset aren’t very intuitive due to their default precision, applying a custom format helps the user to understand them better. To illustrate how to accomplish this task, I’ll begin where the Global Collections article ended. As you can see, the report…
Applying sort ability to columns. When report data exceeded many pages, it’s important to provide a mechanism for users to easily change the sequence of the rows. I’l begin with an existing report which displays 7 pages of data concerning employee sick hours. To apply a sort to the Title column, I’ll configure Interactive Sorting…
Denoting data trends by applying logic-controlled formatting, for example, employees with the most amount of accumulated Sick Leave. To illustrate how to apply specifying formatting based on values, I’ll begin with a dataset that returns employee data. By viewing the resultset, it’s difficult to discern any distinguishable trends in the data. To denote those employees…
What is SQL Server Reporting Services (SSRS) SQL Server Reporting Services (SSRS) is Microsoft’s platform for designing, developing and delivering dynamic reports. Report Types SSRS provides a variety of reports such: Tabular, Matrix reports (crosstab or pivot table) – for summarizing data and reviewing it in multiple dimensions, charts and graphs – for visually illustrating…
Using Views to generate source data within a package. Following the same steps to create a package in the Table to text file article, I begin with an SSIS Project and a starting package. Instead of using the default package, I’ll delete it and select to create a new package using the Import/Export Wizard. After…
Combining records from different data sources. I’ll begin with two separate text files, each representing sales from two states: California and Oregon. First, I’ll add a DataFlow task and add to it two Flat File sources each configured to pull in data from the text files. When configuring the sources, it’s imperative to ensure the…
Reading data from text files. I’ll begin with two separate text files, each representing sales from two states: California and Oregon. First, I’ll add a DataFlow task and add add to it two Flat File sources each configured to pull in data from the text files. When configuring the sources, it’s imperative to ensure the…
Creating an SSIS Package to consume a table and write the recordset into a text file. Rename package to match project Next, Create data source allowing access to sql table. create connection manager. Next, select the source database. Create a data flow task and give it a name indicating its purpose. Double-click the task to edit…
TechMbaBi 