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...
2010-03-21
540 reads
SQL Server BI Blog
Dynamically Adding and Removing Columns to a Query and Report
Creating one report to meet multiple business requirements can save a lot of work
down the road. A common scenario is...
2010-03-16
808 reads
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...
2010-03-16
427 reads
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....
2010-03-16
1,906 reads
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. Consider the followong attempt...
2010-03-16
795 reads
SPB Applications for Windows Mobile
<<placeholder>>
…for product review
Weblog by Paul Turley and SQL Server BI Blog.
2010-03-12
413 reads
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...
2010-03-11
418 reads
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...
2010-03-11
581 reads
Creating a Recursive Report from a Parent Child Dimension
Reporting Services supports recursive hierarchies and Analysis Services supports parent-child
dimensions…
…and these two powerful features ought to just work together seamlessly,...
2010-03-11
7,537 reads
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 and...
2010-03-11
409 reads
Blogs
PowerPoint to HTML with Claude AI
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Don’t Miss Out – SQL Server Query Tuning Fundamentals Starts Next Monday!
Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning...
Monday Monitor Tips: SQL Auditing Preview
By Steve Jones
One of the features we advocates have been advocating for is a better way...
Forums
SSRS shared dataset parameters not showing in expression builder
I am creating shared datasets that our executive staff can use for creating reports...
SSRS shared dataset parameters not showing in expression builder
I am creating shared datasets that our executive staff can use for creating reports...
Delta Lake: The Definitive Guide: Modern Data Lakehouse Architectures with Data Lakes
Comments posted to this topic are about the item Delta Lake: The Definitive Guide:...
Question of the Day
The Decoded Value
In SQL Server 2025, what is returned from this code:
DECLARE @message VARCHAR(50) = 'Hello SQL Server 2025!'; DECLARE @encoded VARCHAR(MAX); SET @encoded = BASE64_ENCODE(CAST(@message AS VARBINARY(1000))); SELECT BASE64_DECODE(@encoded)See possible answers