CR8, VB6 Update Database Info Help 1

[Ferlin]

Hello All,

I am in the process of creating a Payroll System in Visual Basic 6. I have just started to use Crystal Reports 8 to do all my reports in. I am working on the Check printing report now, and was wondering if some of you could help me with this little problem. All help would be greatly appreciated.

I am using MS SQL Server 2000 by the way. I have a formula that takes a starting Check Number from a control file and starts the First Check with that number then adds to it each time it prints anoter check.

In the Table that the Money (Taxes, Gross, Net, etc...) is stored in there is a Check Number Field. I would like to be able to take the Check Number that is being printed on the Check and Write it back into the Record in the Table that it is printing the Check From.

How would I go about doing this?

Thanks In Advance.

Ferlin.

 

[kenhamady]

Since CR can't write to a file, this really isn't a CR question but a VB question. You will have to replicate the query used by CR to get the checks to be written. Then you will have to loop through the records adding 1 to a counter each time, and using this table to update the database. CR won't help you here, I'm afraid. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com