Hello Everyone,
Here is the situation. I have to pull a crystal report every day from a single table on a database. This process needs to be automated. I have no issues with the crystal report data, or the automation, the issue is that every day the table I need to pull the data from changes. It changes in a predictable pattern, journal_yyyymmdd, but the table name does change. The fields inside the table remain the same, just the table name changes. How can I add this logic to the crystal report itself so it will change which table it reads from every day? Thanks in advance for any help you can provide.