What I did is create a report using AR Customer Listing, then called that report from code and passed the customer ID as the parameter from the screen. The script then exports the report as a PDF and previews the PDF.

However, this is in 2019. Not sure if that same type of script would work in 2014. I recall being able to call a custom Crystal Report directly back in 2014, however the version of Crystal Reports changed somewhere along the way and you were no longer able to do that.

Yeah. that's why I.m not going that route. Each new version of Sage, Crystal Reports and OS .Net throws

too much upgrade overhead. If I had twenty reports and custom scripting to go with it...bad road.

I'm using an ODBC connection and a quick front end (possibly Access). Down side of that is the overhead

of Access and all it's baggage, upgrades, licensing $$...bah humbug

Lazarus is probably where I'll end up. Seems to just work with ODBC. At least ODBC isn't a moving target.

Awesome day though!!!

DataLinkViewer (Millet software) is a great ODBC based report running interface and very cost effective.

DataLinkViewer (Millet software) is a great ODBC based report running interface and very cost effective.

I will take a look. thanks Kevin

OpenOffice and Apache Office Base and Calc connects nicely to Sage and are free. A snag with those however is Sage won't recognize anything but Excel natively..and most companies don't snoop for alternatives to Office.