there is a peice of software called "service CEO" created by "Insight Direct" ( and it pretty much manages the entire accounting & billing sections of a business/company. Crystal reports is the solution they use to print reports out of their MSSQL (odbc) database. There are forms for "work orders" and forms for "invoices" and the invoices can be created to charge for multiple jobs... So, each invoice could have jobs from more than 1 work order.
My goal is to be able to get the work order number from the work order report, and list it on the invoice report per each job we're charging them for on that specific invoice.
I guess that leads me to my main question...
What do i need to do to grab a field from another report's database and use it?
My goal is to be able to get the work order number from the work order report, and list it on the invoice report per each job we're charging them for on that specific invoice.
I guess that leads me to my main question...
What do i need to do to grab a field from another report's database and use it?