Exported Queries To Excel An Spreadsheet File

Jul 23, 2005

Is it possible to export the results of a query using SQL Server query
manager to an excel spreadsheet file.


Thanks in advance.

View 2 Replies


ADVERTISEMENT

Date Field In Exported Excel File

Dec 9, 2006

I export a table to excel file by using DTS. It seems the date field show as ###### when I open the excel file. If I expend the column I see the date. Is there any way I export in away that this date field will not show up as #####.

View 2 Replies View Related

Cant Sort Data In Exported Excel File From Sql Ser

Feb 7, 2008

Hello,
I am new to this sql server reporting server technology. I have a requirement like the table header should repeat in all pages of the exported excel's print preview. So I have created the header columns with fixed lenths as same as table's header in the page header of the report. Then only the Header will repeat in all pages of the print preview.

But the problem is when doing like this, many of the columns have been merged together. The report layout is ok. But cant sort the data. It says a message "This operation requires the merged cells to be identically sized."

In some forms i have found the header control's edges need to be sized identically with the tables' columns edges. I did it. But still the columns are merged when exporting.

Please help me out from this.

Thanks in advance.

Arputharaj.D

View 4 Replies View Related

How To Disable Hyperlink In Exported Excel File?

May 14, 2007

Hi,



I have a report in which some links navigate to other reports.



If i export the report in Excel format. The Excel file also contain hyperlink what i have created in report. If i click the link in Excel file, it is directing to reportviewer to open that link.



But i need to export this report in Excel format with hyperlink disabled.



I will appreciate if anyone give a solution .



Thank you,

View 10 Replies View Related

Disable Hyperlink In Exported Excel File (SSRS)

May 13, 2008



I have a report in which some links navigate to other reports.



If export the report in Excel format. The Excel file also contain hyperlink what have created in report. If i click the link in Excel file, it is directing to report viewer to open that link.



But need to export this report in Excel format with hyperlink disabled

( I used Export option from Report Designer )

Let me know!!

Thanks

View 1 Replies View Related

How To Show The Report Exporting Date Only In The Exported PDF/Excel File (ReportViewer Control)?

Mar 3, 2008



Hello everyone,

Our customer wants to display the exporting date only in the exported file when exports a report to PDF/Excel (we are using ReportViewer Control in ASP.NET). Can anybody tell me how to achieve this?

Thanks a lot.

Danny Li

View 7 Replies View Related

Export To A Text File, Then Name The Exported File The Date Is Was Exported, Then Zip

Jul 3, 2007



Hi folks



Any help on my request would greatly be appreciated. We are trying to maintain the growth of a particular table, by exporting and deleting data that is older then 90 days. Here are the 4 steps I need to do. I believe I know how to do 1 and 4;

1. Create a job that continously exports data that is older then 90 days to a text file

select *

from table A

WHERE (CREATED < DATEADD(DAY, - 90, GETDATE()))



(the column 'created' datatype is datetime and looks like this '3/5/2007 3:11:44 PM')



2. Have the job automatically name the exported file, the day it was exported (i.e. 07032007 (todays date))

3. Then zip that file (we're using 7-zip)

4. Then delete the data out of the table

delete

from table A

WHERE (CREATED < DATEADD(DAY, - 90, GETDATE()))



Im not a big scripter/coder, so I was wondering if there is anything I could do in SSIS. Im more familiar with DTS, so any kind of baby steps you could provide in SSIS, would go a long way.



Thank you so much.

View 1 Replies View Related

Cant Sort Data In Exported Excel File From Sql Server Reporting Server

Feb 7, 2008



Hello,
I am new to this sql server reporting server technology. I have a requirement like the table header should repeat in all pages of the exported excel's print preview. So I have created the header columns with fixed lenths as same as table's header in the page header of the report. Then only the Header will repeat in all pages of the print preview.

But the problem is when doing like this, many of the columns have been merged together. The report layout is ok. But cant sort the data. It says a message "This operation requires the merged cells to be identically sized."

In some forms i have found the header control's edges need to be sized identically with the tables' columns edges. I did it. But still the columns are merged when exporting.


Please help me out from this.


Thanks in advance.

View 5 Replies View Related

Reports Exported As Excel Cannot Be Read By Mac Version Of Excel

Jan 31, 2007

I searched the list but did not see anything related.

I cannot open a file directly exported from RS in the Excel format. If I open the file in the Windows version and then close it, no need to even save it, I can then open it with the Mac version of Excel. The file size after closing is about 2K less so the RS program is adding something onto the file that the Mac version does not like. It will crash Excel when trying to open.

I cannot export the report as CSV as it will not correctly import into Excel on the Mac.

Is there a work around for this?

Thanks.

--sean

View 5 Replies View Related

Fatal Error Doing Simple Queries From An Sql 2000 To Sql 2005 Exported Database

Jun 8, 2006

I have been trying to export an sql2000 database to sql2005 with no luck. I continuosly get the error

Msg 0, Level 11, State 0, Line 0

A severe error occurred on the current command. The results, if any, should be discarded.

I have looked upon all support material and have installed the latest sql2005 service pack, but this has not fixed the problem. a simple query as:

select * from [transaction] ta,transactionentry tr

where tr.transactionnumber=ta.transactionnumber and

glacctid=6 and ta.[time]> '3/01/2006'

would produce this fatal error.

the current version I am using is:

Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)

This problem is happening on some of the most important tables in the database.

the error log contains the following:

2006-06-06 11:43:32.59 spid54 ***Stack Dump being sent to C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGSQLDump0001.txt
2006-06-06 11:43:32.59 spid54 SqlDumpExceptionHandler: Process 54 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
2006-06-06 11:43:32.59 spid54 * *******************************************************************************
2006-06-06 11:43:32.59 spid54 *
2006-06-06 11:43:32.59 spid54 * BEGIN STACK DUMP:
2006-06-06 11:43:32.59 spid54 * 06/06/06 11:43:32 spid 54
2006-06-06 11:43:32.59 spid54 *
2006-06-06 11:43:32.59 spid54 *
2006-06-06 11:43:32.59 spid54 * Exception Address = 0136B4F0 Module(sqlservr+0036B4F0)
2006-06-06 11:43:32.59 spid54 * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
2006-06-06 11:43:32.59 spid54 * Access Violation occurred writing address FFFFFFFC
2006-06-06 11:43:32.59 spid54 * Input Buffer 260 bytes -
2006-06-06 11:43:32.59 spid54 * select * from [transaction] tr,transactionentry te where tr.
2006-06-06 11:43:32.59 spid54 * transactionnumber = te.transactionnumber and glacctid = 6
2006-06-06 11:43:32.59 spid54 *
2006-06-06 11:43:32.59 spid54 *
2006-06-06 11:43:32.59 spid54 * MODULE BASE END SIZE
2006-06-06 11:43:32.59 spid54 * sqlservr 01000000 02BA7FFF 01ba8000
2006-06-06 11:43:32.59 spid54 * ntdll 7C800000 7C8BFFFF 000c0000
2006-06-06 11:43:32.59 spid54 * kernel32 77E40000 77F41FFF 00102000
2006-06-06 11:43:32.59 spid54 * MSVCR80 78130000 781CAFFF 0009b000
2006-06-06 11:43:32.59 spid54 * msvcrt 77BA0000 77BF9FFF 0005a000

I have followed instructions on some support issues posted but none have helped. If anyone has any solution to this problem PLEASE HELP!!!!.

Thanks.

View 7 Replies View Related

Footer Does Not Exported To Excel

Mar 28, 2007

Hi,
I have a report with text in the footer.
When I exported it to excel, every thing except from the footer is exported (the report body and header are OK).

I'm not getting any error but the text in the footer just doesn't appear.

Any solution?
Thanks.

View 5 Replies View Related

Subreports Are Not Exported Into Excel

Feb 4, 2008



hai,

i was created report with 6 sub reports for muliple columns driil down as based on client requirements, and also iam using one subreport with in the all 6 sub reports,when run the report i got the correct data. my report output having total 11 fields. with in the 6 fields iam using the 6 sub reports, with in the 6 sub reports iam calling the another sub report.


while exportin my report into excel sub reports are not shown, in the place of sub reports i got the error that is "
subreports within a table or matrix cells are ignored"

my client must need report output in excel format, so how to solve this problem. in my analysis excel is not support sub report feature, is there any diffrent method or is there or any third party control is there


please give me solution how to solve this probelm.


Thanks in advance

jacks v

View 3 Replies View Related

DTS Transfer Into A Excel Spreadsheet

Dec 28, 2000

I need to take my 'table stats'every week and put them into an excel spreadsheet so that I can track the changes of my table sizes over time (basically I am watching to see how many rows are in each table). What I was planning on doing was to create a view of my table stats that I could then use DTS to transfer on a weekly basis into my excel spreadsheet. I have only used DTS a couple of times, and I have not ever tried it with excel. Now the problem: Everytime my DTS job runs it appends the data to the end of the origional columns that were created. Since my database has over 5000 tables these columns grow quite quickly. What I would like to do is set it up so that everytime the job runs it puts the new data into new columns in the same worksheet of my excel file. Is this possible? Any suggestions?

View 1 Replies View Related

DTS From MS SQL To Excel Spreadsheet Issue

Jan 9, 2007

I'm getting an issue on a MS SQL DTS package that is doing a simple export from a MS SQL table to and Excel spreadsheet. I have three of these running but one is failing. I’m using DTSRun to run all three of these DTS packages. The only recent change was to the DTS package to fix the first step to delete the data in the spreadsheet tab named “Results”. The process works correctly in development (on different servers). The same active directory ID is being used on all three DTS packages and all three do the same i.e. export data to an excel spreadsheet in the same file location but with different names. I’ve Google’d this but only came across access issues which does not make since since it is writing the other two spreadsheets just fine. Curious.

Error I See:

Running DTS package with passed variables
...
DTSRun: Loading...

DTSRun: Executing...

DTSRun OnStart: DTSStep_DTSDynamicPropertiesTask_1

DTSRun OnFinish: DTSStep_DTSDynamicPropertiesTask_1

DTSRun OnStart: Drop table Results Step

DTSRun OnError: Drop table Results Step, Error = -2147217911 (80040E09)

Error string: Cannot modify the design of table 'Results'. It is in a read-only database.

Error source: Microsoft JET Database Engine

Help file:

Help context: 5003027

Error Detail Records:

Error: -2147217911 (80040E09); Provider Error: -538642193 (DFE4F8EF)

Error string: Cannot modify the design of table 'Results'. It is in a read-only database.

Error source: Microsoft JET Database Engine
Help file:
Help context: 5003027

Any ideas would be great.

Thanks.
Jim

View 3 Replies View Related

DTS Help With Uploading An Excel Spreadsheet

Apr 4, 2007

Can somebody please tell me what I am doing wrong or need to do to resolve my issue. I having problems with one of the columns in an excel spreadsheet that I am trying to upload into the system. One of the columns contain values of both text and numbers such as 'ABC123', 'ABC124', '123456' etc. When I try uploading the sheet into SQL Server 2000 using DTS, the system removes all characters from the one column that I am having problems with. So entry 'ABC123' for example would be truncated to '123'. I tried formatting the column that I am having trouble with in excel to 'General' format as well as tried to transform the column to type varchar in SQL Server while using the DTS wizard but still had no luck. The problem is that SQL server thinks that the column is a float type column from the source and therefore truncates any characters.

View 2 Replies View Related

Looping Through An Excel Spreadsheet

Feb 23, 2006

Being new to SSIS I wish to loop through a series of excel spreadsheets and within each workbook loop through each sheet. I am aware of the For Each container but how can the each sheet in the workbook be referenced?

Steve

View 42 Replies View Related

XML Task And Excel Spreadsheet

Feb 21, 2007

Hello,

I have some XML that I'm passing through a variable into the XML task in SSIS. I also have an xsd file that I'm using and I want to validate (I think) that XML and have the XML task output an excel document. I've got the xsd file all set up in the "second operand" part of the XML task and the XML I'm passing in as a variable and that's in the "input" part of the XML task. My question is are there any tricks to make an excel document with these two things? Is there something I need to do in the xsd file to tell it that I want excel? Below is my XML and xsd:

XML:

<person>

<person_id>117</person_id>

<last_name>Von Neumann</last_name>

<first_name>Marina</first_name>

<jobs>

<job>

<job_key>1</job_key>

<from_month>06</from_month>

<from_year>1987</from_year>

<company_id>30358</company_id>

</job>

<job>

<job_key>2</job_key>

<from_month>06</from_month>

<from_year>1985</from_year>

<company_id>30358</company_id>

</job>

<job>

<job_key>3</job_key>

<from_month>06</from_month>

<from_year>1979</from_year>

<company_id>30358</company_id>

</job>

<job>

<job_key>4</job_key>

<from_month>09</from_month>

<from_year>1992</from_year>

<company_id>8766</company_id>

</job>

<job>

<job_key>5</job_key>

<from_month>06</from_month>

<from_year>1962</from_year>

<company_id>8822</company_id>

</job>

<job>

<job_key>6</job_key>

<from_month />

<from_year />

<company_id>8822</company_id>

</job>

</jobs>

</person>

XSD:

<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema"><xsd:element nillable="true" name="person"><xsd:complexType><xsd:sequence minOccurs="0"><xsd:element minOccurs="0" nillable="true" type="xsd:integer" name="person_id" form="unqualified"></xsd:element><xsd:element minOccurs="0" nillable="true" type="xsd:string" name="last_name" form="unqualified"></xsd:element><xsd:element minOccurs="0" nillable="true" type="xsd:string" name="first_name" form="unqualified"></xsd:element><xsd:element minOccurs="0" nillable="true" name="jobs" form="unqualified"><xsd:complexType><xsd:sequence minOccurs="0"><xsd:element minOccurs="0" maxOccurs="unbounded" nillable="true" name="job" form="unqualified"><xsd:complexType><xsd:sequence minOccurs="0"><xsd:element minOccurs="0" nillable="true" type="xsd:integer" name="job_key" form="unqualified"></xsd:element><xsd:element minOccurs="0" nillable="true" type="xsd:string" name="from_month" form="unqualified"></xsd:element><xsd:element minOccurs="0" nillable="true" type="xsd:string"
name="from_year" form="unqualified"></xsd:element><xsd:element minOccurs="0" nillable="true" type="xsd:integer" name="company_id" form="unqualified"></xsd:element></xsd:sequence></xsd:complexType></xsd:element></xsd:sequence></xsd:complexType></xsd:element></xsd:sequence></xsd:complexType></xsd:element></xsd:schema>




Thanks,

Phil

View 7 Replies View Related

Import Excel Spreadsheet To Sql Database

Mar 26, 2008

Hi there,
 
              I am able to import an excel spreadsheet into a table in sql server 2005 using SqlBulkCopy. The only thing that bothers me here is how to check duplicate entries and throw an error to the user regarding the duplicate entries. In the table in sql, there is no primary keys. There are five columns and the way I will have to find the duplicates is to match all those 5 columns. Since the excel spreadsheet can have 40 to 500 entries, how can I check those dupes.

View 1 Replies View Related

Getting An Excel Spreadsheet Into An SQL Server Table

Nov 6, 2003

Hi everyone,

I've got an Excel Spreadsheet with 5 columns of data which I need to get into an SQL Table. There's 13,000 rows in this Spreadsheet so manually doing it is out of the question.

How can I go about doing this?

Any help will be appreciated!

Thanks,

Andrew

View 4 Replies View Related

DTS To Excel And Full Spreadsheet Error?

Jul 16, 2001

Hey guys,

I'm exporting via dts to an excel spreadsheet. However my database has more than 65000 records. DTS croacks and shoots out that there are too many records in the spreadsheet.

What do I do? Any way to go around that? These are my daily hit logs that are recorded and they tend to get big.


Ilya Zherebetskiy

View 1 Replies View Related

&#34;exporting&#34;? SQL Data To An Excel Spreadsheet

Aug 7, 2002

I am new to SQL and can do queries OK on SQLTalk. I need to know if there is a script to retrieve data and then export to an Excel spreadsheet for internal company use. Is there such a beast and is this the right place to look???

View 1 Replies View Related

Importing An Excel Spreadsheet Into SQL Server

Aug 9, 2007

Hi,
I'm trying to import an excel file into SQL sever(using an insert statement), i'm creating a DTS package (in enterprise manager) and have VB Script. When i parse it, i get no errors, but when i run the package it says that it ran successfully but nothing happens, it doesnt insert into the table, even though i tested the insert statement. Can anyone help me?? Here's the code:

'************************************************* *********************
' Visual Basic ActiveX Script
'************************************************* ***********************

Function Main()
on error resume next
Set objxl = CreateObject("Excel.Application")
objxl.Visible = False


Dim xlFile
xlFile = "C:Datafile.xls"
Set objWkb = objxl.Workbooks.Open(xlFile)

'' Connecting to SQL Server
set cn = server.CreateObject("ADODB.Connection")

Dim serverName
serverName = "myserver2"


strCS = "Provider=SQLOLEDB; Data Source=myserver2;Initial
Catalog=mycat; Integrated Security=SSPI"

cn.ConnectionString = strCS
On Error Resume Next
cn.Open
Set objsht = objWkb.Worksheets.Open("Sheet1")
Dim client_name, rb, date_rvd, LOB
Dim sql
Dim row, sequence
row = 2

client_name = Trim(objsht.Cells(row, 2).Value)
Do While IsNull(client_name) = False And client_name <> ""
'client_name = Trim(objsht.Cells(row, 2))
rb = Trim(objsht.Cells(row, 4).value)
date_rvd = Trim(objsht.Cells(row, 6).value)
LOB = "WCS"

sql = "INSERT INTO TEMP_TEST (CLIENT_NAME, RB, DATE_REVIEWED, LOB) VALUES (" & _
" '" & client_name & "' ,'" & rb & "', " & date_rvd & ", '" & LOB & "');"


row = row + 1
MsgBox (sql)
client_name = Trim(objsht.Cells(row, 2).value)
cn.Execute (sql)

Loop

if err.count = 0 then
Main = DTSTaskExecResult_Success
else
Main = DTSTaskExecResult_Failure
end if
End Function

View 14 Replies View Related

Question About Deleting A Spreadsheet In Excel Using DTS

Feb 5, 2004

Dear all,

i'm using DTS to create a procedure. what i wanna do is to pump data to the excel, however i need to re-use the same excel file everytime, ie:i need to delete all fields in the spreadsheet except the colume name and then pump all data in again. i know how to pump the data in, however i dun know how to simply clear the existing data in the spreadsheet, can anyone help me, big thx ~!

Kam2

View 3 Replies View Related

Linked Server - Excel Spreadsheet

May 12, 2008

I am trying to set up a linked server in SQL Server 2005 to link to an excel spreadsheet.

-I am selecting Jet 4.0 as the provider
-Product name is Excel
-Data Source is the path on our network to the excel file: N:Devon54034.0 Engineering4.01 ProcessLinelistIFCLDT Field.xls
-Provider String is Excel 8.0
-Security | Login not defined is set to Be made using the login's current security context.

The Excel file is an Excel 2003 spreadsheet. The worksheet is titled Pages

I have a query window open in SQL Server Management Studio and the following is my select statement:

SELECT * FROM DEVON_LINE_LIST...Pages$

I get the following error message:

OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "DEVON_LINE_LIST" returned message "Cannot start your application. The workgroup information file is missing or opened exclusively by another user.".
Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "DEVON_LINE_LIST" reported an error. Authentication failed.
Msg 7303, Level 16, State 1, Line 1
Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "DEVON_LINE_LIST".

I get similar error messages no matter which security settings I pick.

Any thought as to what I can try to get this to work?

View 3 Replies View Related

Way To Import Data From CSV Or Excel Spreadsheet

Nov 4, 2013

I am looking for a way to import data from a CSV or Excel spread sheet and add the data directly into an Extended field instead of a regular field in the table. for example: let's say I have a comma delimited field with the following info:

NDC_M_FORMULARY,CUSTOM_EXTSIG,Custom EXT SIG
NDC_M_FORMULARY,DRUG_CODE,Alternate key, user defined
NDC_M_FORMULARY,CHARGE_CODE,From the Charge code table

The first column is the table name
Second Column is the Column name in the table
The third column contains the description that I would like to store in the Value in the Extended Property Name "MS_Description"

BTW,I did find the following T-SQL which returns the Extended description for a specific Extended Property

Here it is:

SELECT
[Table Name] = i_s.TABLE_NAME,
[Column Name] = i_s.COLUMN_NAME,
[Description] = s.value
FROM
INFORMATION_SCHEMA.COLUMNS i_s
LEFT OUTER JOIN

[code]...

View 1 Replies View Related

NEW SQL- How To Export Table To Excel Spreadsheet?

Dec 18, 2005

Hi All,

I am new to SQL program. I did little management for SQL 2000 before.
I need to export from a table or view to excel spreadsheet for company's marketing resourece. Is there any easy simple way to do it?

Thanks all for your help.

Perry Yang

View 11 Replies View Related

SSIS And Excel Spreadsheet Manipulation

Mar 7, 2008



I am using SSIS to export data from a table to an Excel spreadsheet. This all seems to work put just fine. The user would like a data in column B1 to say when the spreadsheet was created. Is there a way within SSIS to do this. I was looking at using a .NET script but it accesses the spreadsheet as a table so I do not know how to insert data above the headings in row 1. I believe the OleDB provider using column 1 as it column names for the table. Maybe I am just going about the whole think wrong?

Thanks

View 5 Replies View Related

OleDB Update To Excel Spreadsheet

Mar 12, 2008

Is there a limit to the number of fields that can be set in an OleDB Update Statement?

This works with 6 fields:
cmd.CommandText = "Update [Sheet2$A2:AP2] Set F1 = '1', F2 = '35062', F3 = '6', F4 = '620000.0000', F5 = '200000.0000', F6 = '700000.0000'"

This Fails with 7 fields:
cmd.CommandText = "Update [Sheet2$A2:AP2] Set F1 = '1', F2 = '35062', F3 = '6', F4 = '620000.0000', F5 = '200000.0000', F6 = '700000.0000', F7 = '123'"

The range should be plenty big with A2:AP2. In the end I'm trying to push 42 fields.


The complete segment is:

Dim ExcelConnection As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & ExcelFileName & ";" & _
"Extended Properties=""Excel 8.0;HDR=NO"""
Dim conn As New System.Data.OleDb.OleDbConnection(ExcelConnection)
Dim cmd As New System.Data.OleDb.OleDbCommand()

conn.Open()
cmd.Connection = conn

cmd.CommandText = "Update [Sheet2$A2:AP2] Set F1 = '1', F2 = '35062', F3 = '6', F4 = '620000.0000', F5 = '200000.0000', F6 = '700000.0000', F7 = '1234'"

cmd.ExecuteNonQuery()

View 1 Replies View Related

Comparing Table With Excel Spreadsheet

Aug 23, 2007

Hi all,


I have two tables in SQL Server 2005 and excel sheet ( Office 2003).


The colums of excel sheet are: name ,ssn, flagbit ( Note: Excel sheet contains data already)

Columns of table_one and table_two are: name ,ssn


I want to compare the ssn field from table_one and ssn in excelsheet_one, if it matches , then flagbit in excelsheet_one should say"T1".


If i compare ssn field from table_two and ssn in excelsheet_one, if it matches, the flagbit in excelsheet_one should say "T2".


Ex:

Table_one (input) ---- excelsheet_one ( Output)

ssn name ---- ssn name flagbit

11 NYC ---- 11 NYC T1


Both the tables refers same excelsheet_one and have to update the same flag bit column in excelsheet.

Basically, i want to compare table and excel sheet, then if it matches, then update excel sheet.



Does anybody how to do this.


Any help will be greatly appreciated.

Thanks

View 4 Replies View Related

Possible To Maintain Barcode On Exported Excel Sheet

Sep 17, 2012

I am trying to encode the barcode on the reporting service using SQL server 2005, they told me it is possible to maintain the barcode on exported excel sheet, however, I did not find the barcode on it, only squre black image.

View 2 Replies View Related

Additional Subtotal Column And Row When Exported To Excel

Aug 23, 2007

Hi, there,

When I view the report on the web, everything is fine until I exported the report to Excel. Additional column and row without heading appear in the exported Excel report. I have no idea, where do these row and column come from as I don't have these additional row and column in the designer. These additional row and column contain the subtotal.

How do I get rid of these additional row and column?

Thank you.

Regards,
Yong Hwee

View 3 Replies View Related

Poor Chart Quality When Exported To Excel

Apr 2, 2008



Hi,

Whenever we export a chart to excel, the quality of the chart becomes very poor (blurred image and font).
The images look crisp when viewing from report manager and the designer.

Has anyone encountered and solved the same problem?

Thanks

View 3 Replies View Related

Color Bleeding Into Next Columns When Exported To Excel

Mar 9, 2007

I have one issue left to solve before releasing my drilldown report to production. The report displays fine in report manager; however, when it is exported to excel, the color (Coral) in the last column on the right is bleeding into the next three columns in excel. I have looked at properties, sizing and searched the archives. Anyone have an idea how I can fix this to render properly?

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved