How do I run a report that will compare two years of information?

If you want to run a report that will compare records from one month of one year to same month for the next year, you need to run the roster report and put in as your received dates for both years. For example 4/1/08 through 4/1/09. Filter out any other fields that you need and download the report to the Relospec file keeping the name the same. (Roster)

Open any report that has “YTD” in the name. 4 boxes will open at the bottom of the page. In the Month Begin Date enter “4/1/2008”. In Month End Date enter “4/30/2008”. In YTD Begin Date enter “4/1/2009” and in YTD End Date enter “4/30/2009” and click PREVIEW.

To compare two years worth of records you and run the dates 1/1/07 through 12/31/08. In the Month Begin Date enter “1/1/07”. In Month End Date enter “12/31/07”. In YTD Begin Date enter “1/1/2008” and in YTD End Date enter “12/31/2008” and click PREVIEW

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: