Hitachi Consulting’s Announcement About by MVP Award
Being named an MVP this year is very exciting news for me. As I was trying to come up with…
Month: March 2010
Report Recipe Book Released
Our SQL Server Reporting Services Recipe book was released in April. This is a cookbook style book for experienced SSRS designers with 63 individual report recipes, each addressing a specific business requirement or scenario. My co-author, Robert Bruckner, is a technical lead on the SSRS product team and a prolific blogger on the topic. The book is about 630 pages long and took about a year to write. The book takes a unique approach by providing recipes and step-by-step instructions to solve specific business problems.
Return the Value of a Specified Dataset Row Outside a Data Region
I want to return the field value for a specific row to a textbox below a table in my report. To pull this off, I have to be a little creative as there isn’t a simple way to return a value from a specific row in a dataset
How to parameterize a TOP values query
There are certain key words in a T-SQL query than cannot be parameterized, including the TOP statement.
User is prompted to login when viewing a report
A user has been added to a SSRS role for the report folder or report but is still prompted to login. This can happen if Internet Explorer isn’t configured to persist the user’s Windows login to Intranet sites.
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…
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…