I have a number of crystal reports that select data from a table based on the year. The data is divided up into tables for each year and contain about 50,000 records each. The system is setup to read the tables this way and concatting the tables into one is not an option. The question is: Is it possible to set up crystal reports so that the user can choose the table to read at runtime instead of having to amend each report to change the table ? Obviously all columns have the same name within the table.
You can change the datsource using Set Database Location but if it's not done carefeully you will destroy the report, so I would not ever expect a user to do it.