Print a report

Question

Post reply

Print a report

aldero

Grasshopper

Points: 18
More actions
October 9, 2003 at 3:57 am

#82434

Hi all,
Is there anybody out there who knows how to create a report in SQL Server 2000??
Thanks a lot in advance

Viewing 8 posts - 1 through 7 (of 7 total)

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

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

quote:
Is there anybody out there who knows how to create a report in SQL Server 2000??

Can you specify what you mean by 'report'?

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]

aldero Grasshopper Points: 18 More actions · Answer 2

Of course, I mean that I want to print data on a printer with a barcode etc.

Thanks for the reply

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

quote:
Of course, I mean that I want to print data on a printer with a barcode etc.

isn't this more the job of some front end reporting engine?

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]

aldero Grasshopper Points: 18 More actions · Answer 4

You are probably right, but I need it to print from within SQL Server.

Are there any additional tools we can use

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

quote:
You are probably right, but I need it to print from within SQL Server.
Are there any additional tools we can use

hm...no experience with barcode, but what about saving the query to a file using bcp and then printing this file.

I'm sure someone else out there has a working example for this.

HTH

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]

tymberwyld SSCertifiable Points: 7810 More actions · Answer 6

You can do two things, but first, buy a Barcode Font...

1.) Use an Access 2000 Project to hook into the SQL Server DB and then utilize Access for Reporting.

2.) Purchase Crystal Report (9.0) and use their Barcode capabilities (that may be an additional fee, not sure).

Either way, you MIGHT be able to use the "xp_CmdShell" in SQL to shell a command line to run the Reports...but I doubt it.

What you'll probably have to do is write a small VB program that can run reports through a Command Line. Then, have SQL use the "xp_CmdShell" to call the VB program, which in turn would run the Reports (either in Access or Crystal).

In my opinion, Crystal is your best bet right now.

Edited by - tymberwyld on 10/10/2003 06:50:17 AM

Jonathan SSC-Insane Points: 20427 More actions · Answer 7

quote:
You are probably right, but I need it to print from within SQL Server.
Are there any additional tools we can use

You could sign up to beta test SQL Server 2000 Reporting Services...

http://www.microsoft.com/sql/evaluation/betanominations.asp

--Jonathan