Print report from SQL 2000

[Khalid Hussain]

hi
Could someone please help me in following:
I need to update Policy status base upon commencement date and then
print with new Policy status.
I written a stored procedure to update the policy.
Now I need to work out how I can print a report. We already doing the
report manually in our VB6 program but this is automatic process. So no
users involve here. It would change the status by running the stored
procedure and then print the report.
Would it be possible execute the VB6 program via stored procedure?
Would it be possible SQL 2000 produce a report?
We used active-x dll in our VB6 program, is it any way can call dll file
via stored procedure?
thank you.
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[John Bell]

Hi

In general it is not recommended to start a graphical program from a batch
process or stored procedure, quite often it can require one or more of:

interaction with the desktop,
a user logged in
a printer to be configured
user acknowledgement.

Presently formatted output of information from SQL Server is quite basic and
may not be of a suitable standard for a report. You could use things like
xp_sendmail to distribute the results of a query. Another method would be to
use sp_makewebtask to publish the results to an intranet.

It may be possible to use the dll either by using the sp_OA* stored
procedures or an active X task in a DTS job.

John

"Khalid Hussain" <kh************@pinnacle.co.uk> wrote in message
news:3f***********************@news.frii.net...

hi
Could someone please help me in following:
I need to update Policy status base upon commencement date and then
print with new Policy status.
I written a stored procedure to update the policy.
Now I need to work out how I can print a report. We already doing the
report manually in our VB6 program but this is automatic process. So no
users involve here. It would change the status by running the stored
procedure and then print the report.
Would it be possible execute the VB6 program via stored procedure?
Would it be possible SQL 2000 produce a report?
We used active-x dll in our VB6 program, is it any way can call dll file
via stored procedure?
thank you.
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!