July 26, 2005 at 3:30 am
I am using SQL Server 2000, have a table named ABC, which have 20 records. Please tell me how to print the table records without using reports.
Regards,
Basit
July 26, 2005 at 6:21 am
You can do this several ways:
1) in query analyzer, you can choose - under tools - options - results tab - "results to file" from the first dropdown box...save to file and then print.
2) in enterprise manager, you can right click on table and select export...follow the wizard instructions to export to a file - text, .xls etc..and then print from that file.
**ASCII stupid question, get a stupid ANSI !!!**
July 26, 2005 at 6:56 am
Thanks for the reply.
You mean to export the table in XLS or any other type of file then print, But what can I do when i want to print directly from table data without export it.
Regards
BASIT
July 26, 2005 at 7:21 am
Basit - I don't believe there's any way to directly print the query results without first copying or exporting it to a program (formatting - ie notepad, excel, word etc..) of your choice...
**ASCII stupid question, get a stupid ANSI !!!**
July 27, 2005 at 5:53 am
Thank sushila for the Guidance
Basit
July 27, 2005 at 7:59 am
Got Access? If you do, it might be the easiest, quick and dirty way to develop a report.
Michael Lee
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply