• Sage 100 Premium 2020 SQL Server Transactional Replication for Reporting

    Version: Sage 100cloud Premium 2020 (Version 6.20.0.01) Additional software: Scanco Operations Management & Multi-bin, Some custom DSD programming Hello all! First post here. Looking for some assistance when it comes to replicating data for reporting…
  • Sage100 Crystal Report designer preview asking for a password

    I'm editing accounts payable checks in crystal reports. I click on "View" and then "Preview". It then has a popup that says OLE DB, and then has the following fields: Server: OURSERVER\SAGE100V2017 User ID: Mas_Reports Pasword: *blank Database:…
  • How do I use crystal reports for sage to connect with sage Premium 100 so I can create my own reports?

    We are using Sage Premium 100, and have crystal reports for sage installed. We have the SQL version of sage. My user role is an 'admin' in sage. I know how to get to the place to make a new database connection, however, I am lost after that. I would appreciate…