Report Printing from SQL 2000

Question

Post reply

Report Printing from SQL 2000

Khalidhussain

Right there with Babe

Points: 764
More actions
September 15, 2003 at 3:02 am

#82433

hi everyone
I am working on a project with Vb6 and SQL 2000. My current task is to develop automatic process which print report direct from SQL server or any other way every night with following scenario: Select all Policies with Status ‘Open’ and print reports in report format. Could people please tell me how I could do this? If you try something similar to the scenario or any sort of printing from SQL server, could you please tell how you done it?
Thank you

Viewing 15 posts - 1 through 15 (of 16 total)

You must be logged in to reply to this topic. Login to reply

brokenrulz SSCrazy Points: 2261 More actions · Answer 1

You can write your code in Visual basic and schedule it using NT-Scheduler.

Pay Respect to People on your way up. For you will meet the same People on your way down.

He who knows others is learned but the wise one is one who knows himself.

Frank Kalis SSC Guru Points: 111183 More actions · Answer 2

have you tried the report designer that comes along with VB6 ?

Frank

http://www.insidesql.de

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

Khalidhussain Right there with Babe Points: 764 More actions · Answer 3

Thnaks Brokenrulz

Could you tell me bit more about how I could schedule a VB6 code using NT-Schduler?

brokenrulz SSCrazy Points: 2261 More actions · Answer 4

I am not aware what sort of reporting you are planning at.

I had to work on a reporting app a few months back, What I did was I developed a standard exe project using visual basic.

Since the reporting was to be in text files life was simpler.

Once the code was developed I added it in the scheduled tasks found under control panel.

Pay Respect to People on your way up. For you will meet the same People on your way down.

He who knows others is learned but the wise one is one who knows himself.

Frank Kalis SSC Guru Points: 111183 More actions · Answer 5

quote:
Once the code was developed I added it in the scheduled tasks found under control panel.

this could basically be done within almost every application. I know our accounting trolls use an Access db with a startup macro to achieve something similar.

Frank

http://www.insidesql.de

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

brokenrulz SSCrazy Points: 2261 More actions · Answer 6

You are right Frank.

Actually Scheduler is a great out of the box tool provided with windows.

Pay Respect to People on your way up. For you will meet the same People on your way down.

He who knows others is learned but the wise one is one who knows himself.

Khalidhussain Right there with Babe Points: 764 More actions · Answer 7

Brokenrulz and Frank thanks for your kind replies. I will try these solutions.

andoi SSC Eights! Points: 864 More actions · Answer 8

You could also use crystal reports from within VB (see the crystal decisions website), but beware!! there are issues with licenses if you want to publish these reports on the internet.

I think you could also (correct me if I am wrong) use the web publishing wizard.

There are as many ways to create reports as there are lengths of string...

philcart SSC-Forever Points: 47794 More actions · Answer 9

With the forthcoming release of SQL Reporting Services, I would hold off on doing too much developement and purchasing. From my first impressions of the product, I'd say that companies like Crystal are going to lose out big time.

Who will authorise the expenditure to buy x number of licenses for Crystal when Reporting Services comes free with an SQL Server license??

Hope this helps

Phill Carter

--------------------

Colt 45 - the original point and click interface

--------------------
Colt 45 - the original point and click interface

cneuhold Hall of Fame Points: 3375 More actions · Answer 10

btw:

for nt4 (if you're still using it) there's no graphical "task scheduler", but a service and a command line statement called "at" ... schedules just fine once you're used to the syntax.

best regards,

chris.

spireite SSChasing Mays Points: 619 More actions · Answer 11

I'd be tempted to wait until Report Services comes out....although find details about it is hard at best. Other than the small snippet on MS website, I've found nothing else. Of course if anyone has more details and are not under NDA, then I'd appreciate them 🙂

when is it due anyway?

mgabriele SSC Enthusiast Points: 171 More actions · Answer 12

My understanding of the availability of the Reporting Services add-on for SQL Server 2000 is end of year 2003.

bnordberg SSCertifiable Points: 5480 More actions · Answer 13

If you have crystal reports you can use the crexport tool http://www.rainforestnet.com. Then make a bat file and schedule it with windows task scheduler. Or use MS Access and create your report there, make the autoexec launch the report, vb script to export it ... and schedule the access db to launch with windows scheduler. Or make it a web task in SQL Server and post the HTML to a web site.

philcart SSC-Forever Points: 47794 More actions · Answer 14

Public Beta for Reporting Services is due for release in 2-3 weeks.

Unfortunately, the people in the know seem to be keeping anything else close to their chests. Maybe because of the expected impact I referred to in my earlier post.

Hope this helps

Phill Carter

--------------------

Colt 45 - the original point and click interface

--------------------
Colt 45 - the original point and click interface