Exporting reports to excel - chart quality

Hello there,
I got following problem, I have some charts in my report and I need to
export reports to excel, all charts are being converted into images,
which is fine, but the quality of this conversion is not good and for
example axis labels are barely readable, while for example exporting
to pdf produces a good quality chart. So my question: is there any way
to increase quality of output image during conversion charts to
excel ?On Aug 16, 5:10 am, bachu...@.op.pl wrote:
> Hello there,
> I got following problem, I have some charts in my report and I need to
> export reports to excel, all charts are being converted into images,
> which is fine, but the quality of this conversion is not good and for
> example axis labels are barely readable, while for example exporting
> to pdf produces a good quality chart. So my question: is there any way
> to increase quality of output image during conversion charts to
> excel ?
I agree w/you in terms of the chart quality in PDF versus Excel. The
only thing that I can think of is to increase the axis label size/
font. Another alternative is to create a separate report for each
export option and set the font according to what best works for the
export and then tie them both to export buttons in a custom ASP.NET
application and swap the 2 report based on the export option selected.
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||Thanks for reply. However I cant do what you suggest, because in my
solution excel file requires further editing by user before printing,
which is ofc impossible in pdf, besides increasing font size not
necessarily improve quality. And what is very surprising same font,
same size but different type of chart generate different quality
image. Labels of axis in column chart look terrible while labels for
pie chart looks quite good.
There are options to change default dpi for exporting using
ImageRenderer, I was rather hoping there is a way to change
configuration of ExcelRenderer or eventually some easy way to create
overridden version and changing some default properties :(
Regards
Adam
On 17 Aug, 03:53, EMartinez <emartinez...@.gmail.com> wrote:
> On Aug 16, 5:10 am, bachu...@.op.pl wrote:
> > Hello there,
> > I got following problem, I have some charts in my report and I need to
> > export reports to excel, all charts are being converted into images,
> > which is fine, but the quality of this conversion is not good and for
> > example axis labels are barely readable, while for example exporting
> > to pdf produces a good quality chart. So my question: is there any way
> > to increase quality of output image during conversion charts to
> > excel ?
> I agree w/you in terms of the chart quality in PDF versus Excel. The
> only thing that I can think of is to increase the axis label size/
> font. Another alternative is to create a separate report for each
> export option and set the font according to what best works for the
> export and then tie them both to export buttons in a custom ASP.NET
> application and swap the 2 report based on the export option selected.
> Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant

Exporting data from a merge join from one data flow to another

Hi,

Does anyone know if it is possible to point data that underwent the "merge join" transformation (in one data flow) to the following data flow? I don't want to recreate all that merging, sorting and calling the same sources again in the following data flow if the data that I am using exists in the previous data flow. The merged data is simply too big to export to an excel file, so does anyone have any ideas? Thanks!

Absolutely. Use raw files. That's exactly the sort of scenario that they are provided for.

-Jamie

|||

What format can the "Raw Files" be in (excel, word, notepad, etc) or is it a .raw extension? I'm not quite sure how to go about creating a file to use this type.....

Thanks.

|||

Just use the 'Raw File Destination' component from SSIS toolbox to write the data stream to a file. Use the 'Raw File Source' component to open the file and access the data.

Frank

|||

When you use the Raw File destination though, you need to specify a file name/location. What type of file should I create/use to link that raw file destination to?

Thanks!

|||

Yes you need to specify a file and location. The type of the file is irrelevant. It doesn't even need to a filetype. Call it "C:\MyFile" if you want, it'll still work.

-Jamie

|||Thanks everyone for your help!

Export/Import tables from MSQL from/to .xml files

When I try to export a sql table to a .xml file I get the following error
when I use either sqlxmloledb or sqlxmloledb.3.0 as the destination:
sqloledb must be specified as the data provider.
However, sqloledb does not appear in the list of ole db providers. Does
anyone know how I can register sqloledb as a data provider please
I also have a problem using sql query analyzer to access a .xml file. All of
the examples in the help files show encoded xml data rather than accessing a
.xml data file on disk. Does anyone know how to link in the .xml file to sq
l
script please.
Regards,
Alan de Wetsqloledb should already be part of the OS. If you install MDAC / SqlClient
Tools / VS, SQLOLEDB should be installed.
Check C:\Program Files\Common Files\System\Oledb\sqloledb.dll for
verification. If the dll is there and is registered, then SQLOLEDB should be
there.
To use SQLOLEDB as the provider in the connection string, append
Provider=SQLOLEDB to the connection string.
thanks
Chandra
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Alan de Wet" <AlandeWet@.discussions.microsoft.com> wrote in message
news:B79E3526-4685-44FB-8CA1-94B0E4D97F90@.microsoft.com...
> When I try to export a sql table to a .xml file I get the following error
> when I use either sqlxmloledb or sqlxmloledb.3.0 as the destination:
> sqloledb must be specified as the data provider.
> However, sqloledb does not appear in the list of ole db providers. Does
> anyone know how I can register sqloledb as a data provider please
> I also have a problem using sql query analyzer to access a .xml file. All
> of
> the examples in the help files show encoded xml data rather than accessing
> a
> .xml data file on disk. Does anyone know how to link in the .xml file to
> sql
> script please.
> Regards,
> Alan de Wet|||Thanks for your reply Chandra. SQLOLEDB does not appear in the list of ole d
b
providers when I try to do an export from the Import and Export tool in MSQL
and am entering the Destination details. I am not trying to do the export
from a VB application so I do not have a connection string. SQLOLEDB is in
C:\Program Files\Common Files\System\Ole DB (being Ole DB and not Oledb). Ho
w
do I check if it is registered please?
Regards,
Alan
"Chandra Kalyanaraman [MSFT]" wrote:

> sqloledb should already be part of the OS. If you install MDAC / SqlClient
> Tools / VS, SQLOLEDB should be installed.
> Check C:\Program Files\Common Files\System\Oledb\sqloledb.dll for
> verification. If the dll is there and is registered, then SQLOLEDB should
be
> there.
> To use SQLOLEDB as the provider in the connection string, append
> Provider=SQLOLEDB to the connection string.
>
> thanks
> Chandra
> --
> This posting is provided "AS IS" with no warranties, and confers no rights
.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "Alan de Wet" <AlandeWet@.discussions.microsoft.com> wrote in message
> news:B79E3526-4685-44FB-8CA1-94B0E4D97F90@.microsoft.com...
>
>|||Is it true that SQLXMLOLEDB provider supports data export via DTS
Import/Export Wizard?
Best regards
Martin Rakhmanov
"Alan de Wet" wrote:
> Thanks for your reply Chandra. SQLOLEDB does not appear in the list of ole
db
> providers when I try to do an export from the Import and Export tool in MS
QL
> and am entering the Destination details. I am not trying to do the export
> from a VB application so I do not have a connection string. SQLOLEDB is in
> C:\Program Files\Common Files\System\Ole DB (being Ole DB and not Oledb).
How
> do I check if it is registered please?
> Regards,
> Alan
> "Chandra Kalyanaraman [MSFT]" wrote:
>|||After I installed sqlxml 2 new Data Providers (SQLXMLOLEDB and
SQLXMLOLEDB.3.0) appear in the list when I select my destination. I have
tried both of them. When I select either one I get a message saying: To
connect click properties and enter the required information. When I click on
properties I do not see sqloledb as a ole db provider but if I select any
other provider, click OK and then click next I get a message saying that
SQLOLEDB must be specified as the data provider. If I select either
sqxmloledb or sqlxmloledb.3.0 as the ole db provider under properties I am
then asked to enter Data Source, Location and Server Log On Information whic
h
does not make sense as I am trying to export to a .xml file.
So to answer your question, maybe it was supposed to but it does not appear
to support data export via DTS Import/Export Wizard.
Best Regards,
Alan de Wet
"jimmers" wrote:
> Is it true that SQLXMLOLEDB provider supports data export via DTS
> Import/Export Wizard?
> Best regards
> Martin Rakhmanov
>
> "Alan de Wet" wrote:
>

Export/Import tables from MSQL from/to .xml files

When I try to export a sql table to a .xml file I get the following error
when I use either sqlxmloledb or sqlxmloledb.3.0 as the destination:
sqloledb must be specified as the data provider.
However, sqloledb does not appear in the list of ole db providers. Does
anyone know how I can register sqloledb as a data provider please
I also have a problem using sql query analyzer to access a .xml file. All of
the examples in the help files show encoded xml data rather than accessing a
..xml data file on disk. Does anyone know how to link in the .xml file to sql
script please.
Regards,
Alan de Wet
sqloledb should already be part of the OS. If you install MDAC / SqlClient
Tools / VS, SQLOLEDB should be installed.
Check C:\Program Files\Common Files\System\Oledb\sqloledb.dll for
verification. If the dll is there and is registered, then SQLOLEDB should be
there.
To use SQLOLEDB as the provider in the connection string, append
Provider=SQLOLEDB to the connection string.
thanks
Chandra
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Alan de Wet" <AlandeWet@.discussions.microsoft.com> wrote in message
news:B79E3526-4685-44FB-8CA1-94B0E4D97F90@.microsoft.com...
> When I try to export a sql table to a .xml file I get the following error
> when I use either sqlxmloledb or sqlxmloledb.3.0 as the destination:
> sqloledb must be specified as the data provider.
> However, sqloledb does not appear in the list of ole db providers. Does
> anyone know how I can register sqloledb as a data provider please
> I also have a problem using sql query analyzer to access a .xml file. All
> of
> the examples in the help files show encoded xml data rather than accessing
> a
> .xml data file on disk. Does anyone know how to link in the .xml file to
> sql
> script please.
> Regards,
> Alan de Wet
|||Thanks for your reply Chandra. SQLOLEDB does not appear in the list of ole db
providers when I try to do an export from the Import and Export tool in MSQL
and am entering the Destination details. I am not trying to do the export
from a VB application so I do not have a connection string. SQLOLEDB is in
C:\Program Files\Common Files\System\Ole DB (being Ole DB and not Oledb). How
do I check if it is registered please?
Regards,
Alan
"Chandra Kalyanaraman [MSFT]" wrote:

> sqloledb should already be part of the OS. If you install MDAC / SqlClient
> Tools / VS, SQLOLEDB should be installed.
> Check C:\Program Files\Common Files\System\Oledb\sqloledb.dll for
> verification. If the dll is there and is registered, then SQLOLEDB should be
> there.
> To use SQLOLEDB as the provider in the connection string, append
> Provider=SQLOLEDB to the connection string.
>
> thanks
> Chandra
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "Alan de Wet" <AlandeWet@.discussions.microsoft.com> wrote in message
> news:B79E3526-4685-44FB-8CA1-94B0E4D97F90@.microsoft.com...
>
>
|||Is it true that SQLXMLOLEDB provider supports data export via DTS
Import/Export Wizard?
Best regards
Martin Rakhmanov
"Alan de Wet" wrote:
[vbcol=seagreen]
> Thanks for your reply Chandra. SQLOLEDB does not appear in the list of ole db
> providers when I try to do an export from the Import and Export tool in MSQL
> and am entering the Destination details. I am not trying to do the export
> from a VB application so I do not have a connection string. SQLOLEDB is in
> C:\Program Files\Common Files\System\Ole DB (being Ole DB and not Oledb). How
> do I check if it is registered please?
> Regards,
> Alan
> "Chandra Kalyanaraman [MSFT]" wrote:
|||After I installed sqlxml 2 new Data Providers (SQLXMLOLEDB and
SQLXMLOLEDB.3.0) appear in the list when I select my destination. I have
tried both of them. When I select either one I get a message saying: To
connect click properties and enter the required information. When I click on
properties I do not see sqloledb as a ole db provider but if I select any
other provider, click OK and then click next I get a message saying that
SQLOLEDB must be specified as the data provider. If I select either
sqxmloledb or sqlxmloledb.3.0 as the ole db provider under properties I am
then asked to enter Data Source, Location and Server Log On Information which
does not make sense as I am trying to export to a .xml file.
So to answer your question, maybe it was supposed to but it does not appear
to support data export via DTS Import/Export Wizard.
Best Regards,
Alan de Wet
"jimmers" wrote:
[vbcol=seagreen]
> Is it true that SQLXMLOLEDB provider supports data export via DTS
> Import/Export Wizard?
> Best regards
> Martin Rakhmanov
>
> "Alan de Wet" wrote:

Export Wizard disturb the order of data while exporting Data to Acess 2003 from SQL server 2005

I am using the following query to export data from sql server to ms access in export data wizard:

SELECT * FROM myView where myID = 123

Order by varcharColumnName1,varcharColumnName2 ,intColumnName3

This query will fetch about 7, 00,000 records.

SQL server 2005 shows the correct order, but Data in access table shows Incorrect data.

Please give me the solutions.

If the only diffrence in the tables is the order of the rows I would not call it incorrect data. If you need the data to be shown in a especific order you need to use Order By clause in your query

|||i am using order by in my query . Data is correct in Access but order is not correct.|||

Dear All,

Thankyou for your replies.

I have found a temperory solution. After exporting data to access file. Open table in design view,Right click on tble and select properties. A dialog box will open. Set the order by property like COL1,COL2 etc. CLose the dialog box. Open table, now data is sorted.

Thankx again for your replies. However if you find any better solution please inform me at zeeshanahmedskt@.hotmail.com or post here.

Export Wizard disturb the order of data while exporting Data to Acess 2003 from SQL server 2005

I am using the following query to export data from sql server to ms access in export data wizard:

SELECT * FROM myView where myID = 123

Order by varcharColumnName1,varcharColumnName2 ,intColumnName3

This query will fetch about 7, 00,000 records.

SQL server 2005 shows the correct order, but Data in access table shows Incorrect data.

Please give me the solutions.

If the only diffrence in the tables is the order of the rows I would not call it incorrect data. If you need the data to be shown in a especific order you need to use Order By clause in your query

|||i am using order by in my query . Data is correct in Access but order is not correct.|||

Dear All,

Thankyou for your replies.

I have found a temperory solution. After exporting data to access file. Open table in design view,Right click on tble and select properties. A dialog box will open. Set the order by property like COL1,COL2 etc. CLose the dialog box. Open table, now data is sorted.

Thankx again for your replies. However if you find any better solution please inform me at zeeshanahmedskt@.hotmail.com or post here.

Export Wizard disturb the order of data while exporting Data to Acess 2003 from SQL server 2005

I am using the following query to export data from sql server to ms access in export data wizard:

SELECT * FROM myView where myID = 123

Order by varcharColumnName1,varcharColumnName2 ,intColumnName3

This query will fetch about 7, 00,000 records.

SQL server 2005 shows the correct order, but Data in access table shows Incorrect data.

Please give me the solutions.

If the only diffrence in the tables is the order of the rows I would not call it incorrect data. If you need the data to be shown in a especific order you need to use Order By clause in your query

|||i am using order by in my query . Data is correct in Access but order is not correct.|||

Dear All,

Thankyou for your replies.

I have found a temperory solution. After exporting data to access file. Open table in design view,Right click on tble and select properties. A dialog box will open. Set the order by property like COL1,COL2 etc. CLose the dialog box. Open table, now data is sorted.

Thankx again for your replies. However if you find any better solution please inform me at zeeshanahmedskt@.hotmail.com or post here.

Export Wizard disturb order of data during exporting Data to Acess 2003 from SQL server 2005

I am using the following query to export data from sql server to ms access in export data wizard:

SELECT * FROM myView where myID = 123

Order by varcharColumnName1,varcharColumnName2 ,intColumnName3

This query will fetch about 7, 00,000 records.

SQL server 2005 shows the correct order, but Data in access table shows Incorrect order of data.

Please give me the solutions.

Speaking logically, sets and tables don’t have order. Order can be specified in a SELECT. Order can be the result of a clustered index but typically there is no guarantee of order without an explicit ORDER BY.

This is generally true of all Relational Databases.

Did you try placing an index on the Access table?

|||

True, I believe this more a call from Access 2003 settings to see how data is displayed.

Also check the code in Access about getting this data display.

|||

Dear All,

I have found a temperory solution. After exporting data to access file. Open table in design view,Right click on tble and select properties. A dialog box will open. Set the order by property like COL1,COL2 etc. CLose the dialog box. Open table, now data is sorted.

Thank you all of you for your replies.

However if you find any better solution please inform me at zeeshanahmedskt@.hotmail.com or post here.

Export Wizard disturb order of data during exporting Data to Acess 2003 from SQL server 2005

I am using the following query to export data from sql server to ms access in export data wizard:

SELECT * FROM myView where myID = 123

Order by varcharColumnName1,varcharColumnName2 ,intColumnName3

This query will fetch about 7, 00,000 records.

SQL server 2005 shows the correct order, but Data in access table shows Incorrect order of data.

Please give me the solutions.

Speaking logically, sets and tables don’t have order. Order can be specified in a SELECT. Order can be the result of a clustered index but typically there is no guarantee of order without an explicit ORDER BY.

This is generally true of all Relational Databases.

Did you try placing an index on the Access table?

|||

True, I believe this more a call from Access 2003 settings to see how data is displayed.

Also check the code in Access about getting this data display.

|||

Dear All,

I have found a temperory solution. After exporting data to access file. Open table in design view,Right click on tble and select properties. A dialog box will open. Set the order by property like COL1,COL2 etc. CLose the dialog box. Open table, now data is sorted.

Thank you all of you for your replies.

However if you find any better solution please inform me at zeeshanahmedskt@.hotmail.com or post here.

Export Wizard disturb order of data during exporting Data to Acess 2003 from SQL server 2005

I am using the following query to export data from sql server to ms access in export data wizard:

SELECT * FROM myView where myID = 123

Order by varcharColumnName1,varcharColumnName2 ,intColumnName3

This query will fetch about 7, 00,000 records.

SQL server 2005 shows the correct order, but Data in access table shows Incorrect order of data.

Please give me the solutions.

Speaking logically, sets and tables don’t have order. Order can be specified in a SELECT. Order can be the result of a clustered index but typically there is no guarantee of order without an explicit ORDER BY.

This is generally true of all Relational Databases.

Did you try placing an index on the Access table?

|||

True, I believe this more a call from Access 2003 settings to see how data is displayed.

Also check the code in Access about getting this data display.

|||

Dear All,

I have found a temperory solution. After exporting data to access file. Open table in design view,Right click on tble and select properties. A dialog box will open. Set the order by property like COL1,COL2 etc. CLose the dialog box. Open table, now data is sorted.

Thank you all of you for your replies.

However if you find any better solution please inform me at zeeshanahmedskt@.hotmail.com or post here.

Export with DTS to a dbf file

Hello,

I'm trying to export data from sql server2000 to a dbf file
When creating the dts package, i've got the following error (when creating the table in the dbf file):
"HResult of 2147467259 returned. Unexpected error occurred..."

The table i try to export is like:
Table1 (field1 int, field2 int...)

Does anyone have any idea?

Thanks in advance

IsabelleDo not forget that length of name field for DBF is only 10 ...
Check name of columns in your table.

Export to/from XML

I have Database with the following structure: Regions -> Countries -> Customers -> Fabs -> Products. All relationships are one to many.
I need to build query that returns all data of any Region as XML.
What is the best way to do opposite action (Export from XML to DB) ?I just played with this over the weekend for the first time. Please take a look at "XML and Internet Support Overview" in SQL Server Books Online.

Once you configure this properly with IIS you can return auto generated XML from querying SQL Server.

What little I did, it was pretty cool.

Export to PDF Error: Index was out of range

When I view the report in HTML it works fine. It gives the following error when exported to PDF:

Index was out of range. Must be non negative and less than the size of the collection. Parameter name: Index.

Please help!

Hello,

Could you please provide some more info:

RS version

RDL file

Thanks!

Export to PDF error

Some users get the following error when exporting to PDF:
There was an error opening this document. The file does not exist.
They can save the document locally though and open it. We're all using the
same version of Acrobat Reader (6.0.1).
Has anyone experienced this before?
Thanks,
Jason MacKenzieJason, I have aboslutely experienced this same issue and it is a major
problem. Can someone from Microsoft please comment on this issue. We have
various version of .pdf in the office. 5.0 works fine it seems for Reporting
Services rendering to .pdf but we have a requirement for employees to see
their ADP paystubs in 6.0. Adober .pdf's load fine in the browser when
pulled up directly from other sources which leads me to believe this is a
driver issue on the reporting services side?
"Jason MacKenzie" wrote:
> Some users get the following error when exporting to PDF:
> There was an error opening this document. The file does not exist.
> They can save the document locally though and open it. We're all using the
> same version of Acrobat Reader (6.0.1).
> Has anyone experienced this before?
> Thanks,
> Jason MacKenzie
>
>|||Here's an additional caveat. This seems to be happening primarily on systems
with Adobe Acrobt 6.0 Professional installed?
"Scott" wrote:
> Jason, I have aboslutely experienced this same issue and it is a major
> problem. Can someone from Microsoft please comment on this issue. We have
> various version of .pdf in the office. 5.0 works fine it seems for Reporting
> Services rendering to .pdf but we have a requirement for employees to see
> their ADP paystubs in 6.0. Adober .pdf's load fine in the browser when
> pulled up directly from other sources which leads me to believe this is a
> driver issue on the reporting services side?
> "Jason MacKenzie" wrote:
> > Some users get the following error when exporting to PDF:
> >
> > There was an error opening this document. The file does not exist.
> >
> > They can save the document locally though and open it. We're all using the
> > same version of Acrobat Reader (6.0.1).
> >
> > Has anyone experienced this before?
> >
> > Thanks,
> >
> > Jason MacKenzie
> >
> >
> >

Export to Excel problem in RS (updated)

Hello there,

Does anyone have a solution to the following export to excel problem i am experiencing in RS 2005 Standard Ed.

When exporting a matrix report in VS2005 (or in Report Manager) I get the following export error displayed in VS :

An error occurred during local report processing.

An error occurred during rendering of the report

Operation is not valid due to the current state of the object.

This is only a problem where exporting data into multiple worksheets - such as dept by dept on different wsheets.

Export to excel with 1 dept works fine.

I have managed to pinpoint the situation where this happens :

Matrix report with page break for the grouping.

I think there might be a fault with the export function.

Anyone like to confirm on this ?

|||

Did you ever find out if this was a bug?

I also have a problem with page breaks in matrix groupings where by I get blank pages when Print Previewing in Excel. However I am using RS 2000 with SP2.

Thanks

Scott

Export to Excel problem in RS (updated - some progress !!)

Hello there,

Does anyone have a solution to the following export to excel problem i am experiencing in RS 2005 Standard Ed.

When exporting a matrix report in VS2005 (or in Report Manager) I get the following export error displayed in VS :

An error occurred during local report processing.

An error occurred during rendering of the report

Operation is not valid due to the current state of the object.

This is only a problem where exporting data into multiple worksheets - such as dept by dept on different wsheets.

Export to excel with 1 dept works fine.

I have managed to pinpoint the situation where this happens :

Matrix report with page break for the grouping.

I think there might be a fault with the export function.

Anyone like to confirm on this ?

|||

Did you ever find out if this was a bug?

I also have a problem with page breaks in matrix groupings where by I get blank pages when Print Previewing in Excel. However I am using RS 2000 with SP2.

Thanks

Scott

Export to Excel problem in RS (updated - some progress !!)

Hello there,

Does anyone have a solution to the following export to excel problem i am experiencing in RS 2005 Standard Ed.

When exporting a matrix report in VS2005 (or in Report Manager) I get the following export error displayed in VS :

An error occurred during local report processing.

An error occurred during rendering of the report

Operation is not valid due to the current state of the object.

This is only a problem where exporting data into multiple worksheets - such as dept by dept on different wsheets.

Export to excel with 1 dept works fine.

I have managed to pinpoint the situation where this happens :

Matrix report with page break for the grouping.

I think there might be a fault with the export function.

Anyone like to confirm on this ?

|||

Did you ever find out if this was a bug?

I also have a problem with page breaks in matrix groupings where by I get blank pages when Print Previewing in Excel. However I am using RS 2000 with SP2.

Thanks

Scott

Export to excel problem

Hi,

WHen i export a report(which i dynamically create) to excel it spews the following :

MIME-Version: 1.0

X-Document-Type: Workbook

Content-Type: multipart/related;boundary="-=_NextPart_01C35DB7.4B204430"

This is a multi-part message in MIME format.

=_NextPart_01C35DB7.4B204430

Content-Type: text/html;

charset="utf-8"

Content-Transfer-Encoding: base64

Content-Location: file:///c:/Report.htm

77u/PGh0bWwgeG1sbnM6dj0idXJuOnNjaGVtYXMtbWljcm9zb2Z0LWNvbTp2bWwiIHhtbG5zOm89InVybjpzY2hlbWFzLW1pY3Jvc29mdC1jb206b2ZmaWNlOm9mZmljZSIgeG1sbnM6eD0idXJuOnNjaGVtYXMtbWljcm9zb2Z0LWNvbTpvZmZpY2U6ZXhjZWwiIHhtbG5zPSJodHRwOi8vIHd3dy53My5vcmcvVFIvUkVDLWh0bWw0MCI+CjxoZWFkPgo8bWV0YSBuYW1lPSJFeGNlbCBXb3JrYm9vayBGcmFtZXNldCI+CjxtZXRhIGh0dHAtZXF1aXY9Q29udGVudC1UeXBlIGNvbnRlbnQ9InRleHQvaHRtbDsgY2hhcnNldD11dGYtOCI+Cjx4bWw+PG86RG9jdW1lbnRQcm9wZXJ0aWVzPjxvOkNyZWF0ZWQ+RnJpZGF5LCAxMiBNYXkgMjAwNiAxNTowOToxNDwvbzpDcmVhdGVkPgo8bzpMYXN0U2F2ZWQ+RnJpZGF5LCAxMiBNYXkgMjAwNiAxNTowOToxNDwvbzpMYXN0U2F2ZWQ+CjwvbzpEb2N1bWVudFByb3BlcnRpZXM+PC94bWw+PGxpbmsgaWQ9InNoTGluayIgaHJlZj0iU2hlZXQxLmh0bSI+PHhtbD48eDpFeGNlbFdvcmtib29rPjx4OkV4Y2VsV29ya3NoZWV0cz48eDpFeGNlbFdvcmtzaGVldD48eDpOYW1lPlJlcG9ydDwveDpOYW1lPjx4OldvcmtzaGVldFNvdXJjZSBIUmVmPSJTaGVldDEuaHRtIi8+PHg6V29ya3NoZWV0T3B0aW9ucz48eDpOb1N1bW1hcnlSb3dzQmVsb3dEZXRhaWwvPjx4Ok5vU3VtbWFyeUNvbHVtbnNSaWdodERldGFpbC8+PHg6RG9Ob3REaXNwbGF5R3JpZGxpbmVzLz48eDpQcmludD48eDpWYWxpZFByaW50ZXJJbmZvLz48eDpQYXBlclNp

=_NextPart_01C35DB7.4B204430

Content-Type: text/html

Content-Transfer-Encoding: base64

Content-Location: file:///c:/Sheet1.htm

Any ideas on how to resolve this?

I am experiencing the same exact problem on two machines. Did you ever find an answer?

|||

Can anyone help us? I am still looking for a solution.

Thanks. -Nittany92

|||

What version and service pack level of RS are you using? Can you please explain exactly what steps you are taking to export the report?

Thanks,
Chris

|||

I did finally find out that this issue was fixed in SQL Reporting Services SP1. Our reporting server was using SP1 but I was only given the original release to install on my PC. I have since applied SQL Reporting Services SP2 to my PC and I am now able to export to an Excel 2000 file successfully.

See the following info...

http://download.microsoft.com/download/5/1/3/513534ae-a0e7-44e6-9a04-ba3c549a5f5f/sp2Readme_EN.htm

4.2.8 Excel Rendering Extension

New in SP1. Significant improvements have been made to the Excel rendering extension. The output format produced by the rendering extension has changed. Improvements include the following: Rendered reports can now be opened in Excel 97 and later. Previously, the file format was MIME Encapsulation of Aggregate HTML (MHTML), which could only be opened in Excel 2002 and later. The format for rendered reports is now Binary Interchange File Format (BIFF), which can be opened in Excel 97 and later.

Export to excel problem

Hi,

WHen i export a report(which i dynamically create) to excel it spews the following :

MIME-Version: 1.0

X-Document-Type: Workbook

Content-Type: multipart/related;boundary="-=_NextPart_01C35DB7.4B204430"

This is a multi-part message in MIME format.

=_NextPart_01C35DB7.4B204430

Content-Type: text/html;

charset="utf-8"

Content-Transfer-Encoding: base64

Content-Location: file:///c:/Report.htm

77u/PGh0bWwgeG1sbnM6dj0idXJuOnNjaGVtYXMtbWljcm9zb2Z0LWNvbTp2bWwiIHhtbG5zOm89InVybjpzY2hlbWFzLW1pY3Jvc29mdC1jb206b2ZmaWNlOm9mZmljZSIgeG1sbnM6eD0idXJuOnNjaGVtYXMtbWljcm9zb2Z0LWNvbTpvZmZpY2U6ZXhjZWwiIHhtbG5zPSJodHRwOi8vIHd3dy53My5vcmcvVFIvUkVDLWh0bWw0MCI+CjxoZWFkPgo8bWV0YSBuYW1lPSJFeGNlbCBXb3JrYm9vayBGcmFtZXNldCI+CjxtZXRhIGh0dHAtZXF1aXY9Q29udGVudC1UeXBlIGNvbnRlbnQ9InRleHQvaHRtbDsgY2hhcnNldD11dGYtOCI+Cjx4bWw+PG86RG9jdW1lbnRQcm9wZXJ0aWVzPjxvOkNyZWF0ZWQ+RnJpZGF5LCAxMiBNYXkgMjAwNiAxNTowOToxNDwvbzpDcmVhdGVkPgo8bzpMYXN0U2F2ZWQ+RnJpZGF5LCAxMiBNYXkgMjAwNiAxNTowOToxNDwvbzpMYXN0U2F2ZWQ+CjwvbzpEb2N1bWVudFByb3BlcnRpZXM+PC94bWw+PGxpbmsgaWQ9InNoTGluayIgaHJlZj0iU2hlZXQxLmh0bSI+PHhtbD48eDpFeGNlbFdvcmtib29rPjx4OkV4Y2VsV29ya3NoZWV0cz48eDpFeGNlbFdvcmtzaGVldD48eDpOYW1lPlJlcG9ydDwveDpOYW1lPjx4OldvcmtzaGVldFNvdXJjZSBIUmVmPSJTaGVldDEuaHRtIi8+PHg6V29ya3NoZWV0T3B0aW9ucz48eDpOb1N1bW1hcnlSb3dzQmVsb3dEZXRhaWwvPjx4Ok5vU3VtbWFyeUNvbHVtbnNSaWdodERldGFpbC8+PHg6RG9Ob3REaXNwbGF5R3JpZGxpbmVzLz48eDpQcmludD48eDpWYWxpZFByaW50ZXJJbmZvLz48eDpQYXBlclNp

=_NextPart_01C35DB7.4B204430

Content-Type: text/html

Content-Transfer-Encoding: base64

Content-Location: file:///c:/Sheet1.htm

Any ideas on how to resolve this?

I am experiencing the same exact problem on two machines. Did you ever find an answer?

|||

Can anyone help us? I am still looking for a solution.

Thanks. -Nittany92

|||

What version and service pack level of RS are you using? Can you please explain exactly what steps you are taking to export the report?

Thanks,
Chris

|||

I did finally find out that this issue was fixed in SQL Reporting Services SP1. Our reporting server was using SP1 but I was only given the original release to install on my PC. I have since applied SQL Reporting Services SP2 to my PC and I am now able to export to an Excel 2000 file successfully.

See the following info...

http://download.microsoft.com/download/5/1/3/513534ae-a0e7-44e6-9a04-ba3c549a5f5f/sp2Readme_EN.htm

4.2.8 Excel Rendering Extension

New in SP1. Significant improvements have been made to the Excel rendering extension. The output format produced by the rendering extension has changed. Improvements include the following:

Rendered reports can now be opened in Excel 97 and later. Previously, the file format was MIME Encapsulation of Aggregate HTML (MHTML), which could only be opened in Excel 2002 and later. The format for rendered reports is now Binary Interchange File Format (BIFF), which can be opened in Excel 97 and later.

Export to excel problem

Hi,

WHen i export a report(which i dynamically create) to excel it spews the following :

MIME-Version: 1.0

X-Document-Type: Workbook

Content-Type: multipart/related;boundary="-=_NextPart_01C35DB7.4B204430"

This is a multi-part message in MIME format.

=_NextPart_01C35DB7.4B204430

Content-Type: text/html;

charset="utf-8"

Content-Transfer-Encoding: base64

Content-Location: file:///c:/Report.htm

77u/PGh0bWwgeG1sbnM6dj0idXJuOnNjaGVtYXMtbWljcm9zb2Z0LWNvbTp2bWwiIHhtbG5zOm89InVybjpzY2hlbWFzLW1pY3Jvc29mdC1jb206b2ZmaWNlOm9mZmljZSIgeG1sbnM6eD0idXJuOnNjaGVtYXMtbWljcm9zb2Z0LWNvbTpvZmZpY2U6ZXhjZWwiIHhtbG5zPSJodHRwOi8vIHd3dy53My5vcmcvVFIvUkVDLWh0bWw0MCI+CjxoZWFkPgo8bWV0YSBuYW1lPSJFeGNlbCBXb3JrYm9vayBGcmFtZXNldCI+CjxtZXRhIGh0dHAtZXF1aXY9Q29udGVudC1UeXBlIGNvbnRlbnQ9InRleHQvaHRtbDsgY2hhcnNldD11dGYtOCI+Cjx4bWw+PG86RG9jdW1lbnRQcm9wZXJ0aWVzPjxvOkNyZWF0ZWQ+RnJpZGF5LCAxMiBNYXkgMjAwNiAxNTowOToxNDwvbzpDcmVhdGVkPgo8bzpMYXN0U2F2ZWQ+RnJpZGF5LCAxMiBNYXkgMjAwNiAxNTowOToxNDwvbzpMYXN0U2F2ZWQ+CjwvbzpEb2N1bWVudFByb3BlcnRpZXM+PC94bWw+PGxpbmsgaWQ9InNoTGluayIgaHJlZj0iU2hlZXQxLmh0bSI+PHhtbD48eDpFeGNlbFdvcmtib29rPjx4OkV4Y2VsV29ya3NoZWV0cz48eDpFeGNlbFdvcmtzaGVldD48eDpOYW1lPlJlcG9ydDwveDpOYW1lPjx4OldvcmtzaGVldFNvdXJjZSBIUmVmPSJTaGVldDEuaHRtIi8+PHg6V29ya3NoZWV0T3B0aW9ucz48eDpOb1N1bW1hcnlSb3dzQmVsb3dEZXRhaWwvPjx4Ok5vU3VtbWFyeUNvbHVtbnNSaWdodERldGFpbC8+PHg6RG9Ob3REaXNwbGF5R3JpZGxpbmVzLz48eDpQcmludD48eDpWYWxpZFByaW50ZXJJbmZvLz48eDpQYXBlclNp

=_NextPart_01C35DB7.4B204430

Content-Type: text/html

Content-Transfer-Encoding: base64

Content-Location: file:///c:/Sheet1.htm

Any ideas on how to resolve this?

I am experiencing the same exact problem on two machines. Did you ever find an answer?

|||

Can anyone help us? I am still looking for a solution.

Thanks. -Nittany92

|||

What version and service pack level of RS are you using? Can you please explain exactly what steps you are taking to export the report?

Thanks,
Chris

|||

I did finally find out that this issue was fixed in SQL Reporting Services SP1. Our reporting server was using SP1 but I was only given the original release to install on my PC. I have since applied SQL Reporting Services SP2 to my PC and I am now able to export to an Excel 2000 file successfully.

See the following info...

http://download.microsoft.com/download/5/1/3/513534ae-a0e7-44e6-9a04-ba3c549a5f5f/sp2Readme_EN.htm

4.2.8 Excel Rendering Extension

New in SP1. Significant improvements have been made to the Excel rendering extension. The output format produced by the rendering extension has changed. Improvements include the following: Rendered reports can now be opened in Excel 97 and later. Previously, the file format was MIME Encapsulation of Aggregate HTML (MHTML), which could only be opened in Excel 2002 and later. The format for rendered reports is now Binary Interchange File Format (BIFF), which can be opened in Excel 97 and later.