Providing filters to report users. This article demonstrates providing dropdown choices to users to use as filters on the report. First I’ll start with two sprocs, one to populate choices for the filter, the other to populate the report based on the user’s choice in the filter. . Now I’ll create a new report, and…
Integrating drill-down capability so users can expand/collapse grouped records. As I illustrated in my Nested Groups article, it’s important to provide grouping of records where such groups naturally exist within a dataset. Equally important to the user will be their ability to expand/collapse those groups to conserve screen real estate when viewing large reports containing…
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…
Domains of Consistency Since I began developing web sites in ’96, this must be one of the most under-valued, overlooked, and most expensive concept to ignore. I once read statistics regarding the amount of time planning a web site up front as opposed to “figuring it out” as the project dragged on, they were quite…
Making Search Easier to Use. Visual Studio’s “Quick Find/Replace” (F/R) is a common staple for many web developers seeking to make batch replacements of strings within their code. However, one often overlooked feature within the IDE is “Incremental Search” (IR). This handy utility provides find capabilities similar to that of many “web developer” toolbars provided…
TechMbaBi 