Personalization, Customization and Productivity Tools

[Darkjedi]

I've got a extened description report that take a day to run and it slows the system down. So I've copied the database files and report out into a folder on my desktop and I'm wanting to run it from my pc only and not the server. Under Database Expert and Create New Conection, which one do I use to add my three databases too? I hope these are the correct files.

CI_ExtendedDescription.M4T

CI_Item.M4T

IM_ItemWarehouse.M4T

Crystal Reports XI Release 2

MAS 200 4.4

Thanks

Mark

[connex]

You would need to also bring along everything needed to run the ODBC driver locally.  But since the ODBC driver is the slow link in the chain such an attempt would not have speedy results. It would be better to export these table to MS Access or SQL Server and use their connector.  If you use MS Access, use the .mdb file type instead of the newer .accdb.  Does anyone have the new .accdb driver working with any version of MAS yet?

[dlevasseur]

What about an Access Pass Thru Query?  That should run much faster.

Also don't forget to vote: https://www11.v1ideas.com/SageERP/MAS90and200/Idea/Detail/1781

[Darkjedi]

When you say export these tables to MS Access, do you mean make a crystal report with one datebase and only the fields I need and export from there or is there another way to export the tables?

Thanks

[connex]

By "export these tables to MS Access" I am writing from the perspective of MAS. Perhaps I should have said "import these tables to MS Access". Once the tables are in MS Access, you can direct your slow report to the Access database using the native Access / Excel driver and your report will run much faster. I have created tools that automate this process with a couple of mouse clicks and then one can schedule the refresh of the database on the Windows scheduler overnight. You can even have an Access based report on the MAS 90 / MAS 200 menus.

[Darkjedi]

Unfortunately I've never used Access before, so I having a problem with something that should be easy, I think. I've copied the three .M4T files that I need for my report to my desktop into a folder. I've opened Access and tried the open and new data. I've went to get external data/import and tried all the options there and can't see the three database files. Is it possible to import only the three database files I need? I don't want to link to the dataserver because possible slow down. Maybe I should make a crystal report for each database and export from there and import to Access.

Thanks,

Mark

[BigLouie · Accepted solution]

In Access go to External Data and then More and then ODBC, select SOTAMAS90 and log in. Select the tables you want to use in your report. Once they are importing close the database and then base your report on the Access database.

[Darkjedi]

I did it : )   I created a database out of Access, Thanks to all that helped me. I had to bring it back to crystal and build it there, just because I don't know how to design a report in Access. What took over a day to run now takes a minute.

THANKS,

Mark

[connex]

Now you know just how slow the MAS ODBC is compared to other databases and it doesn't have to be only on your local hard drive to see huge performance benefit.