Skip to Content
Author's profile photo Jamie Wiseman

Crystal Reports Year to Year Comparison Sample



welcome to another iteration of the Value Added Samples and Demos. this sample is a Year to Year Comparison Tool, created in crystal reports and utilizing webelements. this sample can be adapted to your enterprise environment and to your data.



features of the year to year comparison tool:

  1. the years can be changed by the end user using embedded select menus
  2. different summaries / measures (e.g. sales, quantity, profit) are shown in a report cross tab. the main chart measure can be changed by the end user using a select menu.
  3. the end date filter can be set by the end user…e.g. the report can be set to use year to date, month to date, etc.
  4. if you are using crystal reports 2008 the tool can contain saved data so that database traffic is minimized.
  5. there is online help that the end user can use to quickly find out how the tool works.
  6. chart formatting shows year to year decreases or increases.


you can download the year to year comparison tool here.


webElements are used to embed the select menus and options menus directly on the report. you can download webElements to add interactive controls to Crystal Reports Crystal Reports webElements. webElements are free.


this sample has instructions (on the design tab of the report itself) on setting the report to your own data environment. you can also install the sample to your own system without making any changes to see if the analytic can be useful for your business.


overview of the year to year comparison tool:


all years from the database are displayed as micro charts based on the current measure…in this case, “net revenue” is used.



the chart will display negative month to month changes with an unfilled red bar and increases are displayed with a filled green bar.




the data grid at the bottom of the report displays additional measures. these can be customized by the report developer via changes to a single formula on the report after mapping the report to their data source.



 the end user can change the main / charted measure via a select menu.



the end user can also change the end date filter of the report using several methods. the calendar is used when the end user selects “use custom end date”.



if you have an idea for a demo / sample that you would like to see built using Business Objects products such as Crystal Reports, please see the Value Added Samples and Demos WIKI. if is approved as a good demo / sample for the community, we can build it for you for free!

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Jason Cao
      Jason Cao
      Hi Jamie,
      Thanks for sharing this with the community! I hope our community will take you up on your offer to create free samples and demos for them.


      Author's profile photo Jamie Wiseman
      Jamie Wiseman
      Blog Post Author
      hi Jason,

      the sdn community is invited to request samples and demos from the "value added samples and demos" wiki that is mentioned in the blog above.

      the "year to year comparison" report is actually for a request from a community member. didn't cost them a cent either 🙂


      Author's profile photo Former Member
      Former Member
      I saved the report with data to BOE 3.1 but do not get any choices in the data selection drop-downs. Do you know what might be wrong?


      Author's profile photo Jamie Wiseman
      Jamie Wiseman
      Blog Post Author
      hi Brent,

      do you see the select menus at all? i.e. was pass-through html successfully activated on your boe servers?

      if you see only text where the menus are, then please see the installation steps for pass-through html in the webelements users guide...
      Crystal Reports webElements

      if you see an empty select menu, then the report's data was not successfully saved on the boe this case, you shouldn't see any data at all on the main report as well. try saving it again via the crystal reports designer.