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 a...
2010-03-11
538 reads
SQL Server BI Blog
How to Script Report Deployment, Move Reports or Change Properties
On the MSDN forums I see a lot of questions about how to use program code or command
line script to...
2010-03-11
498 reads
Oracle .NET Data Provider not Supported but Necessary for Cube Design
I've decided that from now on, consulting project estimates will be padded for an
additional week to get Oracle connectivity working...
2010-03-11
450 reads
Format Date as Week of Month
You can define a calculated field for the datset outside of the query using a Visual
Basic.NET expression. In the Data...
2010-03-11
669 reads
Report Parameter Date Range
A forum poster wanted to use a StartDate parameter to limit the range of dates available
in a second parameter to...
2010-03-11
543 reads
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...
2010-03-11
1,686 reads
Navigating to a Report in a Pop-up Window
When using the Jump to Report action int he web browser, the target report is displayed
in the same browser window...
2010-03-11
431 reads
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...
2010-03-11
913 reads
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 the...
2010-03-11
2,018 reads
Parameterized Top Values Report
Top ranked lists are a common type of report. In many cases business users may want
to see only a specific...
2010-03-11
660 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...
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:...
Databricks Data Intelligence Platform: Unlocking the GenAI Revolution
Comments posted to this topic are about the item Databricks Data Intelligence Platform: Unlocking...
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