I am using Crystal Reports XI.

Could you tell if it is possible, and if so, how to create a crystal report that will do the following?

I need to show suppliers that we have not used for a couple of years. I know I cannot do this using the select expert to just say 'only when year is not 2010' because that will just show 2009 - 2008 data even if 2010 data exists. Is there any way I can tell it to only show data if it doesn't exist past a certain date? I believe that this is done in SQL using an 'If Exists' comman. Is there a similar function for Crystal Reports?

Thank you.

This worked perfectly thanks! I made it so that the user could choose the last year as a parameter so they're jumping up and down for joy! 

Edited by MrCastalum - 15 Apr 2010 at 4:13am

Thank you very much for this. Years later it is still very helpful.




Edited by tpreston - 19 Jun 2015 at 10:13am