-
April 2nd, 2009, 03:37 PM
#1
Execute SQL from crystal report when printing
Hello all. Please help me.
I have a crystal report.
I want to execute an Update query when the reports are printed.
In one of the tables that are a source for the report, i have field called "print_flag".
When anyone prints a document then i want to change that flag from "N" to "y".
Please help with this!!
From searching on web i found that there is a
"whileprintingrecords" function that we can use. But I dont know how to use an SQL stmt with it
I put the sql stmt in double inverted commas after the function but it did not work.
Please help..
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|