I'm using Crystal with Nortel's CCMS. Nortel creates a different database table for every day for certain types of data.
I have a report that runs off the table. Currently, to look at a different day, I have to go Database->Set Datasource location->Select the table for the day.
Is there *any* way to do that automatically? VBScript? Some secret third party tool? Some piece of Crystal Enterprise (which I don't have, but might be able to get if I have an issue like this)?
I'd like to pass the report to people that aren't very crystal saavy, but having to change the datasource in two places (it uses a subreport as well) means I can't really do that....