Using Derived Tables to Create SRS Reports for Dynamics GP

People often want to create reports in SRS with data from multiple periods. For example, you may want a report with year-to-date (YTD) numbers in one column and month-to-date (MTD) numbers in another column. Or you might want budget data in one column and actuals in a second column.

Follow this link:
Using Derived Tables to Create SRS Reports for Dynamics GP