<div>
You need to do this in your query.<br />
It is best to have a begin and end date to control the output from the sql server to the report.
</div>


<div>
can you give me some help in acheiving it in the query?
</div>


EETestQuery.sql

<div>
<div class="content wysiwyg-content">
Hi All<br />
<br />
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.<br />
<br />
What i would like to be able to do is to display Total values for Late Orders and all Forward Orders.<br />
<br />
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<br />
<br />
can anybody help i am very new to Report Builder And SQL In general
</div>
</div>


Hi All

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

You need to do this in your query.
It is best to have a begin and end date to control the output from the sql server to the report.

can you give me some help in acheiving it in the query?

SQL Expression

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.

SSRS

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.