Hi Jessica,
Thanks for your help 😉
My confusion was that as per your report I wanted the [OrderDate] field in the heading column. As a newbie to SSRS I was bringing up the wrong Properties window and when running the report through Report Manager I was getting the constant I'd input into the heading box. All sorted now..
Dan 😀
MCTS | MCITP | Microsoft SQL Server 2008 Administration & Development
MCSA | MCSE | Business Intelligence SQL Server 2012