I am Building a report in Report Builder i am using a table that displays all Outstanding Orders based on a column in the table called Due Date. there is also a column for the value of that order.
What i would like to be able to do is to display Total values for Late Orders and all Forward Orders.
So i would like the report to show all orders prior to CURRENT DATE and then another seperate query to show all forward orders from CURRENT DATE
can anybody help i am very new to Report Builder And SQL In general