Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
Hi all,
We do most of our customer reports based off the GL_DetailPostings table.
I have a few reports filtered to only show "SO" module transactions and I pull in some additional data from the InvoiceHistoryHeader table but now am being asked to…
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…
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…
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…
Using Sage 100 Premium 2017
Using Crystal Reports 2011
I have six production SQL databases, all structured identically (for regional purposes).
I have created a Crystal Report using a Connection based on OLEDB using one of the 6 databases. It uses…
We run just the Financials in our SQL version of Sage 100. Recently, none of my canned reports will run. The error:
"The database login failed. Logon failed. Details [Database Vendor Code: 6]...Unable to connect: incorrect log on parameters..."
This…
