Ok, this is not too difficult. I'm going to assume that your event numbers are strings and that your "date" parameters are strings in the format 'YYMM'. If they're not, this should still give you the logic that you need.
Working in the "Last Year" report, do the following:
1. Create a formula that I'll call
{@LastYearDate} that looks something like this:
Right('0' + ToText(ToNumber(left({table.event_number}, 2) + 1), 0), 2) + mid({table.event_number}, 3, length({table_event_number)-2)
This adds 1 to the year of the event number and makes sure that it has a leading '0' if the year is less than 10. We'll use this for the link.
2. Set up your subreport links - link from your start date to this formula and from your end date to this formula. This will automatically set up the parameters in the subreport with a prefix of "PM_".
3. Go to the Select Expert for the subreport. When you set up a subreport link, Crystal creates record selection criteria with "=". Modify the selection criteria so that your formula is >= the start parameter and <= the end parameter.
-Dell
Edited by hilfy - 26 Aug 2010 at 6:03am
IP Logged
