Report Printing from SQL 2000
-
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
-
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. -
have you tried the report designer that comes along with VB6 ?
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
Thnaks Brokenrulz
Could you tell me bit more about how I could schedule a VB6 code using NT-Schduler?
-
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. -
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
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
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. -
Brokenrulz and Frank thanks for your kind replies. I will try these solutions.
-
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...
-
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
-
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.
-
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?
-
My understanding of the availability of the Reporting Services add-on for SQL Server 2000 is end of year 2003.
-
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.
-
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
Viewing 15 posts - 1 through 15 (of 16 total)
You must be logged in to reply to this topic. Login to reply