• Sage 100 2022 Premium Crystal Reports Database Login Failed. Unable to connect: Incorrect log on parameters

    Hello I'm upgrading from 2018 Advance to 2022 Premium. When on the server we can run canned reports within Sage 2022 without error. When we try and run reports from a client 2022 workstation we get "The database login failed. Error in File GL_ChartofAccountxxx…
  • Sage 100 PM WT Traveler Crystal Report - Steps Repeat

    Hi, Hoping someone knows how to get the details sections of a crystal report to not repeat the same values as I can not have step instructions and signoff information repeat I moved things around in the PM WT Traveler report that came with the install…
  • HRMS and Sage 100 coexisting on the same PC

    I know there is an order for installation that will allow HRMS and Sage 100 to peacefully co-exist on the same PC, however I am not sure what the exact order is. Also when ever we do a quarter update with HRMS, we invariably break Sage 100 (specifically…
  • 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:…
  • Information on fields from Wrk tables? Needed for Knowledge Sync.

    Hello, I'm looking to re-create a Crystal report so that it can be run by Knowledge Sync. I initially wanted to just use the report provided by SAGE, but it looks like I can't use this report as the information the SAGE report pulls is only generated…
  • 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…