Foxy69
Apr 24th, 2006, 07:12 PM
Can Crystal run a SQL UPDATE query?
I need to print a dcoument that has a tear off cheque at the bottom of each page. If the print goes onto more than one page I need to print 'XXXX's' over the cheque so it cant be used. I pass a paramater for the start cheque number so if I void a cheque I can use the page count to add to the start cheque number to know what cheque number has been issued. The problem then is that I need the valid cheque number recording back into the database. This will also be run in a batch so several cheques will be printed.
I will be running the final report from VB.NET. I thought I could count the number of transactions prior to printing the report to try and second gues what cheque number will be issued to which account but if the report gets changed it would stuff the VB program.
I need to print a dcoument that has a tear off cheque at the bottom of each page. If the print goes onto more than one page I need to print 'XXXX's' over the cheque so it cant be used. I pass a paramater for the start cheque number so if I void a cheque I can use the page count to add to the start cheque number to know what cheque number has been issued. The problem then is that I need the valid cheque number recording back into the database. This will also be run in a batch so several cheques will be printed.
I will be running the final report from VB.NET. I thought I could count the number of transactions prior to printing the report to try and second gues what cheque number will be issued to which account but if the report gets changed it would stuff the VB program.