Print report from SQL 2000 - Microsoft SQL Server

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!

Jul 20 '05 #1

Subscribe Reply

2855

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!

Jul 20 '05 #2

Similar topics

1072

Print report from SQL 2000

by: Khalid Hussain | last post by:

Microsoft SQL Server

1596

Print report by using SQL 2000

by: Khalid Hussain | last post by:

hi How I could print a report on printer using SQL 2000? I am not going in detail about the report as at the moment I need to know how produce reports on printer. Thank you *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it!

Microsoft SQL Server

5799

Report Print Event and Docmd.Sendobject

by: Tom Louchbaum | last post by:

When I preview my Access 2000 Report it looks fine. When I Email the report using DoCmd.SendObject acSendReport, "Report", acFormatRTF, "To Address", , , "Subject", , False the resulting attachment to the email consistently does not display all of the lines it should in one of the GroupFooters. I am using the Print event in the report...

Microsoft Access / VBA

319

Programming to "print" a report using CUTE FTP

by: John Baker | last post by:

Hi: I need some help writing code that will "print" a report using Cute FTP. Specifically, I need to set up a "Button" which, when clicked, will: a. Create an FTP "Print" file of the report using Cute FTP. The file needs to be given a unique name based on data that will be in the report and on the query that generates the report.

Microsoft Access / VBA

660

Programming to "Print" using CUTE PDF!

by: John Baker | last post by:

HI; I feel like a fool..I put CUTE FTP in my last request for help --it should have been CUTE PDF! I have FTP on my mind because I have been working on a web based application, and somehow my brain got stuck on it..sorry! Hi: I need some help writing code that will "print" a report using Cute PDF.

Microsoft Access / VBA

7034

Access report will not print image header.

by: Jason | last post by:

For some reason, most but not all reports printing from an access application our client is using will not print any images on the reports or forms. One report will print the image and data correctly oddly enough. The image header is embedded using the Insert Image feature and not loaded into a database. I can move the image to anywhere in...

Microsoft Access / VBA

6382

Run Access report and print from ASP Page

by: jbonifacejr | last post by:

This is my first day here, so please be patient. I do not know how to search very well so the search I tried to get the answer showed me topics from the year 2000 and they really don't cover what I want. I am trying to open MSAccess from ASP..I guess I would use server.createobject("Access.Application") OK, but where do i go from there to...

Microsoft Access / VBA

2836

Print another report on a OnNoData event

by: airdata | last post by:

Hi I currently have the following code attached to a command button on a switchboard form. This is basic Access 2000. Private Sub Print_daily_reports_button_Click() On Error GoTo NoData DoCmd.OpenReport "Sales Return (TODAY)", acViewNormal DoCmd.OpenReport "Sales/Collections (TODAY)", acViewNormal

Microsoft Access / VBA

3271

How do I Print a report with code

by: G Gerard | last post by:

Hello When I want to print a report using code I normally use the following code DoCmd.OpenReport "RptName", acViewNormal This works OK when I'm only printing one copy of the report. What I'm trying to do now is open the CommonDialog using .ShowPrinter and set the number of copies to print from the CommonDialog

Microsoft Access / VBA

7911

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...

General

8200

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...

C / C++

8338

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...

Online Marketing

7954

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...

Windows Server

8215

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...

General

6610

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...

Career Advice

5390

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...

C# / C Sharp

3836

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...

Networking - Hardware / Configuration

2345

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp