• 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