jmerulla
asked on
Export data out of mas90
Is there a way to export data out of mas90? I need to run an employee history report (hire date, term dates) etc covering the past 7 years. The information is in Mas90 but how do I get it out into an Excel or similar form?
thanks
thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You can use the Report Master to export to Excel as long as there are fewer than 16,000 records. That's a MAS90 limit. Use the dBase format if there's more than 16K, I prefer dBase format anyway because there are column headings and text columns export as text even if they happen to be numeric text.
Custom Reports and all reports with the new native version 4.0 modules are Crystal based and can be exported to Excel with the export button at the top of the preview window.
Custom Reports and all reports with the new native version 4.0 modules are Crystal based and can be exported to Excel with the export button at the top of the preview window.
You really don't need to export data from MAS90. In Excel, e.g., you can simply go to Data/Get External Data/New Database Query. Select SOTAMAS90. You will see the familiar MAS90 logon prompt. The rest is pretty self-explanatory.
ASKER