Good point GSquared. Sometimes it's easier to go down that path.

I have tried variations of each and was able to get is done by partitioning. Every other method produced the same results. Was very surprised to see...

Vic... yes, SQL 2005. Added an alias, no go.

Noel... bad design! 😀 I removed the ORDER BY and still get no results. Even just added...

Its more than a logo actually. I need to customize various objects on the report depending on the result. Logo, address, terms & condition, etc. If I...