Maybe..?
WITH RN AS (
  SELECT t.[STATUS],
        t.RequiredByDate,
        t.WorkOrder,
        DENSE_RANK() OVER (ORDER BY t.RequiredByDate DESC)...

MSDN gives pretty good detail and examples on how to use these functions:
LEAD (Transact-SQL)
LAG (Transact-SQL)

They effectively work in the same way,...

What was your actual aim here, was it for grouping, display purposes? Changing the data type of a field (in this case DATE to STRING) isn't always the best idea....

Insert a List object into your report, and set it to use the required dataset in its Tablix Properties. Then create a grouping on that list for your Country field...

It's a definite shame for the newer users, who clearly have tried their best, but don't quite understand some of the principles. The ones that maybe do post a screenshot...

Please supply DDL and sample data in a digestible format for T-SQL. You'll get a much quicker answer.

One solution, using PIVOT:
CREATE TABLE #Sample (ID VARCHAR(10),

Can you supply some DDL and sample data? We can't access your data, so we need something to work with.

Thanks.

As the others have said, this is presentation layer. If you were to reduce the accuracy of a column that contained 0's, you would have to apply that logic to...

0.00 does equal 0, rounding it is still going to give you the same result (0.00). What is it you are after here exactly, only the Integer part of the...