How many datasets do you have, and what is the complexity of the report query and report layout. Many times the performance of a report can be assisted, by...

If you open the report created in 2008, while in 2008 R2, are you prompted to run through a conversion? If not, I don't think you need to convert....

Do you have a list of clients who have images, that you could use to create a table in the db? If so, you could then use that table...

Have you considered using a CASE statement in your query that creates output relative only to Q1 and then another that will give you YTD?

How many clients do not have images?

If not a huge number, how about choosing an image as a default, and placing it in the same folder, and then duplicating and...

:laugh:

Thanks zerko!

SQL 2000, at least from what I can determine would be.

SELECT TOP 22 * FROM sysobjects ORDER BY refdate DESC

Send a screenshot of the grouping section for each table so we have a better understanding of what that looks like.

Thanks, good question! 🙂

My potentially very flawed logic was to choose the item with "OFF" as the outlier and answer 1.

Good question, thanks. 🙂

Thanks Dave! Happy New Year!:-D

Or more than once... :crazy:

Selecting yes will run the package with the last successful configuration. It is kind of like Windows restore.

As mentioned, any order by, group, select distinct, where will slow down the report.