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...

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...

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...

Location of the PASS Summit Follow-up

I got a little distracted after lunch and was reading through some of the various bloggers reactions to the decision...

Log Growing Pains Article

I Just had an article published at SQLServercentral on troubleshooting the cause of log growths.  At the conclusion of that...

Maintenance Plan Issues

I think maintenance plans were a great improvement in SQL Server 2005, with a more visual designer and the ability...

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 in a...

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 appear. ...

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...

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...