Report to cover multi databases 1

[gol4]

using CR8
Our new system each month creates a new database names it in format of mmyyyy and creates new tables and renames them in the same format mmyyyy. For last month it is 062003.mdb and a table name would be cd062003. My problem is how do I create a report that will allow me to report out of each of these databases. I have to create several formula fields to get the data I want and I just can't see me having to recreate these reports each month re-linking tables and renaming fields. Im sure my situation is not unique and wondering how others handle this. Appreciate any feedback. Thanks

 

[StevenK]

First question : What is the database you are running against ?
I'm assuming that it's SQL Server ?

If the structure of the databases / tables is the same throughout the created databases you might like to consider the following idea(s) :
- A report can be developed against one database and then run against another (by using the 'Database' -> 'Set Location' option from the menu)
- As required the user(s) might look at resetting the location of the database / tables for each new database created.
- Alternatively you might look at some external code to allow the report tables to be set up easier (without the need for opening up Crystal Reports and going through that means) - this is easily achieved using something like Delphi / VB / C#.NET if you have access to someone with such skills.

I hope that this puts you in the right direction with things.
Steve

 

[gol4]

I voted it as helpful
The solution was not set database location as in trying that earlier my formulas did not work correctly as they were done as

if {cd052003.delaycode}= "a" would always test false since the new database was now called cd062003
but in going over your suggested solutionthinking I may have missed something. as soon as I hit the dropdown there it was starring me in the face
SET Alias

Don't know why I did not think of it in my earlier braindead state but I'm set now Thanks