Automating Crystal Reports to update filters when refreshed
I’m using crystal reports to run reports from a HP Service Center implementation.
I’ve set up a bunch of reports that people who need them can refresh, but the only problem is that they’re generally weekly or monthly reports and I want them to automatically filter by the most recent complete week or month.
I’ve tried using parameters, but some of the people refreshing the reports can’t even seem to handle that – either they forget to change the timeframe they’re looking at, or they do it wrong. Is there anyway to make it automatically so that when you refresh it only returns data from the week or month beforehand?