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…
Paul Turley's SQL Server BI Blog
sharing my experiences with the Microsoft data platform, SQL Server BI, Data Modeling, SSAS Design, Power Pivot, Power BI, SSRS Advanced Design, Power BI, Dashboards & Visualization since 2009
Being named an MVP this year is very exciting news for me. As I was trying to come up with…
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.
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
There are certain key words in a T-SQL query than cannot be parameterized, including the TOP statement.
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.
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…
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.
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
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.
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.
Chart reports are an effective way to visualize data to show trends and comparisons in a way that can help…
What lessons have we learned about managing report projects and what are the best practices? Since each report is stored…
How should date type parameters be prompted? There are two common approaches depending on how you want the parameter to…
Subscriptions in Reporting Services are designed to run on a schedule and there isn?t a built-in feature to just run…