How to Build a PDF Report with Data Extracted from the Database

Organizations and marketers often need to create PDF reports using the data in the database. If the database is being regularly updated, it takes a lot of time and manual work to create a report on a daily basis, for instance.

Now, anyone can automate this task using G-Lock Email Processor.

G-Lock Email Processor can select all records or specific records that meet a particular condition from the database and use selected data to build a PDF report.

Watch this quick 3-minute video to learn how to create a PDF report with the data extracted from the database:

Important!

Before you configure the rule in G-Lock Email Processor, you must create a system DSN to your database in Control Panel -> System and Security -> Administrative Tools -> ODBC Data Sources (32-bit).

Build a PDF Report with Data Exctracted from the Database

Download Sample Rule

Click the link below to download a sample rule with the report

>> Download Sample Rule (.zip file)

The ZIP file contains the Select_from_database_and_create_report.txt file, the Reports folder, and the test.mdb database.

Save the Select_from_database_and_create_report.txt file and the Reports folder to C:\ProgramData\G-Lock Software\Email Processor\Rules

Save the test.mdb database to the root folder on the D: drive.

To get the rule working, create a system DSN called GEP_32.

To test the rule, click on “Test Rule” option in G-Lock Email Processor.

The PDF report (report.pdf) is saved to the root folder on the D: drive (D:\report.pdf).



Interested? Learn more about our email parser software for Windows.

Further reading:


Leave a comment

Get «Email Marketing Secret №1» eBook for Free Today!

Many who are new to email marketing start off on the wrong foot. They ‘spray and pray’ and hope that someone will click and buy, but are hit with angry complaints and find their emails blocked as spam.

But you can significantly improve your odds of reaching customers and prospects by taking the right steps.

Get Email Marketing Secret #1 eBookDownload our PDF eBook and learn how to collect more leads and send highly responsive emails for free to grow your business and maximize your email marketing, not relying on expensive, restrictive email services that charge high monthly fees and ultimately control your profit at their whim. Be in control of your email…

This offer is limited! Act fast!

LAST STEP


Get Email Marketing Secret #1 eBook

Where should We
send the Free book?

Easily save as a PDF or print for daily use

Privacy Policy: We hate SPAM and promise to keep your email address safe.