Displaying a Check Mark for a Row When a Related Record Exists
Let’s say that you have a column named some_id in an outer-joined table that will return a value if a record exists and will return null if a record doesn’t exist…
Category: SSRS Design
Nested Tables in a Repeating List Data Region
Report designers often revert to overly complex report designs and often use subreports unnecessarily. Building a report on a single dataset query to return all related rows gives you greater flexibility to group and filter the data.
Alternate Row Colors in an SSRS 2000 or 2005 Matrix
To create a “greenbar” report in a table with alternating row colors, you can simply use the RowNumber function to determine whether a row is odd or even. This also works with the newer Tablix-style matrix in SSRS 2008
Navigating to a Report in a Pop-up Window
When using the Jump to Report action in the web browser, the target report is displayed in the same browser window by default. You can call the JavaScript window.open method to open a new browser window. Use an expression to build a Jump to URL action with the appropriate report server, folders, report name and parameter values.
Creating a Business Scorecard
Report Recipes
This is the second in a series of three articles highlighting the Report Solution Patterns and Recipes from Chapter 7 of Professional SQL Server 2005 Reporting Services.
Column Chart with Goal Threshold Line
Chart reports are an effective way to visualize data to show trends and comparisons in a way that can help…
Managing Report Project Deployments & Version Control
What lessons have we learned about managing report projects and what are the best practices? Since each report is stored…
MDX Datasets with Date Parameters
How should date type parameters be prompted? There are two common approaches depending on how you want the parameter to…
Manually Starting a Report Subscription
Subscriptions in Reporting Services are designed to run on a schedule and there isn?t a built-in feature to just run…
The Low Down on Drill-Down
Printed reports were the norm for decades. When a user wanted to get some important information, they would use their…
Showing User-related Content in a Report
In cases where you want the data or content in a report to be different for each user, there are…
Using a Report Subscription with User Authentication
This question comes up quite often. A report requires a user to be authenticated using their own network user name…
Parameterized Top Values Report
Top ranked lists are a common type of report. In many cases business users may want to see only a…
Self-Service Reporting Best Practices on the Microsoft BI Platform
Article from the Architecture Journal 12-15-2009 by Paul Turley Once upon a time, there was a big company whose IT…
Drill-through Report Link Breadcrumbs
If you have created multiple drill-through reports, you know that the report navigation works in one direction and that some…