To me the greatest benefits are three:

1. Eliminate a hit against the SQL database. This is good for datasets that you can afford to update on a scheduled basis, such...

OK, one more thing, looking at one of my reports...

Shrink the body width down to the same width as your table. The report size should still be larger; for example,...

OK, here's another thing to watch out for...

Make sure your table width is only say, 2 inches (for example)...not the entire width of the body, because it is actually the...

Don't know if it would make a difference, but I have only created this kind of report using a table control, not the list control...have you tried it that way?

You don't need to do any special calculations. Go to properties for the Body element of report and set the number of colums...that should be all that's required.

Keep in mind snaking...

I have seen this happen to DTS packages stored in SQL Server if the DTS package was created or modified using the SQL 2000 version of Enterprise Manager and you try to open it...

I have used the following procedure to successfully test a disaster recovery scenario:

1. Back up the ReportServer database in SQL as you would normally back up any SQL db.

2. Use...

Try shrinking down the "white space" in the Body element of the report as small as possible. This can be done by clicking-and-dragging, or through the Size (Width, Height) properties of the...

I have used the following procedure to successfully convert a server and all existing user databases from a Case-Sensitive to a Case-Insensitive collation. Merely running the rebuildm utility will not...

I have also seen this kind of error pop up in other contexts when the NT account has been locked. You may want to check that as well.

Read the topic, "Writing Custom Code," and related topics, in the Reporting Services Books Online. You can create a custom assembly for this functionality. You can do this if you have...

This would accomplish part (not all) of your goal...but it's free. In Enterprise Manager, open a table in your database in a grid (Open Table -> Return all rows), then click the...

How about DTS packages, stored procs, views, etc. that were created in 7? Are there any special considerations there?

Brian and stacenic, I certainly appreciate the info and the link. I will post back here if I encounter any questions.

That may be helpful paring down the amount of data in the trace, as I am down to maybe 1 to 5 deadlock events occurring a day on this fairly...