Current Year vs. Prior Year reporting


Bill Yater

Has anyone here developed a custom report (RMS Active Report or Crystal
Report) which gives a breakdown of sales by a certain period (usually by
month), then compares that to the same period in a prior year?

Our retail division manager is trying to see, at one glance, how sales in
2006, broken down by month, compare to sales during the same month last
year. I can generate a SQL query to do this, and I can dump the results into
Excel, but I'd like her to be able to do this herself and have a formatted

I looked in the Reports section of CustomerSource, and did not see anything
like this mentioned. I have not worked with Crystal Reports, and I suspect
this sort of thing can't be done easily (if at all) with the RMS Active

Bill Yater
The Worth Collection
(e-mail address removed)


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question