Hi faulknerwilliam2,

Hi. I hope/pray you are doing great upon reading this reply.

As an alternative, you may sort the data directly to your RDL. To do that, please highlight the entire row of your table (the one that will show the data/ result set, do not include the table header), then right click:

Choose Tablix Properties...

Then on the dialog box, kindly choose Sorting on the left side of choices (other choices are General, Visibility, Filters).

Then on the left side there is a choice to Sort By, it is a drop down button in which you could choose your field named [date_ordered].

Then click OK button.

Note: If you will try to do this, you may want to remove the [font="Courier New"]ORDER BY[/font] clause in your T-SQL. The advantage of this is that it will sort the data right after the RDL fetched the result set, thus, it will somehow lessen the "burden" in your database I think, but I could be wrong, just an opinion. 😀

Thank you and Godspeed.

Respectfully Yours,

Mark Squall