Automatic process to print report

• Khalidhussain

  Right there with Babe

  Points: 764

  More actions

  September 9, 2003 at 6:59 am

  #82844

  hi

  Could someone please help me in following:

  I have VB 6 program which print reports, manually by pressing Print button, base upon Policy Statuses. I want to create a SQL job or any automatic process to go through Policy table in SQL2000 and find out all Policies with ‘Pending Open’ Status and then compare Commencement Date, which stored in Benefit table, and today’s date. If Commencement Date on or before today then change Policy Status to ‘Open’ and then print Policy Status report by using VB6 but this time report will print automatic after Policy Status changed to Open.

  Any solution please

• JulieW

  Say Hey Kid

  Points: 680

  More actions

  September 9, 2003 at 7:12 am

  #473197

  Hello

  The first part of this is quite easy. Simply set up an Store Procedure and use SQL Agent to start it up.

  The second part, the printing maybe a problem, as you will need to create an xp store procdure to call the dll of your printing program.

  Would it be possible to do the prinitng from VB ?

  i.e. as soon as a users logs on print the report ? only that would be easier.

  J