Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sava13
Starting Member
2 Posts |
 Posted - 2010-08-02 : 19:02:31
|
| I have a Crystal Report that I would like to display "Original" when printed for the first time and "Reprinted" afterwards. This report is document specific (Sales Order). This is pertaining to SAP Business One. Is it possible to accomplish this? I am new at SQL programming. Thank you. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-08-03 : 01:57:18
|
| what you could do is keep an auditing table to track report printing. For subsequent prints, you'll have a record in table in which case you show reprinted. In first case, it wont have a record in table in which case you show original. Every time you print, you insert a record in table with date you printed and copy number.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
sava13
Starting Member
2 Posts |
Posted - 2010-08-03 : 07:42:22
|
| How do I update the table? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-08-08 : 02:13:08
|
| you can add it as a step of job which calls the T-SQL script to do the update------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
slimt_slimt
Aged Yak Warrior
746 Posts |
Posted - 2010-08-08 : 09:03:01
|
| visakh16: how do you audit reportings for print(ing)? is this "a workaround" only for Crystal reports (which i never used and have no idea how it looks or feels :) ) or can also be done in SSRS (2000+ version)? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-08-10 : 13:30:41
|
| nope i was just suggesting a generic soln. its not specific to crystal reports------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Capture report printing