is it possible to have crystal reports execute a simple command line or stored procedure before running the report?
i just need this run:
DELETE FROM udVerified
WHERE Vendor > 0
INSERT udVerified (Vendor)
select Vendor from APVC
where APCo = 1 and Verify = 'N'
before data is populated into the actual report.
I've attempted to add it in the Add Command Line .. but i just get errors. IDEAS?