Hello!

I got a new project on my desk and have no idea how to accomplish it.
I am working with SQL Server 2012 and Crystal Reports 11.
I have a report that is being emailed through an automated email application (Reportal) to the Ink Department.
The email contains a list of job numbers and job description for all jobs in process that need ink mixed.
The Operations Manager is upset because it takes a long time for the ink matcher to clock in each job number and say ink mix is done.
He wants me to add a button on the report and somehow pass the job number for each row to some kind of code that would clock the ink matcher into the job.

I have a theory, if it can be explained into words, it can be done.
I spent the last two days reading and trying to come up with a plan.

Apparently I need to create a DLL - ActiveX which can be copied into the Crystal Report folder and used as a function in the Crystal Report.

I could use a hyperlink and in the hyperlink formula call out this function, and pass the job number for each row to the function which will insert a record into the Production table (which records each clock in).

I know SQL, I know how to insert a record in a table... I actually wrote the code.... but I don't know how to create a DLL that would contain that code.

To do that, I need Visual Basic and have no idea how to use it.

Can anyone help me with this?

Thank you!