Sir Fredrick
September 12th, 2004, 03:27 PM
Hello,
I work for a library and we have a massive amount of statistics we are required to track by law. Once upon a time we were using a FileMaker database for tracking all the information, but it was really becoming unmanageable, so I was assigned to a project to convert the database to SQL on MS SQL Server, which I have done.
The question now is, what is the best way to extract the data for presentation?
FileMaker looks the way they want it to, but is a kluge at best. MS Access doesn't seem to be any better and seems to have problems of its own that make it unsuitable.
Is Crystal Reports the answer? How does it handle SQL/ODBC? Will I be able to make the reports look similar to FileMaker? Can the reports be interactive on screen allowing the user to click on a button on one report to go to another report?
Thanks.
I work for a library and we have a massive amount of statistics we are required to track by law. Once upon a time we were using a FileMaker database for tracking all the information, but it was really becoming unmanageable, so I was assigned to a project to convert the database to SQL on MS SQL Server, which I have done.
The question now is, what is the best way to extract the data for presentation?
FileMaker looks the way they want it to, but is a kluge at best. MS Access doesn't seem to be any better and seems to have problems of its own that make it unsuitable.
Is Crystal Reports the answer? How does it handle SQL/ODBC? Will I be able to make the reports look similar to FileMaker? Can the reports be interactive on screen allowing the user to click on a button on one report to go to another report?
Thanks.