Pros and Cons
- The scheduling functionality allows different departments and users to plan ahead for their needs and either export or email the results. Scheduled reports comes in very handy when you need to export the data to third party companies or to a network location for batch processing. This allows us to provide current data with much more frequency.
- LiveExcel functionality gives you the ability to connect your query to Microsoft Excel so users do not need to log into the product to run the results. This also allows the creation of VBA Macros to process the data and provide users with the final product on demand.
- The product has had its growing pains as newer versions have come out. The transfer of old queries to the newer systems has caused some duplication of mapped files or fields and they have not come up with a tool yet to help merge these duplication.
- Wish they had better internal reporting so I could easily find the different reports that are using links and the fields they are linking with.
- I have noticed, being an admin, that the more connections and reports that are available the slower the system becomes when opening it. It would be nice to have nothing come up first and then show more once I drill into the area I want.