Exporting a table to Excel using bcl utility (Newbie)

I am trying to learn SQL 2005 Express and I am having a problem exporting (if that is the correct word) a table to Excel.

I have created a view in the Northwind database called MyCustomerView and want to practice working with the table.

From the command prompt:

bcp Northwind.dbo.MyCustomerView out MCV.xls -S -T

I then get the error message:

c:\> bcp Northwind.dbo.MyCustomerView out MCV.xls -S -T

SQLState = 08001, NativeError = 10061

Error = [Microsoft][SQL Native Client]TCP Provider: No connection could be made because the target machine actively refused it.

SQLState = HYT00, NativeError = 0

Error = [Microsoft][SQL Native Client]Login timeout expired

SQLState = 08001, NativeError = 10061

Error = [Microsoft][SQL Native Client]An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.

This is on a single machine running Widows XP Home.

Help Please

Did you enable remote connections on the SQL Server express machine ? See the Screencast on my site for more information and a walkthrough. Do you have SQL Browser started ? SQL Server will pick a port to bind it to the service. If SQL Browser is not started you will have to specify it within the server declaration. If started it will directly redirect you to the appropiate instance.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

Thanks Jens

Everything you suggested I have tried, but am still getting the errors.

Export to Word or RTF in SQL Reporting services

does any know if SQL server reporting services will be offering a RTF format
export or Word export' I need this function - it force me to use crystal
reports (ARRGH!!)
Or does anyone know of a provider that made one?I know SoftArtisans (www.softartisans.com) is working on something in this
area. The feature did not make it on the list for SQL 2005.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Chicago Dave" <Chicago Dave@.discussions.microsoft.com> wrote in message
news:767BAA7C-EE40-4858-BF0E-2CA3F22C032C@.microsoft.com...
> does any know if SQL server reporting services will be offering a RTF
> format
> export or Word export' I need this function - it force me to use crystal
> reports (ARRGH!!)
> Or does anyone know of a provider that made one?
>

Export to word or rtf format

I would like to know if it is possible to export a report created with reporting
service
in Microsoft Word or RTF format.
Thank's in advance
Giorgio ParmeggianiNot out of the box. I don't know if there are 3rd party renderers or not.
You can do Excel and PDF which might fit your needs. And, of course, HTML.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Giorgio Parmeggiani" <gipasoft@.newsgroups.nospam> wrote in message
news:ddf4e4a662b78c7c7182df905e2@.msnews.microsoft.com...
> I would like to know if it is possible to export a report created with
> reporting service in Microsoft Word or RTF format.
> Thank's in advance
> Giorgio Parmeggiani
>|||Hi Giorgio,
Welcome to use MSDN Managed Newsgroup!
We do not support render Word (RTF) format in the SQL Server Reporting
Services 2000/2005. You may try third party solution in the link below
Design Reports Using Microsoft Word
http://officewriter.softartisans.com/officewriter-296.aspx
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.

Export to Word

Chris McGuigan wrote:
But I guess you want to export directly to Word, this is not possible with
RS out of the box.
So is it possible to export to Word at all? I would like to know if this is
possible by customizing the RSReportServer.config file, installing a RS
add-on, leveraing somthing in the .NET framwork, etc. Any adivice is most
appreciated.
MattHello Matt,
Glad you asked! :)
SoftArtisans OfficeWriter is an add-on to Reporting Services that lets you
design and deliver reports in Word format.
The product consists of a custom designer toolbar for Word and Excel, and
a custom Word and Excel rendering extension.
http://officewriter.softartisans.com/officewriter-250.aspx
Let me know if you have any questions.
Best,
Chris
> Chris McGuigan wrote:
> But I guess you want to export directly to Word, this is not possible
> with
> RS out of the box.
> So is it possible to export to Word at all? I would like to know if
> this is possible by customizing the RSReportServer.config file,
> installing a RS add-on, leveraing somthing in the .NET framwork, etc.
> Any adivice is most appreciated.
> Matt
>|||Looks intersting. I was looking for a simple MS native option. If anyone
knows about something like this please let me know.
"Chris Baldwin" wrote:
> Hello Matt,
> Glad you asked! :)
> SoftArtisans OfficeWriter is an add-on to Reporting Services that lets you
> design and deliver reports in Word format.
> The product consists of a custom designer toolbar for Word and Excel, and
> a custom Word and Excel rendering extension.
> http://officewriter.softartisans.com/officewriter-250.aspx
> Let me know if you have any questions.
> Best,
> Chris
> > Chris McGuigan wrote:
> > But I guess you want to export directly to Word, this is not possible
> > with
> > RS out of the box.
> > So is it possible to export to Word at all? I would like to know if
> > this is possible by customizing the RSReportServer.config file,
> > installing a RS add-on, leveraing somthing in the .NET framwork, etc.
> > Any adivice is most appreciated.
> >
> > Matt
> >
>
>

Export To Word

Hi,
Is there any way to implement export to ms word ? it seams that
reporting just support export to Pdf,Excel and Image.
Any suggestion?
Is there any plan on Microsoft for supporting Export to word ?
Thanks,
Saman ZakerzadehOn Aug 28, 1:35 am, Saman <zakerz...@.gmail.com> wrote:
> Hi,
> Is there any way to implement export to ms word ? it seams that
> reporting just support export to Pdf,Excel and Image.
> Any suggestion?
> Is there any plan on Microsoft for supporting Export to word ?
> Thanks,
> Saman Zakerzadeh
In SQL 2008, slated to be released in the Spring, they've added this
functionality.|||beener wrote:
> On Aug 28, 1:35 am, Saman <zakerz...@.gmail.com> wrote:
>> Hi,
>> Is there any way to implement export to ms word ? it seams that
>> reporting just support export to Pdf,Excel and Image.
>> Any suggestion?
>> Is there any plan on Microsoft for supporting Export to word ?
>> Thanks,
>> Saman Zakerzadeh
> In SQL 2008, slated to be released in the Spring, they've added this
> functionality.
>
What about local reports (rdlc) ?
I think this functionality(export) is more related to Report Viewer than
sql server.
could you correct me?|||We have developped a conversion to merge xml data into word.
First, we export the report to XML data.
Then we use those data into a WordML document wish comtains the reporting
XML tags.
It works fine.
"Saman" wrote:
> beener wrote:
> > On Aug 28, 1:35 am, Saman <zakerz...@.gmail.com> wrote:
> >> Hi,
> >> Is there any way to implement export to ms word ? it seams that
> >> reporting just support export to Pdf,Excel and Image.
> >> Any suggestion?
> >> Is there any plan on Microsoft for supporting Export to word ?
> >>
> >> Thanks,
> >> Saman Zakerzadeh
> >
> > In SQL 2008, slated to be released in the Spring, they've added this
> > functionality.
> >
> What about local reports (rdlc) ?
> I think this functionality(export) is more related to Report Viewer than
> sql server.
> could you correct me?
>

Export To MS Word

I desperatley need to export reports to MS Word - can anyone tell me a way around this please

thanks

There is not native export to Word for Reporting Services. I am not entirely familiar with the following product, but they do allow Word and Reporting Services to work together.

http://officewriter.softartisans.com/officewriter-189.aspx

|||

Now there is. Aspose.Words for Reporting Services, for more info see http://www.aspose.com/Products/Aspose.WordsRS/.

Export To MS Word

I desperatley need to export reports to MS Word - can anyone tell me a way around this please

thanks

There is not native export to Word for Reporting Services. I am not entirely familiar with the following product, but they do allow Word and Reporting Services to work together.

http://officewriter.softartisans.com/officewriter-189.aspx

|||

Now there is. Aspose.Words for Reporting Services, for more info see http://www.aspose.com/Products/Aspose.WordsRS/.

Export To MS Word

I desperatley need to export reports to MS Word - can anyone tell me a way around this please

thanks

There is not native export to Word for Reporting Services. I am not entirely familiar with the following product, but they do allow Word and Reporting Services to work together.

http://officewriter.softartisans.com/officewriter-189.aspx

|||

Now there is. Aspose.Words for Reporting Services, for more info see http://www.aspose.com/Products/Aspose.WordsRS/.

Export To MS Word

Hi folks,
Is there a way to export the report output to MS Word from reporting
services directly ?According to the docs, the only export formats are:
TIFF
Acrobat (PDF) File
Web archive
Excel
XML
CSV
HTML with Office Web Components
--
Adrian M.
MCP
"Rajan" <Rajan@.discussions.microsoft.com> wrote in message
news:B9827719-B3D4-4B82-AC97-CBD1886C8184@.microsoft.com...
> Hi folks,
> Is there a way to export the report output to MS Word from reporting
> services directly ?|||On Mon, 31 Jan 2005 02:57:02 -0800, "Rajan"
<Rajan@.discussions.microsoft.com> wrote:
>Hi folks,
> Is there a way to export the report output to MS Word from reporting
>services directly ?
No that I know of. There is a product by SoftArtisans, called
OfficeWriter (WordWriter/ExcelWriter), that provides advanced
exporters to Word and Excel, but it is not a straightforward solution:
you CANNOT use it with your existing reports, and must use their
designers to take advantage of these exporters. The opposite is a
problem as well: if you designed a report in their designer, you won't
be able to use any standard exporters with it, unless you maintain 2
separate designs in the same RDL file. Creates a maintenace hell, if
you have a lot of reports. :(~|||thanks for the update.
"Usenet User" wrote:
> On Mon, 31 Jan 2005 02:57:02 -0800, "Rajan"
> <Rajan@.discussions.microsoft.com> wrote:
> >Hi folks,
> >
> > Is there a way to export the report output to MS Word from reporting
> >services directly ?
> No that I know of. There is a product by SoftArtisans, called
> OfficeWriter (WordWriter/ExcelWriter), that provides advanced
> exporters to Word and Excel, but it is not a straightforward solution:
> you CANNOT use it with your existing reports, and must use their
> designers to take advantage of these exporters. The opposite is a
> problem as well: if you designed a report in their designer, you won't
> be able to use any standard exporters with it, unless you maintain 2
> separate designs in the same RDL file. Creates a maintenace hell, if
> you have a lot of reports. :(~
>

Export to Doc

Hi,
I'm trying to export my report to MS Word, but in exported file the left and right indentation is missing.
Is there any way how to fix this?
thx.You may want to try exporting to RTF, then open that document with word.

export report to Word

Hi,
is there a way to export the report to MS Word?

Thanks,
Igor

Igor

Current the only way is Third party product such as SoftArtisans OfficeWriter, I personally hope that MS will give us this option in some future release.

Ham

|||

Aspose.Words for Reporting Services is a rendering extension for Microsoft SQL Server 2005 Reporting Services that allows to export reports to DOC, RTF and WordprocessingML.

For more info see http://www.aspose.com/Products/Aspose.WordsRS/ and http://www.aspose.com/COMMUNITY/blogs/aspose.words/archive/2007/04/06/72362.aspx

export report to Word

Hi,
is there a way to export the report to MS Word?

Thanks,
Igor

Igor

Current the only way is Third party product such as SoftArtisans OfficeWriter, I personally hope that MS will give us this option in some future release.

Ham

|||

Aspose.Words for Reporting Services is a rendering extension for Microsoft SQL Server 2005 Reporting Services that allows to export reports to DOC, RTF and WordprocessingML.

For more info see http://www.aspose.com/Products/Aspose.WordsRS/ and http://www.aspose.com/COMMUNITY/blogs/aspose.words/archive/2007/04/06/72362.aspx

Export Report Result into Word Format using ReportViewer in asp.net2.0

Hi,

I am very new to ReportViewer in asp.net2.0 web server control which is a part of data. I dont know how to export my report result into word format. I am not using crystal report or SQL server 2005 reorting services. Please give me a solution to export my report result into WordFormat?

Divya

Reportviewer local edition only allows you to export to Excel of PDF. Word format is not yet supported.

|||

Hi,

Thank you very much for your response.

Can I done it through programatically?

I have one more doubt. I bind my report with the ReportViewer control. But it shows the vertical scrollbar. Is any way to hide the scrollbar and set the no of reports displayed per page? Please reply me soon.

Thanking You

Divya

|||

I don't think you can export it to Word (check on that). For the scrollbars, set the Asyncrendering property to false and SizeToReportContent property to true. This will size the reportviewer according to the content rendered.