Help on print report or export to a file

Hi,
I'm new to SQL programming. I'm using MS SQL 2000, and I like to schedule a
job to print a report which has information pulling from tables.
For example,
select * from customer where status='yes'
I like to retrieve this list either on a printer or to a file.
Is that possible? If this needs to be coded, can you please give me some
example?
Thanks so much in advance,
SarahHi,
I wanted to add more information to my question. Or how to save the results
of stored procedure to a file to print to a printer.
Thanks,
Sarah
"Sarah" <sguo@.coopervision.com> wrote in message
news:%23bcqFfUFGHA.140@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I'm new to SQL programming. I'm using MS SQL 2000, and I like to schedule
> a job to print a report which has information pulling from tables.
> For example,
> select * from customer where status='yes'
> I like to retrieve this list either on a printer or to a file.
> Is that possible? If this needs to be coded, can you please give me some
> example?
> Thanks so much in advance,
> Sarah
>|||You can use bcp and xp_cmdshell to write the results of a query to a text fi
le.
Here is a link that explains the process.
http://www.sqlteam.com/item.asp?ItemID=4722
Ryan Powers
Clarity Consulting
http://www.claritycon.com
"Sarah" wrote:

> Hi,
> I wanted to add more information to my question. Or how to save the result
s
> of stored procedure to a file to print to a printer.
> Thanks,
> Sarah
> "Sarah" <sguo@.coopervision.com> wrote in message
> news:%23bcqFfUFGHA.140@.TK2MSFTNGP12.phx.gbl...
>
>|||> I like to retrieve this list either on a printer or to a file.
You can send to a file easily... some simple examples here:
http://www.aspfaq.com/2482
Unfortunately, SQL Server has no idea what a printer is. Might be better
suited for an external app (or maybe reporting services?).|||Thanks Aaron and Ryan, that's great help.
Sarah
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:uIv9aGVFGHA.2856@.TK2MSFTNGP12.phx.gbl...
> You can send to a file easily... some simple examples here:
> http://www.aspfaq.com/2482
> Unfortunately, SQL Server has no idea what a printer is. Might be better
> suited for an external app (or maybe reporting services?).
>

Help me print report button is not working

Hi
I am using Crystal Reports 8.5 version in VB 6.0. I am viewing reports
using CRviewer . When i click on Print report button in CR viewer controlnothing is happining. I am unable to print the report. please help meout. although with same printer settings other files(.Txt,.xls) get printed.
Thanx
RitikIs it possible for you to post the code over here ?

help me KeycodeV2.dll

Hi all.
I use Vb.net 2003 and Crystal Report 11
After i was Backage the project is Go to an Computer Other.
Setup it.
But when i Print Report is it report error

Cannot find KeycodeV2.dll or Invalid Keycode. anh detail error

CrystalDecisions.CrystalReports.Engine.InternalException: Cannot find KeycodeV2.dll, or invalid keycode.
at . F(String , EngineExceptionErrorID
)
at . B(String , Int32 )
at CrystalDecisions.CrystalReports.Engine.ReportDocument. ;()
at CrystalDecisions.CrystalReports.Engine.ReportDocument.InternalInit()
at CrystalDecisions.CrystalReports.Engine.ReportDocument..ctor()
at QL_VATTU.frmInPhongban.frmInPhongban_Load(Object sender, EventArgs e)
at System.Windows.Forms.Form.OnLoad(EventArgs e)
at System.Windows.Forms.Form.OnCreateControl()
at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
at System.Windows.Forms.Control.CreateControl()
at System.Windows.Forms.Control.WmShowWindow(Message& m)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
at System.Windows.Forms.ContainerControl.WndProc(Message& m)
at System.Windows.Forms.Form.WmShowWindow(Message& m)
at System.Windows.Forms.Form.WndProc(Message& m)
at System.Windows.Forms.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

-------------------
How i can to fix error it ?
Can you help me ?
Thank youmake sure the dll KeycodeV2.dll is properly registered
or search here for the solution
http://support.businessobjects.com/