I've installed SQL express, now what?

This may be a stupid question, but I've installed SQL Express and I don't know what to do next. I went to my program files/Microsft SQL... and the only folder present is a configuration folder.

Next I went to my control panel/admin tools/ODBC and succussfully created a user data source. (With the help of the forum!)

Obviously, I've never used SQL before, but I've read a couple of books and other stuff online, and I want to teach myself. So I decided to install this. Basically, I'm looking for answers on how to access the database. I know it's installed, it's in the Add/Remove programs list. I just don't know how to connect/access it.

Sorry for the dumb question.

Stacey

I think I figured it out. You have to access the DB using another program, and connect using the ODBC that I previously created. Am I correct?

I thought it was an independent DB, meaning I could directly access it. Thanks!

|||

Hi

You'll need to download SQL Management Studio Express (here). It will allow you to create databases, run queries etc. That way you won't have to work "in the dark".

HTH

|||

Thank you so much for helping me. Now I just have to figure out how to use it, and what to do!!!

Stacey

|||Update - Thank you so much Andre! I am off and running thanks to you. I figured out how to use it, and now I'm learning SQL thanks to you!!

ITW wont save script file

Hi all,

I am running the ITW against several trace files that were created from a single trace file. I only have the following problem when attempting to save the script file from the analysis of any one of the multiple trace files. I have used the ITW against single trace files with no problem.

Here's the problem:
Everything works fine until I select the "Save Script File" option. After selecting this option, designating a file name to save to, and then clicking the "Next" button, the application appears to hang up. It displays an hourglass pointer, as though it is working, but just sits there forever. Also, when I look at the task manager this application reports that it is "not responding". I have allowed it to sit there in this state for several hours before finaly killing the process. Is there some additional configuration or method required to analyze multiple trace files from a single trace session?

Any suggestions would be greatly appreciated.

Thanks,
RickThis could be a bug. You might want to contact PSS.

iterate/loop indexing services files

How can I loop through or get a resultset with all files in an indexing
services catalog?
Is there a way to make the returning recordset contain all records?
I want to go through and grab the FileIndex from all files. The files are
static so I don't have to worry about the value changing.
Thanks in advance
Follow-ups to microsoft.public.inetserver.indexserver
this is a terrible way of doing it but
select * from openquery(webLS,'select path,filename from webCat..scope()
where size >0')
where my catalog name is webCat, and my linked server name is also webLS
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"AC" <no@.spam.me> wrote in message
news:el$h5cK%23GHA.5092@.TK2MSFTNGP04.phx.gbl...
> How can I loop through or get a resultset with all files in an indexing
> services catalog?
> Is there a way to make the returning recordset contain all records?
> I want to go through and grab the FileIndex from all files. The files are
> static so I don't have to worry about the value changing.
> Thanks in advance
> Follow-ups to microsoft.public.inetserver.indexserver
>

Iterate through all Excel files and all their sheets

hello,

i need to transfer (migrate ) the data from xl sheet to sqlserver but actually the thing is if the source excel file has different sheets, in each sheet i have the data

and i need to move the entire data( all the data that is present in all sheets of the excel file) to a single table into sql server

like wise i have many xl files ( which have many sheets ) .

for eg:

excel file 1:

-> sheet 1

-> sheet 2

-> sheet 3

excel file 2:

-> sheet 1

-> sheet 2

-> sheet 3

excel file 3:

-> sheet 1

-> sheet 2

-> sheet 3

now i need to get the data from all of the files and i need to insert into a single table ( sql server) in ssis package

so plz help me by giving the solution asap.

thanks

B L Rao

hello ,

while i am trying to transfer the data from xl file to table in sql server by using ssis package it is giving error saying that primary key violation and cant insert duplicate value.

i understood that there is some duplicate data but can i find where that duplicate data exists i mean in which row ? because it contains thousands of records.

thanks and regards

B L Rao.

|||You may accomplish this by using 2 nested Loops: One fairly simple, a foreach loop to iterate through all excel files; a second one to iterate through each excel sheet. I am not sure how to implement the second one; perhaps if the number and name of the sheets is always the same you could built a list of values in a variable and then have the excel component to get the table name from a variable. Just an Idea, you would need to figure out the details.

Iterate through a list of files with bcp

I have a folder full of date-stamped files: 010101.txt, 010201.txt,
010301.txt, etc.
I have a working bcp command that points to a specific file.
declare @.bcpCommand varchar(1000)
select @.bcpCommand = 'BCP "Import.dbo.NAV" in
"d:\folder\010101.txt" -c -T -t, -S "SERVER1\SERVER1"'
EXEC master.dbo.xp_cmdshell @.bcpCommand
How can I script the bcp command so it will import all files between say
010101 and 120105? Complicating factor; there are gaps in the sequence. Can
the script continue even if it doesn't find a file?
Alternatively, if it was possible to issue the bcp command against all files
in a folder no matter what the filename, that would work also.
This is a one-time data load with SQL Server 2000/SP4
Thanks to anyone who could help.For sake of simplicity, write a cursor script & get it off. Here is a quick
try:
DECLARE @.cmd VARCHAR(500), @.c VARCHAR(500)
CREATE TABLE #t ( c VARCHAR( 500 ) NOT NULL )
INSERT #t EXEC master.dbo.xp_cmdshell 'DIR d:\folder\*.txt /B'
DECLARE c CURSOR FOR SELECT f FROM #t
OPEN c
FETCH NEXT FROM c INTO @.c
WHILE @.@.FETCH_STATUS = 0
BEGIN
SET @.cmd = 'BCP "Import.dbo.NAV" in "d:\folder\' + @.c + '" -c -T -t, -S
"SERVER1\SERVER1"'
EXEC master.dbo.xp_cmdshell @.cmd
FETCH NEXT FROM c
END
CLOSE c
DEALLOCATE c
DROP TABLE #t ;
Anithsql

Issues with too many audittrace .trc files

Hi
I am running MSD 2005 Express Sequel Server and am noticing that in
the data folder located under C:\Program Files\Microsoft SQL Server
\MSSQL.1\MSSQL\Data, that every 3 hours or so a .trc file (I am
assuming it is some sort of log file) is being created. Here is a
sample title of what the file is labled:
audittrace20070618090810_328.trc. These files are big, at least
200,000KB, and are taking up way too much space in my hard drive.
Does any body here know the source for these files? What type of file
is it or neccessary for? I am assuming there is some stored process in
the sequel server that is creating these big files. I am just not sure
where to find that process or where the command is coming from.
Any help is much appreciated. Thanks in advance!
JonathanIt is the "default trace", a Profile trace. You can turn it off using sp_con
figure. If you want to
check what events and columns it traces, see:
http://sqlblog.com/blogs/tibor_kara...
ce.aspx
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
<ridingtime516@.gmail.com> wrote in message
news:1184615740.955056.40490@.o61g2000hsh.googlegroups.com...
> Hi
> I am running MSD 2005 Express Sequel Server and am noticing that in
> the data folder located under C:\Program Files\Microsoft SQL Server
> \MSSQL.1\MSSQL\Data, that every 3 hours or so a .trc file (I am
> assuming it is some sort of log file) is being created. Here is a
> sample title of what the file is labled:
> audittrace20070618090810_328.trc. These files are big, at least
> 200,000KB, and are taking up way too much space in my hard drive.
> Does any body here know the source for these files? What type of file
> is it or neccessary for? I am assuming there is some stored process in
> the sequel server that is creating these big files. I am just not sure
> where to find that process or where the command is coming from.
> Any help is much appreciated. Thanks in advance!
> Jonathan
>sql

Issues with too many audittrace .trc files

Hi
I am running MSD 2005 Express Sequel Server and am noticing that in
the data folder located under C:\Program Files\Microsoft SQL Server
\MSSQL.1\MSSQL\Data, that every 3 hours or so a .trc file (I am
assuming it is some sort of log file) is being created. Here is a
sample title of what the file is labled:
audittrace20070618090810_328.trc. These files are big, at least
200,000KB, and are taking up way too much space in my hard drive.
Does any body here know the source for these files? What type of file
is it or neccessary for? I am assuming there is some stored process in
the sequel server that is creating these big files. I am just not sure
where to find that process or where the command is coming from.
Any help is much appreciated. Thanks in advance!
Jonathan
It is the "default trace", a Profile trace. You can turn it off using sp_configure. If you want to
check what events and columns it traces, see:
http://sqlblog.com/blogs/tibor_karaszi/archive/2007/03/12/whats-in-the-default-trace.aspx
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
<ridingtime516@.gmail.com> wrote in message
news:1184615740.955056.40490@.o61g2000hsh.googlegro ups.com...
> Hi
> I am running MSD 2005 Express Sequel Server and am noticing that in
> the data folder located under C:\Program Files\Microsoft SQL Server
> \MSSQL.1\MSSQL\Data, that every 3 hours or so a .trc file (I am
> assuming it is some sort of log file) is being created. Here is a
> sample title of what the file is labled:
> audittrace20070618090810_328.trc. These files are big, at least
> 200,000KB, and are taking up way too much space in my hard drive.
> Does any body here know the source for these files? What type of file
> is it or neccessary for? I am assuming there is some stored process in
> the sequel server that is creating these big files. I am just not sure
> where to find that process or where the command is coming from.
> Any help is much appreciated. Thanks in advance!
> Jonathan
>

Issues with too many audittrace .trc files

Hi
I am running MSD 2005 Express Sequel Server and am noticing that in
the data folder located under C:\Program Files\Microsoft SQL Server
\MSSQL.1\MSSQL\Data, that every 3 hours or so a .trc file (I am
assuming it is some sort of log file) is being created. Here is a
sample title of what the file is labled:
audittrace20070618090810_328.trc. These files are big, at least
200,000KB, and are taking up way too much space in my hard drive.
Does any body here know the source for these files? What type of file
is it or neccessary for? I am assuming there is some stored process in
the sequel server that is creating these big files. I am just not sure
where to find that process or where the command is coming from.
Any help is much appreciated. Thanks in advance!
JonathanIt is the "default trace", a Profile trace. You can turn it off using sp_configure. If you want to
check what events and columns it traces, see:
http://sqlblog.com/blogs/tibor_karaszi/archive/2007/03/12/whats-in-the-default-trace.aspx
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
<ridingtime516@.gmail.com> wrote in message
news:1184615740.955056.40490@.o61g2000hsh.googlegroups.com...
> Hi
> I am running MSD 2005 Express Sequel Server and am noticing that in
> the data folder located under C:\Program Files\Microsoft SQL Server
> \MSSQL.1\MSSQL\Data, that every 3 hours or so a .trc file (I am
> assuming it is some sort of log file) is being created. Here is a
> sample title of what the file is labled:
> audittrace20070618090810_328.trc. These files are big, at least
> 200,000KB, and are taking up way too much space in my hard drive.
> Does any body here know the source for these files? What type of file
> is it or neccessary for? I am assuming there is some stored process in
> the sequel server that is creating these big files. I am just not sure
> where to find that process or where the command is coming from.
> Any help is much appreciated. Thanks in advance!
> Jonathan
>

issues about foreach loop

I defined Foreach File Enumerator,there are more than 2 files needed to deal with,it donesn't work if i don't specify filename in flat file connection manager editor,however if i specify filename then doesn't foreach files

what should i do? thanks

and i tried to use varialbes ,but it seems not supported in Flat File connection manager editor?|||

andrew knight wrote:

I defined Foreach File Enumerator,there are more than 2 files needed to deal with,it donesn't work if i don't specify filename in flat file connection manager editor,however if i specify filename then doesn't foreach files

what should i do? thanks

Did you set an expression on the ConnectionString property of the connection manager?

-Jamie

|||

get it

thanks in advance

Issue with Report Manager after SP 2 install

I'm trying to delete reports using Report Manager from the folder
level by checking multiple files and hitting the delete button. It
use to work but after SP2, the script behind the button no longer
works.
Is anyone experiencing the same issue?
Thanks,
TWe have the same problem - actually, we can't delete any reports, not just
multiple reports.
I found a post on a web site that says that it is a known problem with the
SP2 CTP and will be fixed in the final SP2 release.
<tuong.k.lam@.gmail.com> wrote in message
news:1170293384.531044.128600@.k78g2000cwa.googlegroups.com...
> I'm trying to delete reports using Report Manager from the folder
> level by checking multiple files and hitting the delete button. It
> use to work but after SP2, the script behind the button no longer
> works.
> Is anyone experiencing the same issue?
> Thanks,
> T
>|||Thanks DJX,
Can you post the website where you saw the problem, if you can
remember.

Issue with Exporting

I have read previous posts and am still having an issue. Our production
server is running SP1 and still exports Excel Files as web archive format.
So the files end up being 10 to 20 MB and not 1 MB. Any help would be
appreciated. Thanks in advance
--
Thanks,
Chris AllenSorry for the half question.. I need to find a way to only export as an
excel file. Even when i select it and hit export it spits out HTML content
in my XLS File. Anyone got any suggestions?
--
Thanks,
Chris Allen
"Chris" <chrisjallen@.comcast.net> wrote in message
news:%23caPmBTFFHA.1524@.TK2MSFTNGP09.phx.gbl...
> I have read previous posts and am still having an issue. Our production
> server is running SP1 and still exports Excel Files as web archive format.
> So the files end up being 10 to 20 MB and not 1 MB. Any help would be
> appreciated. Thanks in advance
> --
>
> Thanks,
> Chris Allen
>|||Here is a cutout of the document to show what's happening. When I select
EXCEL and I hit export via the web I get this...
"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"
Anyone have answers or do i have to just switch solutions? We will rely
heavily on exporting and if this doesnt work then its back to the drawing
board... Any help would be appreciated. Thanks in advance.
Thanks,
Chris Allen
"Chris" <chrisjallen@.comcast.net> wrote in message
news:%23TqEPJTFFHA.3492@.TK2MSFTNGP12.phx.gbl...
> Sorry for the half question.. I need to find a way to only export as an
> excel file. Even when i select it and hit export it spits out HTML content
> in my XLS File. Anyone got any suggestions?
> --
>
> Thanks,
> Chris Allen
> "Chris" <chrisjallen@.comcast.net> wrote in message
> news:%23caPmBTFFHA.1524@.TK2MSFTNGP09.phx.gbl...
> > I have read previous posts and am still having an issue. Our production
> > server is running SP1 and still exports Excel Files as web archive
format.
> > So the files end up being 10 to 20 MB and not 1 MB. Any help would be
> > appreciated. Thanks in advance
> >
> > --
> >
> >
> > Thanks,
> > Chris Allen
> >
> >
>|||Are you sure that your production server is running SP1? What version is
shown when you go to //servername/reportserver ?
SP1 definitely exports as native. Prior to SP1 you could not open the Excel
export file in Excel 2000, after SP1 I could. This is because of a format
change.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Chris" <chrisjallen@.comcast.net> wrote in message
news:OB%23bA3hFFHA.3312@.TK2MSFTNGP15.phx.gbl...
> Here is a cutout of the document to show what's happening. When I select
> EXCEL and I hit export via the web I get this...
>
> "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"
>
>
> Anyone have answers or do i have to just switch solutions? We will rely
> heavily on exporting and if this doesnt work then its back to the drawing
> board... Any help would be appreciated. Thanks in advance.
>
> Thanks,
> Chris Allen
> "Chris" <chrisjallen@.comcast.net> wrote in message
> news:%23TqEPJTFFHA.3492@.TK2MSFTNGP12.phx.gbl...
>> Sorry for the half question.. I need to find a way to only export as an
>> excel file. Even when i select it and hit export it spits out HTML
>> content
>> in my XLS File. Anyone got any suggestions?
>> --
>>
>> Thanks,
>> Chris Allen
>> "Chris" <chrisjallen@.comcast.net> wrote in message
>> news:%23caPmBTFFHA.1524@.TK2MSFTNGP09.phx.gbl...
>> > I have read previous posts and am still having an issue. Our production
>> > server is running SP1 and still exports Excel Files as web archive
> format.
>> > So the files end up being 10 to 20 MB and not 1 MB. Any help would be
>> > appreciated. Thanks in advance
>> >
>> > --
>> >
>> >
>> > Thanks,
>> > Chris Allen
>> >
>> >
>>
>|||Yes I am very sure. I installed it not long ago when I ran into other issues
which forced me to install SP1.
--
Thanks,
Chris Allen
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:%23NiHrdpFFHA.2736@.TK2MSFTNGP09.phx.gbl...
> Are you sure that your production server is running SP1? What version is
> shown when you go to //servername/reportserver ?
> SP1 definitely exports as native. Prior to SP1 you could not open the
Excel
> export file in Excel 2000, after SP1 I could. This is because of a format
> change.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Chris" <chrisjallen@.comcast.net> wrote in message
> news:OB%23bA3hFFHA.3312@.TK2MSFTNGP15.phx.gbl...
> > Here is a cutout of the document to show what's happening. When I select
> > EXCEL and I hit export via the web I get this...
> >
> >
> > "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"
> >
> >
> >
> >
> > Anyone have answers or do i have to just switch solutions? We will rely
> > heavily on exporting and if this doesnt work then its back to the
drawing
> > board... Any help would be appreciated. Thanks in advance.
> >
> >
> > Thanks,
> > Chris Allen
> > "Chris" <chrisjallen@.comcast.net> wrote in message
> > news:%23TqEPJTFFHA.3492@.TK2MSFTNGP12.phx.gbl...
> >> Sorry for the half question.. I need to find a way to only export as an
> >> excel file. Even when i select it and hit export it spits out HTML
> >> content
> >> in my XLS File. Anyone got any suggestions?
> >>
> >> --
> >>
> >>
> >> Thanks,
> >> Chris Allen
> >> "Chris" <chrisjallen@.comcast.net> wrote in message
> >> news:%23caPmBTFFHA.1524@.TK2MSFTNGP09.phx.gbl...
> >> > I have read previous posts and am still having an issue. Our
production
> >> > server is running SP1 and still exports Excel Files as web archive
> > format.
> >> > So the files end up being 10 to 20 MB and not 1 MB. Any help would be
> >> > appreciated. Thanks in advance
> >> >
> >> > --
> >> >
> >> >
> >> > Thanks,
> >> > Chris Allen
> >> >
> >> >
> >>
> >>
> >
> >
>|||Please, just to make sure we are not wasting time, go to
//yourserver/reportserver and find the version and then post it here.
Also, how are you getting the excel export? Are you rendering via URL or
Webservices or are you just using the reportmanager portal and selected
export?
What happens if you export from Visual Studio when doing a preview from
there (I assume you have upgraded the visual studio Report Designer as well,
SP1 needed to be applied at both).
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Chris" <chrisjallen@.comcast.net> wrote in message
news:ul8qippFFHA.2824@.tk2msftngp13.phx.gbl...
> Yes I am very sure. I installed it not long ago when I ran into other
> issues
> which forced me to install SP1.
> --
>
> Thanks,
> Chris Allen
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:%23NiHrdpFFHA.2736@.TK2MSFTNGP09.phx.gbl...
>> Are you sure that your production server is running SP1? What version is
>> shown when you go to //servername/reportserver ?
>> SP1 definitely exports as native. Prior to SP1 you could not open the
> Excel
>> export file in Excel 2000, after SP1 I could. This is because of a format
>> change.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Chris" <chrisjallen@.comcast.net> wrote in message
>> news:OB%23bA3hFFHA.3312@.TK2MSFTNGP15.phx.gbl...
>> > Here is a cutout of the document to show what's happening. When I
>> > select
>> > EXCEL and I hit export via the web I get this...
>> >
>> >
>> > "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"
>> >
>> >
>> >
>> >
>> > Anyone have answers or do i have to just switch solutions? We will rely
>> > heavily on exporting and if this doesnt work then its back to the
> drawing
>> > board... Any help would be appreciated. Thanks in advance.
>> >
>> >
>> > Thanks,
>> > Chris Allen
>> > "Chris" <chrisjallen@.comcast.net> wrote in message
>> > news:%23TqEPJTFFHA.3492@.TK2MSFTNGP12.phx.gbl...
>> >> Sorry for the half question.. I need to find a way to only export as
>> >> an
>> >> excel file. Even when i select it and hit export it spits out HTML
>> >> content
>> >> in my XLS File. Anyone got any suggestions?
>> >>
>> >> --
>> >>
>> >>
>> >> Thanks,
>> >> Chris Allen
>> >> "Chris" <chrisjallen@.comcast.net> wrote in message
>> >> news:%23caPmBTFFHA.1524@.TK2MSFTNGP09.phx.gbl...
>> >> > I have read previous posts and am still having an issue. Our
> production
>> >> > server is running SP1 and still exports Excel Files as web archive
>> > format.
>> >> > So the files end up being 10 to 20 MB and not 1 MB. Any help would
>> >> > be
>> >> > appreciated. Thanks in advance
>> >> >
>> >> > --
>> >> >
>> >> >
>> >> > Thanks,
>> >> > Chris Allen
>> >> >
>> >> >
>> >>
>> >>
>> >
>> >
>>
>|||Microsoft SQL Server Reporting Services Version 8.00.878.00
SP1 is installed and i get the issue either way. Using a subscription or
going to the portal and exporting manually. Also on my local machine i am
using Visual Studio to export and i get the same result.
--
Thanks,
Chris Allen
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:e9LDhIsFFHA.1476@.TK2MSFTNGP09.phx.gbl...
> Please, just to make sure we are not wasting time, go to
> //yourserver/reportserver and find the version and then post it here.
> Also, how are you getting the excel export? Are you rendering via URL or
> Webservices or are you just using the reportmanager portal and selected
> export?
> What happens if you export from Visual Studio when doing a preview from
> there (I assume you have upgraded the visual studio Report Designer as
well,
> SP1 needed to be applied at both).
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Chris" <chrisjallen@.comcast.net> wrote in message
> news:ul8qippFFHA.2824@.tk2msftngp13.phx.gbl...
> > Yes I am very sure. I installed it not long ago when I ran into other
> > issues
> > which forced me to install SP1.
> >
> > --
> >
> >
> > Thanks,
> > Chris Allen
> > "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> > news:%23NiHrdpFFHA.2736@.TK2MSFTNGP09.phx.gbl...
> >> Are you sure that your production server is running SP1? What version
is
> >> shown when you go to //servername/reportserver ?
> >>
> >> SP1 definitely exports as native. Prior to SP1 you could not open the
> > Excel
> >> export file in Excel 2000, after SP1 I could. This is because of a
format
> >> change.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >>
> >>
> >> "Chris" <chrisjallen@.comcast.net> wrote in message
> >> news:OB%23bA3hFFHA.3312@.TK2MSFTNGP15.phx.gbl...
> >> > Here is a cutout of the document to show what's happening. When I
> >> > select
> >> > EXCEL and I hit export via the web I get this...
> >> >
> >> >
> >> > "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"
> >> >
> >> >
> >> >
> >> >
> >> > Anyone have answers or do i have to just switch solutions? We will
rely
> >> > heavily on exporting and if this doesnt work then its back to the
> > drawing
> >> > board... Any help would be appreciated. Thanks in advance.
> >> >
> >> >
> >> > Thanks,
> >> > Chris Allen
> >> > "Chris" <chrisjallen@.comcast.net> wrote in message
> >> > news:%23TqEPJTFFHA.3492@.TK2MSFTNGP12.phx.gbl...
> >> >> Sorry for the half question.. I need to find a way to only export as
> >> >> an
> >> >> excel file. Even when i select it and hit export it spits out HTML
> >> >> content
> >> >> in my XLS File. Anyone got any suggestions?
> >> >>
> >> >> --
> >> >>
> >> >>
> >> >> Thanks,
> >> >> Chris Allen
> >> >> "Chris" <chrisjallen@.comcast.net> wrote in message
> >> >> news:%23caPmBTFFHA.1524@.TK2MSFTNGP09.phx.gbl...
> >> >> > I have read previous posts and am still having an issue. Our
> > production
> >> >> > server is running SP1 and still exports Excel Files as web archive
> >> > format.
> >> >> > So the files end up being 10 to 20 MB and not 1 MB. Any help would
> >> >> > be
> >> >> > appreciated. Thanks in advance
> >> >> >
> >> >> > --
> >> >> >
> >> >> >
> >> >> > Thanks,
> >> >> > Chris Allen
> >> >> >
> >> >> >
> >> >>
> >> >>
> >> >
> >> >
> >>
> >>
> >
> >
>|||Well, you definitely have SP1. Could you take a small report, export it as
Excel and include it with a posting.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Chris" <chrisjallen@.comcast.net> wrote in message
news:OAlu3csFFHA.3972@.TK2MSFTNGP15.phx.gbl...
> Microsoft SQL Server Reporting Services Version 8.00.878.00
>
> SP1 is installed and i get the issue either way. Using a subscription or
> going to the portal and exporting manually. Also on my local machine i am
> using Visual Studio to export and i get the same result.
> --
>
> Thanks,
> Chris Allen
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:e9LDhIsFFHA.1476@.TK2MSFTNGP09.phx.gbl...
>> Please, just to make sure we are not wasting time, go to
>> //yourserver/reportserver and find the version and then post it here.
>> Also, how are you getting the excel export? Are you rendering via URL or
>> Webservices or are you just using the reportmanager portal and selected
>> export?
>> What happens if you export from Visual Studio when doing a preview from
>> there (I assume you have upgraded the visual studio Report Designer as
> well,
>> SP1 needed to be applied at both).
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Chris" <chrisjallen@.comcast.net> wrote in message
>> news:ul8qippFFHA.2824@.tk2msftngp13.phx.gbl...
>> > Yes I am very sure. I installed it not long ago when I ran into other
>> > issues
>> > which forced me to install SP1.
>> >
>> > --
>> >
>> >
>> > Thanks,
>> > Chris Allen
>> > "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> > news:%23NiHrdpFFHA.2736@.TK2MSFTNGP09.phx.gbl...
>> >> Are you sure that your production server is running SP1? What version
> is
>> >> shown when you go to //servername/reportserver ?
>> >>
>> >> SP1 definitely exports as native. Prior to SP1 you could not open the
>> > Excel
>> >> export file in Excel 2000, after SP1 I could. This is because of a
> format
>> >> change.
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >>
>> >>
>> >> "Chris" <chrisjallen@.comcast.net> wrote in message
>> >> news:OB%23bA3hFFHA.3312@.TK2MSFTNGP15.phx.gbl...
>> >> > Here is a cutout of the document to show what's happening. When I
>> >> > select
>> >> > EXCEL and I hit export via the web I get this...
>> >> >
>> >> >
>> >> > "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"
>> >> >
>> >> >
>> >> >
>> >> >
>> >> > Anyone have answers or do i have to just switch solutions? We will
> rely
>> >> > heavily on exporting and if this doesnt work then its back to the
>> > drawing
>> >> > board... Any help would be appreciated. Thanks in advance.
>> >> >
>> >> >
>> >> > Thanks,
>> >> > Chris Allen
>> >> > "Chris" <chrisjallen@.comcast.net> wrote in message
>> >> > news:%23TqEPJTFFHA.3492@.TK2MSFTNGP12.phx.gbl...
>> >> >> Sorry for the half question.. I need to find a way to only export
>> >> >> as
>> >> >> an
>> >> >> excel file. Even when i select it and hit export it spits out HTML
>> >> >> content
>> >> >> in my XLS File. Anyone got any suggestions?
>> >> >>
>> >> >> --
>> >> >>
>> >> >>
>> >> >> Thanks,
>> >> >> Chris Allen
>> >> >> "Chris" <chrisjallen@.comcast.net> wrote in message
>> >> >> news:%23caPmBTFFHA.1524@.TK2MSFTNGP09.phx.gbl...
>> >> >> > I have read previous posts and am still having an issue. Our
>> > production
>> >> >> > server is running SP1 and still exports Excel Files as web
>> >> >> > archive
>> >> > format.
>> >> >> > So the files end up being 10 to 20 MB and not 1 MB. Any help
>> >> >> > would
>> >> >> > be
>> >> >> > appreciated. Thanks in advance
>> >> >> >
>> >> >> > --
>> >> >> >
>> >> >> >
>> >> >> > Thanks,
>> >> >> > Chris Allen
>> >> >> >
>> >> >> >
>> >> >>
>> >> >>
>> >> >
>> >> >
>> >>
>> >>
>> >
>> >
>>
>|||I have created a test report to show you my issue. This is a very small test
but it shows what is going on with my reports. Report 1 is from Visual
Studio using the Export to Excel feature. Report 2 is me taking that file
and opening it. I click Save As. and it shows up as it being saved as a
MHTML document. If i select Excel XLS and resave the same document it comes
out as 375K and not 3MB. Any suggestions?
If you wanna see what i see just open the TestSizeReport.xls in Excel and
hit save as to see it show MHTML as the save as filetype. For some reason it
places the name of the file in Quotes and forces it to use the extension
XLS. I am using Office XP Professional also if your wondering.
Thanks in advance for any help.
Thanks,
Chris Allen
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:uTZGrItFFHA.560@.TK2MSFTNGP15.phx.gbl...
> Well, you definitely have SP1. Could you take a small report, export it as
> Excel and include it with a posting.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Chris" <chrisjallen@.comcast.net> wrote in message
> news:OAlu3csFFHA.3972@.TK2MSFTNGP15.phx.gbl...
> > Microsoft SQL Server Reporting Services Version 8.00.878.00
> >
> >
> > SP1 is installed and i get the issue either way. Using a subscription or
> > going to the portal and exporting manually. Also on my local machine i
am
> > using Visual Studio to export and i get the same result.
> >
> > --
> >
> >
> > Thanks,
> > Chris Allen
> > "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> > news:e9LDhIsFFHA.1476@.TK2MSFTNGP09.phx.gbl...
> >> Please, just to make sure we are not wasting time, go to
> >> //yourserver/reportserver and find the version and then post it here.
> >>
> >> Also, how are you getting the excel export? Are you rendering via URL
or
> >> Webservices or are you just using the reportmanager portal and selected
> >> export?
> >>
> >> What happens if you export from Visual Studio when doing a preview from
> >> there (I assume you have upgraded the visual studio Report Designer as
> > well,
> >> SP1 needed to be applied at both).
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >>
> >>
> >> "Chris" <chrisjallen@.comcast.net> wrote in message
> >> news:ul8qippFFHA.2824@.tk2msftngp13.phx.gbl...
> >> > Yes I am very sure. I installed it not long ago when I ran into other
> >> > issues
> >> > which forced me to install SP1.
> >> >
> >> > --
> >> >
> >> >
> >> > Thanks,
> >> > Chris Allen
> >> > "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> >> > news:%23NiHrdpFFHA.2736@.TK2MSFTNGP09.phx.gbl...
> >> >> Are you sure that your production server is running SP1? What
version
> > is
> >> >> shown when you go to //servername/reportserver ?
> >> >>
> >> >> SP1 definitely exports as native. Prior to SP1 you could not open
the
> >> > Excel
> >> >> export file in Excel 2000, after SP1 I could. This is because of a
> > format
> >> >> change.
> >> >>
> >> >>
> >> >> --
> >> >> Bruce Loehle-Conger
> >> >> MVP SQL Server Reporting Services
> >> >>
> >> >>
> >> >>
> >> >> "Chris" <chrisjallen@.comcast.net> wrote in message
> >> >> news:OB%23bA3hFFHA.3312@.TK2MSFTNGP15.phx.gbl...
> >> >> > Here is a cutout of the document to show what's happening. When I
> >> >> > select
> >> >> > EXCEL and I hit export via the web I get this...
> >> >> >
> >> >> >
> >> >> > "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"
> >> >> >
> >> >> >
> >> >> >
> >> >> >
> >> >> > Anyone have answers or do i have to just switch solutions? We will
> > rely
> >> >> > heavily on exporting and if this doesnt work then its back to the
> >> > drawing
> >> >> > board... Any help would be appreciated. Thanks in advance.
> >> >> >
> >> >> >
> >> >> > Thanks,
> >> >> > Chris Allen
> >> >> > "Chris" <chrisjallen@.comcast.net> wrote in message
> >> >> > news:%23TqEPJTFFHA.3492@.TK2MSFTNGP12.phx.gbl...
> >> >> >> Sorry for the half question.. I need to find a way to only export
> >> >> >> as
> >> >> >> an
> >> >> >> excel file. Even when i select it and hit export it spits out
HTML
> >> >> >> content
> >> >> >> in my XLS File. Anyone got any suggestions?
> >> >> >>
> >> >> >> --
> >> >> >>
> >> >> >>
> >> >> >> Thanks,
> >> >> >> Chris Allen
> >> >> >> "Chris" <chrisjallen@.comcast.net> wrote in message
> >> >> >> news:%23caPmBTFFHA.1524@.TK2MSFTNGP09.phx.gbl...
> >> >> >> > I have read previous posts and am still having an issue. Our
> >> > production
> >> >> >> > server is running SP1 and still exports Excel Files as web
> >> >> >> > archive
> >> >> > format.
> >> >> >> > So the files end up being 10 to 20 MB and not 1 MB. Any help
> >> >> >> > would
> >> >> >> > be
> >> >> >> > appreciated. Thanks in advance
> >> >> >> >
> >> >> >> > --
> >> >> >> >
> >> >> >> >
> >> >> >> > Thanks,
> >> >> >> > Chris Allen
> >> >> >> >
> >> >> >> >
> >> >> >>
> >> >> >>
> >> >> >
> >> >> >
> >> >>
> >> >>
> >> >
> >> >
> >>
> >>
> >
> >
>|||MS newsgroup would not allow me to upload the 3 MB file. Sorry
--
Thanks,
Chris Allen
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:uTZGrItFFHA.560@.TK2MSFTNGP15.phx.gbl...
> Well, you definitely have SP1. Could you take a small report, export it as
> Excel and include it with a posting.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Chris" <chrisjallen@.comcast.net> wrote in message
> news:OAlu3csFFHA.3972@.TK2MSFTNGP15.phx.gbl...
> > Microsoft SQL Server Reporting Services Version 8.00.878.00
> >
> >
> > SP1 is installed and i get the issue either way. Using a subscription or
> > going to the portal and exporting manually. Also on my local machine i
am
> > using Visual Studio to export and i get the same result.
> >
> > --
> >
> >
> > Thanks,
> > Chris Allen
> > "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> > news:e9LDhIsFFHA.1476@.TK2MSFTNGP09.phx.gbl...
> >> Please, just to make sure we are not wasting time, go to
> >> //yourserver/reportserver and find the version and then post it here.
> >>
> >> Also, how are you getting the excel export? Are you rendering via URL
or
> >> Webservices or are you just using the reportmanager portal and selected
> >> export?
> >>
> >> What happens if you export from Visual Studio when doing a preview from
> >> there (I assume you have upgraded the visual studio Report Designer as
> > well,
> >> SP1 needed to be applied at both).
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >>
> >>
> >> "Chris" <chrisjallen@.comcast.net> wrote in message
> >> news:ul8qippFFHA.2824@.tk2msftngp13.phx.gbl...
> >> > Yes I am very sure. I installed it not long ago when I ran into other
> >> > issues
> >> > which forced me to install SP1.
> >> >
> >> > --
> >> >
> >> >
> >> > Thanks,
> >> > Chris Allen
> >> > "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> >> > news:%23NiHrdpFFHA.2736@.TK2MSFTNGP09.phx.gbl...
> >> >> Are you sure that your production server is running SP1? What
version
> > is
> >> >> shown when you go to //servername/reportserver ?
> >> >>
> >> >> SP1 definitely exports as native. Prior to SP1 you could not open
the
> >> > Excel
> >> >> export file in Excel 2000, after SP1 I could. This is because of a
> > format
> >> >> change.
> >> >>
> >> >>
> >> >> --
> >> >> Bruce Loehle-Conger
> >> >> MVP SQL Server Reporting Services
> >> >>
> >> >>
> >> >>
> >> >> "Chris" <chrisjallen@.comcast.net> wrote in message
> >> >> news:OB%23bA3hFFHA.3312@.TK2MSFTNGP15.phx.gbl...
> >> >> > Here is a cutout of the document to show what's happening. When I
> >> >> > select
> >> >> > EXCEL and I hit export via the web I get this...
> >> >> >
> >> >> >
> >> >> > "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"
> >> >> >
> >> >> >
> >> >> >
> >> >> >
> >> >> > Anyone have answers or do i have to just switch solutions? We will
> > rely
> >> >> > heavily on exporting and if this doesnt work then its back to the
> >> > drawing
> >> >> > board... Any help would be appreciated. Thanks in advance.
> >> >> >
> >> >> >
> >> >> > Thanks,
> >> >> > Chris Allen
> >> >> > "Chris" <chrisjallen@.comcast.net> wrote in message
> >> >> > news:%23TqEPJTFFHA.3492@.TK2MSFTNGP12.phx.gbl...
> >> >> >> Sorry for the half question.. I need to find a way to only export
> >> >> >> as
> >> >> >> an
> >> >> >> excel file. Even when i select it and hit export it spits out
HTML
> >> >> >> content
> >> >> >> in my XLS File. Anyone got any suggestions?
> >> >> >>
> >> >> >> --
> >> >> >>
> >> >> >>
> >> >> >> Thanks,
> >> >> >> Chris Allen
> >> >> >> "Chris" <chrisjallen@.comcast.net> wrote in message
> >> >> >> news:%23caPmBTFFHA.1524@.TK2MSFTNGP09.phx.gbl...
> >> >> >> > I have read previous posts and am still having an issue. Our
> >> > production
> >> >> >> > server is running SP1 and still exports Excel Files as web
> >> >> >> > archive
> >> >> > format.
> >> >> >> > So the files end up being 10 to 20 MB and not 1 MB. Any help
> >> >> >> > would
> >> >> >> > be
> >> >> >> > appreciated. Thanks in advance
> >> >> >> >
> >> >> >> > --
> >> >> >> >
> >> >> >> >
> >> >> >> > Thanks,
> >> >> >> > Chris Allen
> >> >> >> >
> >> >> >> >
> >> >> >>
> >> >> >>
> >> >> >
> >> >> >
> >> >>
> >> >>
> >> >
> >> >
> >>
> >>
> >
> >
>|||Just email it to me. Take out the nospam from the email address.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Chris" <chrisjallen@.comcast.net> wrote in message
news:%23CqZR8vFFHA.3608@.TK2MSFTNGP14.phx.gbl...
> MS newsgroup would not allow me to upload the 3 MB file. Sorry
> --
>
> Thanks,
> Chris Allen
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:uTZGrItFFHA.560@.TK2MSFTNGP15.phx.gbl...
>> Well, you definitely have SP1. Could you take a small report, export it
>> as
>> Excel and include it with a posting.
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Chris" <chrisjallen@.comcast.net> wrote in message
>> news:OAlu3csFFHA.3972@.TK2MSFTNGP15.phx.gbl...
>> > Microsoft SQL Server Reporting Services Version 8.00.878.00
>> >
>> >
>> > SP1 is installed and i get the issue either way. Using a subscription
>> > or
>> > going to the portal and exporting manually. Also on my local machine i
> am
>> > using Visual Studio to export and i get the same result.
>> >
>> > --
>> >
>> >
>> > Thanks,
>> > Chris Allen
>> > "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> > news:e9LDhIsFFHA.1476@.TK2MSFTNGP09.phx.gbl...
>> >> Please, just to make sure we are not wasting time, go to
>> >> //yourserver/reportserver and find the version and then post it here.
>> >>
>> >> Also, how are you getting the excel export? Are you rendering via URL
> or
>> >> Webservices or are you just using the reportmanager portal and
>> >> selected
>> >> export?
>> >>
>> >> What happens if you export from Visual Studio when doing a preview
>> >> from
>> >> there (I assume you have upgraded the visual studio Report Designer as
>> > well,
>> >> SP1 needed to be applied at both).
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >>
>> >>
>> >> "Chris" <chrisjallen@.comcast.net> wrote in message
>> >> news:ul8qippFFHA.2824@.tk2msftngp13.phx.gbl...
>> >> > Yes I am very sure. I installed it not long ago when I ran into
>> >> > other
>> >> > issues
>> >> > which forced me to install SP1.
>> >> >
>> >> > --
>> >> >
>> >> >
>> >> > Thanks,
>> >> > Chris Allen
>> >> > "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> >> > news:%23NiHrdpFFHA.2736@.TK2MSFTNGP09.phx.gbl...
>> >> >> Are you sure that your production server is running SP1? What
> version
>> > is
>> >> >> shown when you go to //servername/reportserver ?
>> >> >>
>> >> >> SP1 definitely exports as native. Prior to SP1 you could not open
> the
>> >> > Excel
>> >> >> export file in Excel 2000, after SP1 I could. This is because of a
>> > format
>> >> >> change.
>> >> >>
>> >> >>
>> >> >> --
>> >> >> Bruce Loehle-Conger
>> >> >> MVP SQL Server Reporting Services
>> >> >>
>> >> >>
>> >> >>
>> >> >> "Chris" <chrisjallen@.comcast.net> wrote in message
>> >> >> news:OB%23bA3hFFHA.3312@.TK2MSFTNGP15.phx.gbl...
>> >> >> > Here is a cutout of the document to show what's happening. When I
>> >> >> > select
>> >> >> > EXCEL and I hit export via the web I get this...
>> >> >> >
>> >> >> >
>> >> >> > "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"
>> >> >> >
>> >> >> >
>> >> >> >
>> >> >> >
>> >> >> > Anyone have answers or do i have to just switch solutions? We
>> >> >> > will
>> > rely
>> >> >> > heavily on exporting and if this doesnt work then its back to the
>> >> > drawing
>> >> >> > board... Any help would be appreciated. Thanks in advance.
>> >> >> >
>> >> >> >
>> >> >> > Thanks,
>> >> >> > Chris Allen
>> >> >> > "Chris" <chrisjallen@.comcast.net> wrote in message
>> >> >> > news:%23TqEPJTFFHA.3492@.TK2MSFTNGP12.phx.gbl...
>> >> >> >> Sorry for the half question.. I need to find a way to only
>> >> >> >> export
>> >> >> >> as
>> >> >> >> an
>> >> >> >> excel file. Even when i select it and hit export it spits out
> HTML
>> >> >> >> content
>> >> >> >> in my XLS File. Anyone got any suggestions?
>> >> >> >>
>> >> >> >> --
>> >> >> >>
>> >> >> >>
>> >> >> >> Thanks,
>> >> >> >> Chris Allen
>> >> >> >> "Chris" <chrisjallen@.comcast.net> wrote in message
>> >> >> >> news:%23caPmBTFFHA.1524@.TK2MSFTNGP09.phx.gbl...
>> >> >> >> > I have read previous posts and am still having an issue. Our
>> >> > production
>> >> >> >> > server is running SP1 and still exports Excel Files as web
>> >> >> >> > archive
>> >> >> > format.
>> >> >> >> > So the files end up being 10 to 20 MB and not 1 MB. Any help
>> >> >> >> > would
>> >> >> >> > be
>> >> >> >> > appreciated. Thanks in advance
>> >> >> >> >
>> >> >> >> > --
>> >> >> >> >
>> >> >> >> >
>> >> >> >> > Thanks,
>> >> >> >> > Chris Allen
>> >> >> >> >
>> >> >> >> >
>> >> >> >>
>> >> >> >>
>> >> >> >
>> >> >> >
>> >> >>
>> >> >>
>> >> >
>> >> >
>> >>
>> >>
>> >
>> >
>>
>|||With the report you emailed me I see the same thing you do, it is not in
Excel format. However, when I export a report of mine it is in Excel format
and it is significantly smaller than what you are seeing. I did a 15 page
report and it was 700K. A single page report was 18K. When I open it in
Excel and do a save as it says Excel workbook. Again, what I would expect
but not what I see with the report you sent me.
When you export you should end up with IE with the URL that performed the
export. Mine looked like this:
http://cgincin2/ReportServer?%2fInventory%2fBy+WSP+Summary&RegulatedStatus=Y&rs%3aCommand=Render&rs%3AFormat=EXCEL
What does yours look like?
Also, do you have an old version of Excel around (Excel 2000, Excel 97). It
seems to me that for whatever reason that maybe you are still getting Excel
in the old format (pre-SP1), not the native format. If so, you would not be
able to open it up in Excel 2000 or 97.
If you have the same type of URL as I show above then my suggestion is to
re-apply the SP1 upgrade. Not sure how it would happen and I have never seen
it but something is just not right with your installation (assuming, as I
said, that you have the same type of URL as I do).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:uNJOMo4FFHA.1260@.TK2MSFTNGP12.phx.gbl...
> Just email it to me. Take out the nospam from the email address.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Chris" <chrisjallen@.comcast.net> wrote in message
> news:%23CqZR8vFFHA.3608@.TK2MSFTNGP14.phx.gbl...
> > MS newsgroup would not allow me to upload the 3 MB file. Sorry
> >
> > --
> >
> >
> > Thanks,
> > Chris Allen
> > "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> > news:uTZGrItFFHA.560@.TK2MSFTNGP15.phx.gbl...
> >> Well, you definitely have SP1. Could you take a small report, export it
> >> as
> >> Excel and include it with a posting.
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >>
> >> "Chris" <chrisjallen@.comcast.net> wrote in message
> >> news:OAlu3csFFHA.3972@.TK2MSFTNGP15.phx.gbl...
> >> > Microsoft SQL Server Reporting Services Version 8.00.878.00
> >> >
> >> >
> >> > SP1 is installed and i get the issue either way. Using a subscription
> >> > or
> >> > going to the portal and exporting manually. Also on my local machine
i
> > am
> >> > using Visual Studio to export and i get the same result.
> >> >
> >> > --
> >> >
> >> >
> >> > Thanks,
> >> > Chris Allen
> >> > "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> >> > news:e9LDhIsFFHA.1476@.TK2MSFTNGP09.phx.gbl...
> >> >> Please, just to make sure we are not wasting time, go to
> >> >> //yourserver/reportserver and find the version and then post it
here.
> >> >>
> >> >> Also, how are you getting the excel export? Are you rendering via
URL
> > or
> >> >> Webservices or are you just using the reportmanager portal and
> >> >> selected
> >> >> export?
> >> >>
> >> >> What happens if you export from Visual Studio when doing a preview
> >> >> from
> >> >> there (I assume you have upgraded the visual studio Report Designer
as
> >> > well,
> >> >> SP1 needed to be applied at both).
> >> >>
> >> >> --
> >> >> Bruce Loehle-Conger
> >> >> MVP SQL Server Reporting Services
> >> >>
> >> >>
> >> >>
> >> >> "Chris" <chrisjallen@.comcast.net> wrote in message
> >> >> news:ul8qippFFHA.2824@.tk2msftngp13.phx.gbl...
> >> >> > Yes I am very sure. I installed it not long ago when I ran into
> >> >> > other
> >> >> > issues
> >> >> > which forced me to install SP1.
> >> >> >
> >> >> > --
> >> >> >
> >> >> >
> >> >> > Thanks,
> >> >> > Chris Allen
> >> >> > "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> >> >> > news:%23NiHrdpFFHA.2736@.TK2MSFTNGP09.phx.gbl...
> >> >> >> Are you sure that your production server is running SP1? What
> > version
> >> > is
> >> >> >> shown when you go to //servername/reportserver ?
> >> >> >>
> >> >> >> SP1 definitely exports as native. Prior to SP1 you could not open
> > the
> >> >> > Excel
> >> >> >> export file in Excel 2000, after SP1 I could. This is because of
a
> >> > format
> >> >> >> change.
> >> >> >>
> >> >> >>
> >> >> >> --
> >> >> >> Bruce Loehle-Conger
> >> >> >> MVP SQL Server Reporting Services
> >> >> >>
> >> >> >>
> >> >> >>
> >> >> >> "Chris" <chrisjallen@.comcast.net> wrote in message
> >> >> >> news:OB%23bA3hFFHA.3312@.TK2MSFTNGP15.phx.gbl...
> >> >> >> > Here is a cutout of the document to show what's happening. When
I
> >> >> >> > select
> >> >> >> > EXCEL and I hit export via the web I get this...
> >> >> >> >
> >> >> >> >
> >> >> >> > "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"
> >> >> >> >
> >> >> >> >
> >> >> >> >
> >> >> >> >
> >> >> >> > Anyone have answers or do i have to just switch solutions? We
> >> >> >> > will
> >> > rely
> >> >> >> > heavily on exporting and if this doesnt work then its back to
the
> >> >> > drawing
> >> >> >> > board... Any help would be appreciated. Thanks in advance.
> >> >> >> >
> >> >> >> >
> >> >> >> > Thanks,
> >> >> >> > Chris Allen
> >> >> >> > "Chris" <chrisjallen@.comcast.net> wrote in message
> >> >> >> > news:%23TqEPJTFFHA.3492@.TK2MSFTNGP12.phx.gbl...
> >> >> >> >> Sorry for the half question.. I need to find a way to only
> >> >> >> >> export
> >> >> >> >> as
> >> >> >> >> an
> >> >> >> >> excel file. Even when i select it and hit export it spits out
> > HTML
> >> >> >> >> content
> >> >> >> >> in my XLS File. Anyone got any suggestions?
> >> >> >> >>
> >> >> >> >> --
> >> >> >> >>
> >> >> >> >>
> >> >> >> >> Thanks,
> >> >> >> >> Chris Allen
> >> >> >> >> "Chris" <chrisjallen@.comcast.net> wrote in message
> >> >> >> >> news:%23caPmBTFFHA.1524@.TK2MSFTNGP09.phx.gbl...
> >> >> >> >> > I have read previous posts and am still having an issue. Our
> >> >> > production
> >> >> >> >> > server is running SP1 and still exports Excel Files as web
> >> >> >> >> > archive
> >> >> >> > format.
> >> >> >> >> > So the files end up being 10 to 20 MB and not 1 MB. Any help
> >> >> >> >> > would
> >> >> >> >> > be
> >> >> >> >> > appreciated. Thanks in advance
> >> >> >> >> >
> >> >> >> >> > --
> >> >> >> >> >
> >> >> >> >> >
> >> >> >> >> > Thanks,
> >> >> >> >> > Chris Allen
> >> >> >> >> >
> >> >> >> >> >
> >> >> >> >>
> >> >> >> >>
> >> >> >> >
> >> >> >> >
> >> >> >>
> >> >> >>
> >> >> >
> >> >> >
> >> >>
> >> >>
> >> >
> >> >
> >>
> >>
> >
> >
>|||http://ohqsqlrpt01/ReportServer?%2fUsers+Folders%2fOPTIMUS+callenohc%2fMy+Reports%2fTestSizeReport&rs%3aCommand=Render&rs%3AFormat=EXCEL
Running this on my server comes back with a 770K file now with a reapply of
the SP1. But its still an issue because if I open and resave the same
document it is only 400K. We have reports running that come up as 80MB.
Which is definitely too big for our clients to open. There systems lock up
when trying to open them. Even my system which is a IBM T40 Series. 2 Gig of
RAM we/ 1.4 centrino.
Any reason why it would still be larger than normal?
--
Thanks,
Chris Allen
Senior Systems Developer
Optimus Solutions LLC
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:%23JbeTECGFHA.1264@.TK2MSFTNGP12.phx.gbl...
> With the report you emailed me I see the same thing you do, it is not in
> Excel format. However, when I export a report of mine it is in Excel
format
> and it is significantly smaller than what you are seeing. I did a 15 page
> report and it was 700K. A single page report was 18K. When I open it in
> Excel and do a save as it says Excel workbook. Again, what I would expect
> but not what I see with the report you sent me.
> When you export you should end up with IE with the URL that performed the
> export. Mine looked like this:
>
http://cgincin2/ReportServer?%2fInventory%2fBy+WSP+Summary&RegulatedStatus=Y&rs%3aCommand=Render&rs%3AFormat=EXCEL
> What does yours look like?
> Also, do you have an old version of Excel around (Excel 2000, Excel 97).
It
> seems to me that for whatever reason that maybe you are still getting
Excel
> in the old format (pre-SP1), not the native format. If so, you would not
be
> able to open it up in Excel 2000 or 97.
> If you have the same type of URL as I show above then my suggestion is to
> re-apply the SP1 upgrade. Not sure how it would happen and I have never
seen
> it but something is just not right with your installation (assuming, as I
> said, that you have the same type of URL as I do).
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:uNJOMo4FFHA.1260@.TK2MSFTNGP12.phx.gbl...
> > Just email it to me. Take out the nospam from the email address.
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "Chris" <chrisjallen@.comcast.net> wrote in message
> > news:%23CqZR8vFFHA.3608@.TK2MSFTNGP14.phx.gbl...
> > > MS newsgroup would not allow me to upload the 3 MB file. Sorry
> > >
> > > --
> > >
> > >
> > > Thanks,
> > > Chris Allen
> > > "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> > > news:uTZGrItFFHA.560@.TK2MSFTNGP15.phx.gbl...
> > >> Well, you definitely have SP1. Could you take a small report, export
it
> > >> as
> > >> Excel and include it with a posting.
> > >>
> > >> --
> > >> Bruce Loehle-Conger
> > >> MVP SQL Server Reporting Services
> > >>
> > >>
> > >> "Chris" <chrisjallen@.comcast.net> wrote in message
> > >> news:OAlu3csFFHA.3972@.TK2MSFTNGP15.phx.gbl...
> > >> > Microsoft SQL Server Reporting Services Version 8.00.878.00
> > >> >
> > >> >
> > >> > SP1 is installed and i get the issue either way. Using a
subscription
> > >> > or
> > >> > going to the portal and exporting manually. Also on my local
machine
> i
> > > am
> > >> > using Visual Studio to export and i get the same result.
> > >> >
> > >> > --
> > >> >
> > >> >
> > >> > Thanks,
> > >> > Chris Allen
> > >> > "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> > >> > news:e9LDhIsFFHA.1476@.TK2MSFTNGP09.phx.gbl...
> > >> >> Please, just to make sure we are not wasting time, go to
> > >> >> //yourserver/reportserver and find the version and then post it
> here.
> > >> >>
> > >> >> Also, how are you getting the excel export? Are you rendering via
> URL
> > > or
> > >> >> Webservices or are you just using the reportmanager portal and
> > >> >> selected
> > >> >> export?
> > >> >>
> > >> >> What happens if you export from Visual Studio when doing a preview
> > >> >> from
> > >> >> there (I assume you have upgraded the visual studio Report
Designer
> as
> > >> > well,
> > >> >> SP1 needed to be applied at both).
> > >> >>
> > >> >> --
> > >> >> Bruce Loehle-Conger
> > >> >> MVP SQL Server Reporting Services
> > >> >>
> > >> >>
> > >> >>
> > >> >> "Chris" <chrisjallen@.comcast.net> wrote in message
> > >> >> news:ul8qippFFHA.2824@.tk2msftngp13.phx.gbl...
> > >> >> > Yes I am very sure. I installed it not long ago when I ran into
> > >> >> > other
> > >> >> > issues
> > >> >> > which forced me to install SP1.
> > >> >> >
> > >> >> > --
> > >> >> >
> > >> >> >
> > >> >> > Thanks,
> > >> >> > Chris Allen
> > >> >> > "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> > >> >> > news:%23NiHrdpFFHA.2736@.TK2MSFTNGP09.phx.gbl...
> > >> >> >> Are you sure that your production server is running SP1? What
> > > version
> > >> > is
> > >> >> >> shown when you go to //servername/reportserver ?
> > >> >> >>
> > >> >> >> SP1 definitely exports as native. Prior to SP1 you could not
open
> > > the
> > >> >> > Excel
> > >> >> >> export file in Excel 2000, after SP1 I could. This is because
of
> a
> > >> > format
> > >> >> >> change.
> > >> >> >>
> > >> >> >>
> > >> >> >> --
> > >> >> >> Bruce Loehle-Conger
> > >> >> >> MVP SQL Server Reporting Services
> > >> >> >>
> > >> >> >>
> > >> >> >>
> > >> >> >> "Chris" <chrisjallen@.comcast.net> wrote in message
> > >> >> >> news:OB%23bA3hFFHA.3312@.TK2MSFTNGP15.phx.gbl...
> > >> >> >> > Here is a cutout of the document to show what's happening.
When
> I
> > >> >> >> > select
> > >> >> >> > EXCEL and I hit export via the web I get this...
> > >> >> >> >
> > >> >> >> >
> > >> >> >> > "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"
> > >> >> >> >
> > >> >> >> >
> > >> >> >> >
> > >> >> >> >
> > >> >> >> > Anyone have answers or do i have to just switch solutions? We
> > >> >> >> > will
> > >> > rely
> > >> >> >> > heavily on exporting and if this doesnt work then its back to
> the
> > >> >> > drawing
> > >> >> >> > board... Any help would be appreciated. Thanks in advance.
> > >> >> >> >
> > >> >> >> >
> > >> >> >> > Thanks,
> > >> >> >> > Chris Allen
> > >> >> >> > "Chris" <chrisjallen@.comcast.net> wrote in message
> > >> >> >> > news:%23TqEPJTFFHA.3492@.TK2MSFTNGP12.phx.gbl...
> > >> >> >> >> Sorry for the half question.. I need to find a way to only
> > >> >> >> >> export
> > >> >> >> >> as
> > >> >> >> >> an
> > >> >> >> >> excel file. Even when i select it and hit export it spits
out
> > > HTML
> > >> >> >> >> content
> > >> >> >> >> in my XLS File. Anyone got any suggestions?
> > >> >> >> >>
> > >> >> >> >> --
> > >> >> >> >>
> > >> >> >> >>
> > >> >> >> >> Thanks,
> > >> >> >> >> Chris Allen
> > >> >> >> >> "Chris" <chrisjallen@.comcast.net> wrote in message
> > >> >> >> >> news:%23caPmBTFFHA.1524@.TK2MSFTNGP09.phx.gbl...
> > >> >> >> >> > I have read previous posts and am still having an issue.
Our
> > >> >> > production
> > >> >> >> >> > server is running SP1 and still exports Excel Files as web
> > >> >> >> >> > archive
> > >> >> >> > format.
> > >> >> >> >> > So the files end up being 10 to 20 MB and not 1 MB. Any
help
> > >> >> >> >> > would
> > >> >> >> >> > be
> > >> >> >> >> > appreciated. Thanks in advance
> > >> >> >> >> >
> > >> >> >> >> > --
> > >> >> >> >> >
> > >> >> >> >> >
> > >> >> >> >> > Thanks,
> > >> >> >> >> > Chris Allen
> > >> >> >> >> >
> > >> >> >> >> >
> > >> >> >> >>
> > >> >> >> >>
> > >> >> >> >
> > >> >> >> >
> > >> >> >>
> > >> >> >>
> > >> >> >
> > >> >> >
> > >> >>
> > >> >>
> > >> >
> > >> >
> > >>
> > >>
> > >
> > >
> >
> >
>|||Just to clarify. When you open it up now it no longer thinks it is a mime
files does it (when you do a save as). It now recognizes it as a xls file?
If so, then it looks like reapplying sp1 solved the problem.
I don't know about why it gets smaller when you save it. Mine got larger
when I saved it. Could be that yours has many more columns that mine does
and it affects how it creates it, it doesn't create it as efficiently. Just
a guess.
So an 80 MB file would be 40 MB when saved. This is still huge. Do they
really need all that data? I work with process engineers pulling over
process data and usually they can isolate a smaller period of time they are
interested in.
If they are actually number crunching in Excel with this data then my
suggestion is to see how exporting in csv works. What size do you get with
that. I have seen that users of Excel tend to be pretty comfortable opening
up csv files.
One of the things I have seen with RS is that it is very easy to create new
ways for people to get data so previous ways of working (having a report
have everything including the kitchen sink in it) is not necessary.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Chris" <chrisjallen@.comcast.net> wrote in message
news:eDwbHeCGFHA.2756@.TK2MSFTNGP15.phx.gbl...
>
http://ohqsqlrpt01/ReportServer?%2fUsers+Folders%2fOPTIMUS+callenohc%2fMy+Reports%2fTestSizeReport&rs%3aCommand=Render&rs%3AFormat=EXCEL
> Running this on my server comes back with a 770K file now with a reapply
of
> the SP1. But its still an issue because if I open and resave the same
> document it is only 400K. We have reports running that come up as 80MB.
> Which is definitely too big for our clients to open. There systems lock up
> when trying to open them. Even my system which is a IBM T40 Series. 2 Gig
of
> RAM we/ 1.4 centrino.
> Any reason why it would still be larger than normal?
> --
>
> Thanks,
> Chris Allen
> Senior Systems Developer
> Optimus Solutions LLC
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:%23JbeTECGFHA.1264@.TK2MSFTNGP12.phx.gbl...
> > With the report you emailed me I see the same thing you do, it is not in
> > Excel format. However, when I export a report of mine it is in Excel
> format
> > and it is significantly smaller than what you are seeing. I did a 15
page
> > report and it was 700K. A single page report was 18K. When I open it in
> > Excel and do a save as it says Excel workbook. Again, what I would
expect
> > but not what I see with the report you sent me.
> >
> > When you export you should end up with IE with the URL that performed
the
> > export. Mine looked like this:
> >
>
http://cgincin2/ReportServer?%2fInventory%2fBy+WSP+Summary&RegulatedStatus=Y&rs%3aCommand=Render&rs%3AFormat=EXCEL
> >
> > What does yours look like?
> >
> > Also, do you have an old version of Excel around (Excel 2000, Excel 97).
> It
> > seems to me that for whatever reason that maybe you are still getting
> Excel
> > in the old format (pre-SP1), not the native format. If so, you would not
> be
> > able to open it up in Excel 2000 or 97.
> >
> > If you have the same type of URL as I show above then my suggestion is
to
> > re-apply the SP1 upgrade. Not sure how it would happen and I have never
> seen
> > it but something is just not right with your installation (assuming, as
I
> > said, that you have the same type of URL as I do).
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> >
> > "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> > news:uNJOMo4FFHA.1260@.TK2MSFTNGP12.phx.gbl...
> > > Just email it to me. Take out the nospam from the email address.
> > >
> > >
> > > --
> > > Bruce Loehle-Conger
> > > MVP SQL Server Reporting Services
> > >
> > > "Chris" <chrisjallen@.comcast.net> wrote in message
> > > news:%23CqZR8vFFHA.3608@.TK2MSFTNGP14.phx.gbl...
> > > > MS newsgroup would not allow me to upload the 3 MB file. Sorry
> > > >
> > > > --
> > > >
> > > >
> > > > Thanks,
> > > > Chris Allen
> > > > "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> > > > news:uTZGrItFFHA.560@.TK2MSFTNGP15.phx.gbl...
> > > >> Well, you definitely have SP1. Could you take a small report,
export
> it
> > > >> as
> > > >> Excel and include it with a posting.
> > > >>
> > > >> --
> > > >> Bruce Loehle-Conger
> > > >> MVP SQL Server Reporting Services
> > > >>
> > > >>
> > > >> "Chris" <chrisjallen@.comcast.net> wrote in message
> > > >> news:OAlu3csFFHA.3972@.TK2MSFTNGP15.phx.gbl...
> > > >> > Microsoft SQL Server Reporting Services Version 8.00.878.00
> > > >> >
> > > >> >
> > > >> > SP1 is installed and i get the issue either way. Using a
> subscription
> > > >> > or
> > > >> > going to the portal and exporting manually. Also on my local
> machine
> > i
> > > > am
> > > >> > using Visual Studio to export and i get the same result.
> > > >> >
> > > >> > --
> > > >> >
> > > >> >
> > > >> > Thanks,
> > > >> > Chris Allen
> > > >> > "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> > > >> > news:e9LDhIsFFHA.1476@.TK2MSFTNGP09.phx.gbl...
> > > >> >> Please, just to make sure we are not wasting time, go to
> > > >> >> //yourserver/reportserver and find the version and then post it
> > here.
> > > >> >>
> > > >> >> Also, how are you getting the excel export? Are you rendering
via
> > URL
> > > > or
> > > >> >> Webservices or are you just using the reportmanager portal and
> > > >> >> selected
> > > >> >> export?
> > > >> >>
> > > >> >> What happens if you export from Visual Studio when doing a
preview
> > > >> >> from
> > > >> >> there (I assume you have upgraded the visual studio Report
> Designer
> > as
> > > >> > well,
> > > >> >> SP1 needed to be applied at both).
> > > >> >>
> > > >> >> --
> > > >> >> Bruce Loehle-Conger
> > > >> >> MVP SQL Server Reporting Services
> > > >> >>
> > > >> >>
> > > >> >>
> > > >> >> "Chris" <chrisjallen@.comcast.net> wrote in message
> > > >> >> news:ul8qippFFHA.2824@.tk2msftngp13.phx.gbl...
> > > >> >> > Yes I am very sure. I installed it not long ago when I ran
into
> > > >> >> > other
> > > >> >> > issues
> > > >> >> > which forced me to install SP1.
> > > >> >> >
> > > >> >> > --
> > > >> >> >
> > > >> >> >
> > > >> >> > Thanks,
> > > >> >> > Chris Allen
> > > >> >> > "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in
message
> > > >> >> > news:%23NiHrdpFFHA.2736@.TK2MSFTNGP09.phx.gbl...
> > > >> >> >> Are you sure that your production server is running SP1?
What
> > > > version
> > > >> > is
> > > >> >> >> shown when you go to //servername/reportserver ?
> > > >> >> >>
> > > >> >> >> SP1 definitely exports as native. Prior to SP1 you could not
> open
> > > > the
> > > >> >> > Excel
> > > >> >> >> export file in Excel 2000, after SP1 I could. This is because
> of
> > a
> > > >> > format
> > > >> >> >> change.
> > > >> >> >>
> > > >> >> >>
> > > >> >> >> --
> > > >> >> >> Bruce Loehle-Conger
> > > >> >> >> MVP SQL Server Reporting Services
> > > >> >> >>
> > > >> >> >>
> > > >> >> >>
> > > >> >> >> "Chris" <chrisjallen@.comcast.net> wrote in message
> > > >> >> >> news:OB%23bA3hFFHA.3312@.TK2MSFTNGP15.phx.gbl...
> > > >> >> >> > Here is a cutout of the document to show what's happening.
> When
> > I
> > > >> >> >> > select
> > > >> >> >> > EXCEL and I hit export via the web I get this...
> > > >> >> >> >
> > > >> >> >> >
> > > >> >> >> > "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"
> > > >> >> >> >
> > > >> >> >> >
> > > >> >> >> >
> > > >> >> >> >
> > > >> >> >> > Anyone have answers or do i have to just switch solutions?
We
> > > >> >> >> > will
> > > >> > rely
> > > >> >> >> > heavily on exporting and if this doesnt work then its back
to
> > the
> > > >> >> > drawing
> > > >> >> >> > board... Any help would be appreciated. Thanks in advance.
> > > >> >> >> >
> > > >> >> >> >
> > > >> >> >> > Thanks,
> > > >> >> >> > Chris Allen
> > > >> >> >> > "Chris" <chrisjallen@.comcast.net> wrote in message
> > > >> >> >> > news:%23TqEPJTFFHA.3492@.TK2MSFTNGP12.phx.gbl...
> > > >> >> >> >> Sorry for the half question.. I need to find a way to only
> > > >> >> >> >> export
> > > >> >> >> >> as
> > > >> >> >> >> an
> > > >> >> >> >> excel file. Even when i select it and hit export it spits
> out
> > > > HTML
> > > >> >> >> >> content
> > > >> >> >> >> in my XLS File. Anyone got any suggestions?
> > > >> >> >> >>
> > > >> >> >> >> --
> > > >> >> >> >>
> > > >> >> >> >>
> > > >> >> >> >> Thanks,
> > > >> >> >> >> Chris Allen
> > > >> >> >> >> "Chris" <chrisjallen@.comcast.net> wrote in message
> > > >> >> >> >> news:%23caPmBTFFHA.1524@.TK2MSFTNGP09.phx.gbl...
> > > >> >> >> >> > I have read previous posts and am still having an issue.
> Our
> > > >> >> > production
> > > >> >> >> >> > server is running SP1 and still exports Excel Files as
web
> > > >> >> >> >> > archive
> > > >> >> >> > format.
> > > >> >> >> >> > So the files end up being 10 to 20 MB and not 1 MB. Any
> help
> > > >> >> >> >> > would
> > > >> >> >> >> > be
> > > >> >> >> >> > appreciated. Thanks in advance
> > > >> >> >> >> >
> > > >> >> >> >> > --
> > > >> >> >> >> >
> > > >> >> >> >> >
> > > >> >> >> >> > Thanks,
> > > >> >> >> >> > Chris Allen
> > > >> >> >> >> >
> > > >> >> >> >> >
> > > >> >> >> >>
> > > >> >> >> >>
> > > >> >> >> >
> > > >> >> >> >
> > > >> >> >>
> > > >> >> >>
> > > >> >> >
> > > >> >> >
> > > >> >>
> > > >> >>
> > > >> >
> > > >> >
> > > >>
> > > >>
> > > >
> > > >
> > >
> > >
> >
> >
>|||The report I am working with is an inventory report which shows all
inventory for a specific time. we do filter it based on product line but
this is the main report for the managers which cannot be filtered anymore.
--
Thanks,
Chris Allen
Senior Systems Developer
Optimus Solutions LLC
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:eBlLT7CGFHA.2296@.TK2MSFTNGP15.phx.gbl...
> Just to clarify. When you open it up now it no longer thinks it is a mime
> files does it (when you do a save as). It now recognizes it as a xls file?
> If so, then it looks like reapplying sp1 solved the problem.
> I don't know about why it gets smaller when you save it. Mine got larger
> when I saved it. Could be that yours has many more columns that mine does
> and it affects how it creates it, it doesn't create it as efficiently.
Just
> a guess.
> So an 80 MB file would be 40 MB when saved. This is still huge. Do they
> really need all that data? I work with process engineers pulling over
> process data and usually they can isolate a smaller period of time they
are
> interested in.
> If they are actually number crunching in Excel with this data then my
> suggestion is to see how exporting in csv works. What size do you get with
> that. I have seen that users of Excel tend to be pretty comfortable
opening
> up csv files.
> One of the things I have seen with RS is that it is very easy to create
new
> ways for people to get data so previous ways of working (having a report
> have everything including the kitchen sink in it) is not necessary.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Chris" <chrisjallen@.comcast.net> wrote in message
> news:eDwbHeCGFHA.2756@.TK2MSFTNGP15.phx.gbl...
> >
>
http://ohqsqlrpt01/ReportServer?%2fUsers+Folders%2fOPTIMUS+callenohc%2fMy+Reports%2fTestSizeReport&rs%3aCommand=Render&rs%3AFormat=EXCEL
> >
> > Running this on my server comes back with a 770K file now with a reapply
> of
> > the SP1. But its still an issue because if I open and resave the same
> > document it is only 400K. We have reports running that come up as 80MB.
> > Which is definitely too big for our clients to open. There systems lock
up
> > when trying to open them. Even my system which is a IBM T40 Series. 2
Gig
> of
> > RAM we/ 1.4 centrino.
> >
> > Any reason why it would still be larger than normal?
> >
> > --
> >
> >
> > Thanks,
> > Chris Allen
> > Senior Systems Developer
> > Optimus Solutions LLC
> >
> >
> >
> > "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> > news:%23JbeTECGFHA.1264@.TK2MSFTNGP12.phx.gbl...
> > > With the report you emailed me I see the same thing you do, it is not
in
> > > Excel format. However, when I export a report of mine it is in Excel
> > format
> > > and it is significantly smaller than what you are seeing. I did a 15
> page
> > > report and it was 700K. A single page report was 18K. When I open it
in
> > > Excel and do a save as it says Excel workbook. Again, what I would
> expect
> > > but not what I see with the report you sent me.
> > >
> > > When you export you should end up with IE with the URL that performed
> the
> > > export. Mine looked like this:
> > >
> >
>
http://cgincin2/ReportServer?%2fInventory%2fBy+WSP+Summary&RegulatedStatus=Y&rs%3aCommand=Render&rs%3AFormat=EXCEL
> > >
> > > What does yours look like?
> > >
> > > Also, do you have an old version of Excel around (Excel 2000, Excel
97).
> > It
> > > seems to me that for whatever reason that maybe you are still getting
> > Excel
> > > in the old format (pre-SP1), not the native format. If so, you would
not
> > be
> > > able to open it up in Excel 2000 or 97.
> > >
> > > If you have the same type of URL as I show above then my suggestion is
> to
> > > re-apply the SP1 upgrade. Not sure how it would happen and I have
never
> > seen
> > > it but something is just not right with your installation (assuming,
as
> I
> > > said, that you have the same type of URL as I do).
> > >
> > >
> > > --
> > > Bruce Loehle-Conger
> > > MVP SQL Server Reporting Services
> > >
> > >
> > > "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> > > news:uNJOMo4FFHA.1260@.TK2MSFTNGP12.phx.gbl...
> > > > Just email it to me. Take out the nospam from the email address.
> > > >
> > > >
> > > > --
> > > > Bruce Loehle-Conger
> > > > MVP SQL Server Reporting Services
> > > >
> > > > "Chris" <chrisjallen@.comcast.net> wrote in message
> > > > news:%23CqZR8vFFHA.3608@.TK2MSFTNGP14.phx.gbl...
> > > > > MS newsgroup would not allow me to upload the 3 MB file. Sorry
> > > > >
> > > > > --
> > > > >
> > > > >
> > > > > Thanks,
> > > > > Chris Allen
> > > > > "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> > > > > news:uTZGrItFFHA.560@.TK2MSFTNGP15.phx.gbl...
> > > > >> Well, you definitely have SP1. Could you take a small report,
> export
> > it
> > > > >> as
> > > > >> Excel and include it with a posting.
> > > > >>
> > > > >> --
> > > > >> Bruce Loehle-Conger
> > > > >> MVP SQL Server Reporting Services
> > > > >>
> > > > >>
> > > > >> "Chris" <chrisjallen@.comcast.net> wrote in message
> > > > >> news:OAlu3csFFHA.3972@.TK2MSFTNGP15.phx.gbl...
> > > > >> > Microsoft SQL Server Reporting Services Version 8.00.878.00
> > > > >> >
> > > > >> >
> > > > >> > SP1 is installed and i get the issue either way. Using a
> > subscription
> > > > >> > or
> > > > >> > going to the portal and exporting manually. Also on my local
> > machine
> > > i
> > > > > am
> > > > >> > using Visual Studio to export and i get the same result.
> > > > >> >
> > > > >> > --
> > > > >> >
> > > > >> >
> > > > >> > Thanks,
> > > > >> > Chris Allen
> > > > >> > "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> > > > >> > news:e9LDhIsFFHA.1476@.TK2MSFTNGP09.phx.gbl...
> > > > >> >> Please, just to make sure we are not wasting time, go to
> > > > >> >> //yourserver/reportserver and find the version and then post
it
> > > here.
> > > > >> >>
> > > > >> >> Also, how are you getting the excel export? Are you rendering
> via
> > > URL
> > > > > or
> > > > >> >> Webservices or are you just using the reportmanager portal and
> > > > >> >> selected
> > > > >> >> export?
> > > > >> >>
> > > > >> >> What happens if you export from Visual Studio when doing a
> preview
> > > > >> >> from
> > > > >> >> there (I assume you have upgraded the visual studio Report
> > Designer
> > > as
> > > > >> > well,
> > > > >> >> SP1 needed to be applied at both).
> > > > >> >>
> > > > >> >> --
> > > > >> >> Bruce Loehle-Conger
> > > > >> >> MVP SQL Server Reporting Services
> > > > >> >>
> > > > >> >>
> > > > >> >>
> > > > >> >> "Chris" <chrisjallen@.comcast.net> wrote in message
> > > > >> >> news:ul8qippFFHA.2824@.tk2msftngp13.phx.gbl...
> > > > >> >> > Yes I am very sure. I installed it not long ago when I ran
> into
> > > > >> >> > other
> > > > >> >> > issues
> > > > >> >> > which forced me to install SP1.
> > > > >> >> >
> > > > >> >> > --
> > > > >> >> >
> > > > >> >> >
> > > > >> >> > Thanks,
> > > > >> >> > Chris Allen
> > > > >> >> > "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in
> message
> > > > >> >> > news:%23NiHrdpFFHA.2736@.TK2MSFTNGP09.phx.gbl...
> > > > >> >> >> Are you sure that your production server is running SP1?
> What
> > > > > version
> > > > >> > is
> > > > >> >> >> shown when you go to //servername/reportserver ?
> > > > >> >> >>
> > > > >> >> >> SP1 definitely exports as native. Prior to SP1 you could
not
> > open
> > > > > the
> > > > >> >> > Excel
> > > > >> >> >> export file in Excel 2000, after SP1 I could. This is
because
> > of
> > > a
> > > > >> > format
> > > > >> >> >> change.
> > > > >> >> >>
> > > > >> >> >>
> > > > >> >> >> --
> > > > >> >> >> Bruce Loehle-Conger
> > > > >> >> >> MVP SQL Server Reporting Services
> > > > >> >> >>
> > > > >> >> >>
> > > > >> >> >>
> > > > >> >> >> "Chris" <chrisjallen@.comcast.net> wrote in message
> > > > >> >> >> news:OB%23bA3hFFHA.3312@.TK2MSFTNGP15.phx.gbl...
> > > > >> >> >> > Here is a cutout of the document to show what's
happening.
> > When
> > > I
> > > > >> >> >> > select
> > > > >> >> >> > EXCEL and I hit export via the web I get this...
> > > > >> >> >> >
> > > > >> >> >> >
> > > > >> >> >> > "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"
> > > > >> >> >> >
> > > > >> >> >> >
> > > > >> >> >> >
> > > > >> >> >> >
> > > > >> >> >> > Anyone have answers or do i have to just switch
solutions?
> We
> > > > >> >> >> > will
> > > > >> > rely
> > > > >> >> >> > heavily on exporting and if this doesnt work then its
back
> to
> > > the
> > > > >> >> > drawing
> > > > >> >> >> > board... Any help would be appreciated. Thanks in
advance.
> > > > >> >> >> >
> > > > >> >> >> >
> > > > >> >> >> > Thanks,
> > > > >> >> >> > Chris Allen
> > > > >> >> >> > "Chris" <chrisjallen@.comcast.net> wrote in message
> > > > >> >> >> > news:%23TqEPJTFFHA.3492@.TK2MSFTNGP12.phx.gbl...
> > > > >> >> >> >> Sorry for the half question.. I need to find a way to
only
> > > > >> >> >> >> export
> > > > >> >> >> >> as
> > > > >> >> >> >> an
> > > > >> >> >> >> excel file. Even when i select it and hit export it
spits
> > out
> > > > > HTML
> > > > >> >> >> >> content
> > > > >> >> >> >> in my XLS File. Anyone got any suggestions?
> > > > >> >> >> >>
> > > > >> >> >> >> --
> > > > >> >> >> >>
> > > > >> >> >> >>
> > > > >> >> >> >> Thanks,
> > > > >> >> >> >> Chris Allen
> > > > >> >> >> >> "Chris" <chrisjallen@.comcast.net> wrote in message
> > > > >> >> >> >> news:%23caPmBTFFHA.1524@.TK2MSFTNGP09.phx.gbl...
> > > > >> >> >> >> > I have read previous posts and am still having an
issue.
> > Our
> > > > >> >> > production
> > > > >> >> >> >> > server is running SP1 and still exports Excel Files as
> web
> > > > >> >> >> >> > archive
> > > > >> >> >> > format.
> > > > >> >> >> >> > So the files end up being 10 to 20 MB and not 1 MB.
Any
> > help
> > > > >> >> >> >> > would
> > > > >> >> >> >> > be
> > > > >> >> >> >> > appreciated. Thanks in advance
> > > > >> >> >> >> >
> > > > >> >> >> >> > --
> > > > >> >> >> >> >
> > > > >> >> >> >> >
> > > > >> >> >> >> > Thanks,
> > > > >> >> >> >> > Chris Allen
> > > > >> >> >> >> >
> > > > >> >> >> >> >
> > > > >> >> >> >>
> > > > >> >> >> >>
> > > > >> >> >> >
> > > > >> >> >> >
> > > > >> >> >>
> > > > >> >> >>
> > > > >> >> >
> > > > >> >> >
> > > > >> >>
> > > > >> >>
> > > > >> >
> > > > >> >
> > > > >>
> > > > >>
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>|||Again, it depends on what they are doing with it. Usually managers are
interested in summaries and then want to drill into data. The drill through
capabilities are great for this. On demand reporting (versus batching which
is essentially what you are doing here). They might be used to it one way. A
human does not look at thousands of rows of data (which is what you have
with your report). I bet they end up just searching through it to get what
they want. I might have been the only way to do it before but now you can
create reports that are so fast and easy to use that they could do it
differently. As I said, 40 Meg Excel file (which would be the absolute best
you would get even if RS did exactly the same as Excel) is a huge file.
Still, if they have to have it then I suggest seeing how big CSV is. Going
with CSV should also put less strain on RS when it is rendering it. Although
this big is going to be a problem I bet. RS does everything in RAM and
extremely large reports can bring it to its knees. Again, the design
philosophy is to be fast and extremely easy for the end user to get reports
on demand (drill down, drill through, jump to another report etc). I think
that you are going to find it problematic running this report unless you can
run it at off peak times.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Chris" <chrisjallen@.comcast.net> wrote in message
news:e3rpvUDGFHA.3472@.TK2MSFTNGP09.phx.gbl...
> The report I am working with is an inventory report which shows all
> inventory for a specific time. we do filter it based on product line but
> this is the main report for the managers which cannot be filtered anymore.
> --
>
> Thanks,
> Chris Allen
> Senior Systems Developer
> Optimus Solutions LLC
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:eBlLT7CGFHA.2296@.TK2MSFTNGP15.phx.gbl...
> > Just to clarify. When you open it up now it no longer thinks it is a
mime
> > files does it (when you do a save as). It now recognizes it as a xls
file?
> > If so, then it looks like reapplying sp1 solved the problem.
> >
> > I don't know about why it gets smaller when you save it. Mine got larger
> > when I saved it. Could be that yours has many more columns that mine
does
> > and it affects how it creates it, it doesn't create it as efficiently.
> Just
> > a guess.
> >
> > So an 80 MB file would be 40 MB when saved. This is still huge. Do they
> > really need all that data? I work with process engineers pulling over
> > process data and usually they can isolate a smaller period of time they
> are
> > interested in.
> >
> > If they are actually number crunching in Excel with this data then my
> > suggestion is to see how exporting in csv works. What size do you get
with
> > that. I have seen that users of Excel tend to be pretty comfortable
> opening
> > up csv files.
> >
> > One of the things I have seen with RS is that it is very easy to create
> new
> > ways for people to get data so previous ways of working (having a report
> > have everything including the kitchen sink in it) is not necessary.
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> >
> >
> > "Chris" <chrisjallen@.comcast.net> wrote in message
> > news:eDwbHeCGFHA.2756@.TK2MSFTNGP15.phx.gbl...
> > >
> >
>
http://ohqsqlrpt01/ReportServer?%2fUsers+Folders%2fOPTIMUS+callenohc%2fMy+Reports%2fTestSizeReport&rs%3aCommand=Render&rs%3AFormat=EXCEL
> > >
> > > Running this on my server comes back with a 770K file now with a
reapply
> > of
> > > the SP1. But its still an issue because if I open and resave the same
> > > document it is only 400K. We have reports running that come up as
80MB.
> > > Which is definitely too big for our clients to open. There systems
lock
> up
> > > when trying to open them. Even my system which is a IBM T40 Series. 2
> Gig
> > of
> > > RAM we/ 1.4 centrino.
> > >
> > > Any reason why it would still be larger than normal?
> > >
> > > --
> > >
> > >
> > > Thanks,
> > > Chris Allen
> > > Senior Systems Developer
> > > Optimus Solutions LLC
> > >
> > >
> > >
> > > "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> > > news:%23JbeTECGFHA.1264@.TK2MSFTNGP12.phx.gbl...
> > > > With the report you emailed me I see the same thing you do, it is
not
> in
> > > > Excel format. However, when I export a report of mine it is in Excel
> > > format
> > > > and it is significantly smaller than what you are seeing. I did a 15
> > page
> > > > report and it was 700K. A single page report was 18K. When I open it
> in
> > > > Excel and do a save as it says Excel workbook. Again, what I would
> > expect
> > > > but not what I see with the report you sent me.
> > > >
> > > > When you export you should end up with IE with the URL that
performed
> > the
> > > > export. Mine looked like this:
> > > >
> > >
> >
>
http://cgincin2/ReportServer?%2fInventory%2fBy+WSP+Summary&RegulatedStatus=Y&rs%3aCommand=Render&rs%3AFormat=EXCEL
> > > >
> > > > What does yours look like?
> > > >
> > > > Also, do you have an old version of Excel around (Excel 2000, Excel
> 97).
> > > It
> > > > seems to me that for whatever reason that maybe you are still
getting
> > > Excel
> > > > in the old format (pre-SP1), not the native format. If so, you would
> not
> > > be
> > > > able to open it up in Excel 2000 or 97.
> > > >
> > > > If you have the same type of URL as I show above then my suggestion
is
> > to
> > > > re-apply the SP1 upgrade. Not sure how it would happen and I have
> never
> > > seen
> > > > it but something is just not right with your installation (assuming,
> as
> > I
> > > > said, that you have the same type of URL as I do).
> > > >
> > > >
> > > > --
> > > > Bruce Loehle-Conger
> > > > MVP SQL Server Reporting Services
> > > >
> > > >
> > > > "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> > > > news:uNJOMo4FFHA.1260@.TK2MSFTNGP12.phx.gbl...
> > > > > Just email it to me. Take out the nospam from the email address.
> > > > >
> > > > >
> > > > > --
> > > > > Bruce Loehle-Conger
> > > > > MVP SQL Server Reporting Services
> > > > >
> > > > > "Chris" <chrisjallen@.comcast.net> wrote in message
> > > > > news:%23CqZR8vFFHA.3608@.TK2MSFTNGP14.phx.gbl...
> > > > > > MS newsgroup would not allow me to upload the 3 MB file. Sorry
> > > > > >
> > > > > > --
> > > > > >
> > > > > >
> > > > > > Thanks,
> > > > > > Chris Allen
> > > > > > "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> > > > > > news:uTZGrItFFHA.560@.TK2MSFTNGP15.phx.gbl...
> > > > > >> Well, you definitely have SP1. Could you take a small report,
> > export
> > > it
> > > > > >> as
> > > > > >> Excel and include it with a posting.
> > > > > >>
> > > > > >> --
> > > > > >> Bruce Loehle-Conger
> > > > > >> MVP SQL Server Reporting Services
> > > > > >>
> > > > > >>
> > > > > >> "Chris" <chrisjallen@.comcast.net> wrote in message
> > > > > >> news:OAlu3csFFHA.3972@.TK2MSFTNGP15.phx.gbl...
> > > > > >> > Microsoft SQL Server Reporting Services Version 8.00.878.00
> > > > > >> >
> > > > > >> >
> > > > > >> > SP1 is installed and i get the issue either way. Using a
> > > subscription
> > > > > >> > or
> > > > > >> > going to the portal and exporting manually. Also on my local
> > > machine
> > > > i
> > > > > > am
> > > > > >> > using Visual Studio to export and i get the same result.
> > > > > >> >
> > > > > >> > --
> > > > > >> >
> > > > > >> >
> > > > > >> > Thanks,
> > > > > >> > Chris Allen
> > > > > >> > "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in
message
> > > > > >> > news:e9LDhIsFFHA.1476@.TK2MSFTNGP09.phx.gbl...
> > > > > >> >> Please, just to make sure we are not wasting time, go to
> > > > > >> >> //yourserver/reportserver and find the version and then post
> it
> > > > here.
> > > > > >> >>
> > > > > >> >> Also, how are you getting the excel export? Are you
rendering
> > via
> > > > URL
> > > > > > or
> > > > > >> >> Webservices or are you just using the reportmanager portal
and
> > > > > >> >> selected
> > > > > >> >> export?
> > > > > >> >>
> > > > > >> >> What happens if you export from Visual Studio when doing a
> > preview
> > > > > >> >> from
> > > > > >> >> there (I assume you have upgraded the visual studio Report
> > > Designer
> > > > as
> > > > > >> > well,
> > > > > >> >> SP1 needed to be applied at both).
> > > > > >> >>
> > > > > >> >> --
> > > > > >> >> Bruce Loehle-Conger
> > > > > >> >> MVP SQL Server Reporting Services
> > > > > >> >>
> > > > > >> >>
> > > > > >> >>
> > > > > >> >> "Chris" <chrisjallen@.comcast.net> wrote in message
> > > > > >> >> news:ul8qippFFHA.2824@.tk2msftngp13.phx.gbl...
> > > > > >> >> > Yes I am very sure. I installed it not long ago when I ran
> > into
> > > > > >> >> > other
> > > > > >> >> > issues
> > > > > >> >> > which forced me to install SP1.
> > > > > >> >> >
> > > > > >> >> > --
> > > > > >> >> >
> > > > > >> >> >
> > > > > >> >> > Thanks,
> > > > > >> >> > Chris Allen
> > > > > >> >> > "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in
> > message
> > > > > >> >> > news:%23NiHrdpFFHA.2736@.TK2MSFTNGP09.phx.gbl...
> > > > > >> >> >> Are you sure that your production server is running SP1?
> > What
> > > > > > version
> > > > > >> > is
> > > > > >> >> >> shown when you go to //servername/reportserver ?
> > > > > >> >> >>
> > > > > >> >> >> SP1 definitely exports as native. Prior to SP1 you could
> not
> > > open
> > > > > > the
> > > > > >> >> > Excel
> > > > > >> >> >> export file in Excel 2000, after SP1 I could. This is
> because
> > > of
> > > > a
> > > > > >> > format
> > > > > >> >> >> change.
> > > > > >> >> >>
> > > > > >> >> >>
> > > > > >> >> >> --
> > > > > >> >> >> Bruce Loehle-Conger
> > > > > >> >> >> MVP SQL Server Reporting Services
> > > > > >> >> >>
> > > > > >> >> >>
> > > > > >> >> >>
> > > > > >> >> >> "Chris" <chrisjallen@.comcast.net> wrote in message
> > > > > >> >> >> news:OB%23bA3hFFHA.3312@.TK2MSFTNGP15.phx.gbl...
> > > > > >> >> >> > Here is a cutout of the document to show what's
> happening.
> > > When
> > > > I
> > > > > >> >> >> > select
> > > > > >> >> >> > EXCEL and I hit export via the web I get this...
> > > > > >> >> >> >
> > > > > >> >> >> >
> > > > > >> >> >> > "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"
> > > > > >> >> >> >
> > > > > >> >> >> >
> > > > > >> >> >> >
> > > > > >> >> >> >
> > > > > >> >> >> > Anyone have answers or do i have to just switch
> solutions?
> > We
> > > > > >> >> >> > will
> > > > > >> > rely
> > > > > >> >> >> > heavily on exporting and if this doesnt work then its
> back
> > to
> > > > the
> > > > > >> >> > drawing
> > > > > >> >> >> > board... Any help would be appreciated. Thanks in
> advance.
> > > > > >> >> >> >
> > > > > >> >> >> >
> > > > > >> >> >> > Thanks,
> > > > > >> >> >> > Chris Allen
> > > > > >> >> >> > "Chris" <chrisjallen@.comcast.net> wrote in message
> > > > > >> >> >> > news:%23TqEPJTFFHA.3492@.TK2MSFTNGP12.phx.gbl...
> > > > > >> >> >> >> Sorry for the half question.. I need to find a way to
> only
> > > > > >> >> >> >> export
> > > > > >> >> >> >> as
> > > > > >> >> >> >> an
> > > > > >> >> >> >> excel file. Even when i select it and hit export it
> spits
> > > out
> > > > > > HTML
> > > > > >> >> >> >> content
> > > > > >> >> >> >> in my XLS File. Anyone got any suggestions?
> > > > > >> >> >> >>
> > > > > >> >> >> >> --
> > > > > >> >> >> >>
> > > > > >> >> >> >>
> > > > > >> >> >> >> Thanks,
> > > > > >> >> >> >> Chris Allen
> > > > > >> >> >> >> "Chris" <chrisjallen@.comcast.net> wrote in message
> > > > > >> >> >> >> news:%23caPmBTFFHA.1524@.TK2MSFTNGP09.phx.gbl...
> > > > > >> >> >> >> > I have read previous posts and am still having an
> issue.
> > > Our
> > > > > >> >> > production
> > > > > >> >> >> >> > server is running SP1 and still exports Excel Files
as
> > web
> > > > > >> >> >> >> > archive
> > > > > >> >> >> > format.
> > > > > >> >> >> >> > So the files end up being 10 to 20 MB and not 1 MB.
> Any
> > > help
> > > > > >> >> >> >> > would
> > > > > >> >> >> >> > be
> > > > > >> >> >> >> > appreciated. Thanks in advance
> > > > > >> >> >> >> >
> > > > > >> >> >> >> > --
> > > > > >> >> >> >> >
> > > > > >> >> >> >> >
> > > > > >> >> >> >> > Thanks,
> > > > > >> >> >> >> > Chris Allen
> > > > > >> >> >> >> >
> > > > > >> >> >> >> >
> > > > > >> >> >> >>
> > > > > >> >> >> >>
> > > > > >> >> >> >
> > > > > >> >> >> >
> > > > > >> >> >>
> > > > > >> >> >>
> > > > > >> >> >
> > > > > >> >> >
> > > > > >> >>
> > > > > >> >>
> > > > > >> >
> > > > > >> >
> > > > > >>
> > > > > >>
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>|||We do run this during off hours at night. But we had to stop because of the
large report it was creating that nobody could open. I wonder if there is a
better method. I have tried to export to CSV and even though it is
considerably smaller it proves to be a pain because when you open it up in
Excel it only inserts data in column A. It doesn't break the lines apart
into each column that it should. Trying to make it as user friendly as
possible.
--
Thanks,
Chris Allen
Senior Systems Developer
Optimus Solutions LLC
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:ubF$NtDGFHA.392@.TK2MSFTNGP14.phx.gbl...
> Again, it depends on what they are doing with it. Usually managers are
> interested in summaries and then want to drill into data. The drill
through
> capabilities are great for this. On demand reporting (versus batching
which
> is essentially what you are doing here). They might be used to it one way.
A
> human does not look at thousands of rows of data (which is what you have
> with your report). I bet they end up just searching through it to get what
> they want. I might have been the only way to do it before but now you can
> create reports that are so fast and easy to use that they could do it
> differently. As I said, 40 Meg Excel file (which would be the absolute
best
> you would get even if RS did exactly the same as Excel) is a huge file.
> Still, if they have to have it then I suggest seeing how big CSV is. Going
> with CSV should also put less strain on RS when it is rendering it.
Although
> this big is going to be a problem I bet. RS does everything in RAM and
> extremely large reports can bring it to its knees. Again, the design
> philosophy is to be fast and extremely easy for the end user to get
reports
> on demand (drill down, drill through, jump to another report etc). I think
> that you are going to find it problematic running this report unless you
can
> run it at off peak times.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Chris" <chrisjallen@.comcast.net> wrote in message
> news:e3rpvUDGFHA.3472@.TK2MSFTNGP09.phx.gbl...
> > The report I am working with is an inventory report which shows all
> > inventory for a specific time. we do filter it based on product line but
> > this is the main report for the managers which cannot be filtered
anymore.
> >
> > --
> >
> >
> > Thanks,
> > Chris Allen
> > Senior Systems Developer
> > Optimus Solutions LLC
> >
> >
> >
> > "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> > news:eBlLT7CGFHA.2296@.TK2MSFTNGP15.phx.gbl...
> > > Just to clarify. When you open it up now it no longer thinks it is a
> mime
> > > files does it (when you do a save as). It now recognizes it as a xls
> file?
> > > If so, then it looks like reapplying sp1 solved the problem.
> > >
> > > I don't know about why it gets smaller when you save it. Mine got
larger
> > > when I saved it. Could be that yours has many more columns that mine
> does
> > > and it affects how it creates it, it doesn't create it as efficiently.
> > Just
> > > a guess.
> > >
> > > So an 80 MB file would be 40 MB when saved. This is still huge. Do
they
> > > really need all that data? I work with process engineers pulling over
> > > process data and usually they can isolate a smaller period of time
they
> > are
> > > interested in.
> > >
> > > If they are actually number crunching in Excel with this data then my
> > > suggestion is to see how exporting in csv works. What size do you get
> with
> > > that. I have seen that users of Excel tend to be pretty comfortable
> > opening
> > > up csv files.
> > >
> > > One of the things I have seen with RS is that it is very easy to
create
> > new
> > > ways for people to get data so previous ways of working (having a
report
> > > have everything including the kitchen sink in it) is not necessary.
> > >
> > >
> > > --
> > > Bruce Loehle-Conger
> > > MVP SQL Server Reporting Services
> > >
> > >
> > >
> > > "Chris" <chrisjallen@.comcast.net> wrote in message
> > > news:eDwbHeCGFHA.2756@.TK2MSFTNGP15.phx.gbl...
> > > >
> > >
> >
>
http://ohqsqlrpt01/ReportServer?%2fUsers+Folders%2fOPTIMUS+callenohc%2fMy+Reports%2fTestSizeReport&rs%3aCommand=Render&rs%3AFormat=EXCEL
> > > >
> > > > Running this on my server comes back with a 770K file now with a
> reapply
> > > of
> > > > the SP1. But its still an issue because if I open and resave the
same
> > > > document it is only 400K. We have reports running that come up as
> 80MB.
> > > > Which is definitely too big for our clients to open. There systems
> lock
> > up
> > > > when trying to open them. Even my system which is a IBM T40 Series.
2
> > Gig
> > > of
> > > > RAM we/ 1.4 centrino.
> > > >
> > > > Any reason why it would still be larger than normal?
> > > >
> > > > --
> > > >
> > > >
> > > > Thanks,
> > > > Chris Allen
> > > > Senior Systems Developer
> > > > Optimus Solutions LLC
> > > >
> > > >
> > > >
> > > > "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> > > > news:%23JbeTECGFHA.1264@.TK2MSFTNGP12.phx.gbl...
> > > > > With the report you emailed me I see the same thing you do, it is
> not
> > in
> > > > > Excel format. However, when I export a report of mine it is in
Excel
> > > > format
> > > > > and it is significantly smaller than what you are seeing. I did a
15
> > > page
> > > > > report and it was 700K. A single page report was 18K. When I open
it
> > in
> > > > > Excel and do a save as it says Excel workbook. Again, what I would
> > > expect
> > > > > but not what I see with the report you sent me.
> > > > >
> > > > > When you export you should end up with IE with the URL that
> performed
> > > the
> > > > > export. Mine looked like this:
> > > > >
> > > >
> > >
> >
>
http://cgincin2/ReportServer?%2fInventory%2fBy+WSP+Summary&RegulatedStatus=Y&rs%3aCommand=Render&rs%3AFormat=EXCEL
> > > > >
> > > > > What does yours look like?
> > > > >
> > > > > Also, do you have an old version of Excel around (Excel 2000,
Excel
> > 97).
> > > > It
> > > > > seems to me that for whatever reason that maybe you are still
> getting
> > > > Excel
> > > > > in the old format (pre-SP1), not the native format. If so, you
would
> > not
> > > > be
> > > > > able to open it up in Excel 2000 or 97.
> > > > >
> > > > > If you have the same type of URL as I show above then my
suggestion
> is
> > > to
> > > > > re-apply the SP1 upgrade. Not sure how it would happen and I have
> > never
> > > > seen
> > > > > it but something is just not right with your installation
(assuming,
> > as
> > > I
> > > > > said, that you have the same type of URL as I do).
> > > > >
> > > > >
> > > > > --
> > > > > Bruce Loehle-Conger
> > > > > MVP SQL Server Reporting Services
> > > > >
> > > > >
> > > > > "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> > > > > news:uNJOMo4FFHA.1260@.TK2MSFTNGP12.phx.gbl...
> > > > > > Just email it to me. Take out the nospam from the email address.
> > > > > >
> > > > > >
> > > > > > --
> > > > > > Bruce Loehle-Conger
> > > > > > MVP SQL Server Reporting Services
> > > > > >
> > > > > > "Chris" <chrisjallen@.comcast.net> wrote in message
> > > > > > news:%23CqZR8vFFHA.3608@.TK2MSFTNGP14.phx.gbl...
> > > > > > > MS newsgroup would not allow me to upload the 3 MB file. Sorry
> > > > > > >
> > > > > > > --
> > > > > > >
> > > > > > >
> > > > > > > Thanks,
> > > > > > > Chris Allen
> > > > > > > "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in
message
> > > > > > > news:uTZGrItFFHA.560@.TK2MSFTNGP15.phx.gbl...
> > > > > > >> Well, you definitely have SP1. Could you take a small report,
> > > export
> > > > it
> > > > > > >> as
> > > > > > >> Excel and include it with a posting.
> > > > > > >>
> > > > > > >> --
> > > > > > >> Bruce Loehle-Conger
> > > > > > >> MVP SQL Server Reporting Services
> > > > > > >>
> > > > > > >>
> > > > > > >> "Chris" <chrisjallen@.comcast.net> wrote in message
> > > > > > >> news:OAlu3csFFHA.3972@.TK2MSFTNGP15.phx.gbl...
> > > > > > >> > Microsoft SQL Server Reporting Services Version 8.00.878.00
> > > > > > >> >
> > > > > > >> >
> > > > > > >> > SP1 is installed and i get the issue either way. Using a
> > > > subscription
> > > > > > >> > or
> > > > > > >> > going to the portal and exporting manually. Also on my
local
> > > > machine
> > > > > i
> > > > > > > am
> > > > > > >> > using Visual Studio to export and i get the same result.
> > > > > > >> >
> > > > > > >> > --
> > > > > > >> >
> > > > > > >> >
> > > > > > >> > Thanks,
> > > > > > >> > Chris Allen
> > > > > > >> > "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in
> message
> > > > > > >> > news:e9LDhIsFFHA.1476@.TK2MSFTNGP09.phx.gbl...
> > > > > > >> >> Please, just to make sure we are not wasting time, go to
> > > > > > >> >> //yourserver/reportserver and find the version and then
post
> > it
> > > > > here.
> > > > > > >> >>
> > > > > > >> >> Also, how are you getting the excel export? Are you
> rendering
> > > via
> > > > > URL
> > > > > > > or
> > > > > > >> >> Webservices or are you just using the reportmanager portal
> and
> > > > > > >> >> selected
> > > > > > >> >> export?
> > > > > > >> >>
> > > > > > >> >> What happens if you export from Visual Studio when doing a
> > > preview
> > > > > > >> >> from
> > > > > > >> >> there (I assume you have upgraded the visual studio Report
> > > > Designer
> > > > > as
> > > > > > >> > well,
> > > > > > >> >> SP1 needed to be applied at both).
> > > > > > >> >>
> > > > > > >> >> --
> > > > > > >> >> Bruce Loehle-Conger
> > > > > > >> >> MVP SQL Server Reporting Services
> > > > > > >> >>
> > > > > > >> >>
> > > > > > >> >>
> > > > > > >> >> "Chris" <chrisjallen@.comcast.net> wrote in message
> > > > > > >> >> news:ul8qippFFHA.2824@.tk2msftngp13.phx.gbl...
> > > > > > >> >> > Yes I am very sure. I installed it not long ago when I
ran
> > > into
> > > > > > >> >> > other
> > > > > > >> >> > issues
> > > > > > >> >> > which forced me to install SP1.
> > > > > > >> >> >
> > > > > > >> >> > --
> > > > > > >> >> >
> > > > > > >> >> >
> > > > > > >> >> > Thanks,
> > > > > > >> >> > Chris Allen
> > > > > > >> >> > "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in
> > > message
> > > > > > >> >> > news:%23NiHrdpFFHA.2736@.TK2MSFTNGP09.phx.gbl...
> > > > > > >> >> >> Are you sure that your production server is running
SP1?
> > > What
> > > > > > > version
> > > > > > >> > is
> > > > > > >> >> >> shown when you go to //servername/reportserver ?
> > > > > > >> >> >>
> > > > > > >> >> >> SP1 definitely exports as native. Prior to SP1 you
could
> > not
> > > > open
> > > > > > > the
> > > > > > >> >> > Excel
> > > > > > >> >> >> export file in Excel 2000, after SP1 I could. This is
> > because
> > > > of
> > > > > a
> > > > > > >> > format
> > > > > > >> >> >> change.
> > > > > > >> >> >>
> > > > > > >> >> >>
> > > > > > >> >> >> --
> > > > > > >> >> >> Bruce Loehle-Conger
> > > > > > >> >> >> MVP SQL Server Reporting Services
> > > > > > >> >> >>
> > > > > > >> >> >>
> > > > > > >> >> >>
> > > > > > >> >> >> "Chris" <chrisjallen@.comcast.net> wrote in message
> > > > > > >> >> >> news:OB%23bA3hFFHA.3312@.TK2MSFTNGP15.phx.gbl...
> > > > > > >> >> >> > Here is a cutout of the document to show what's
> > happening.
> > > > When
> > > > > I
> > > > > > >> >> >> > select
> > > > > > >> >> >> > EXCEL and I hit export via the web I get this...
> > > > > > >> >> >> >
> > > > > > >> >> >> >
> > > > > > >> >> >> > "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"
> > > > > > >> >> >> >
> > > > > > >> >> >> >
> > > > > > >> >> >> >
> > > > > > >> >> >> >
> > > > > > >> >> >> > Anyone have answers or do i have to just switch
> > solutions?
> > > We
> > > > > > >> >> >> > will
> > > > > > >> > rely
> > > > > > >> >> >> > heavily on exporting and if this doesnt work then its
> > back
> > > to
> > > > > the
> > > > > > >> >> > drawing
> > > > > > >> >> >> > board... Any help would be appreciated. Thanks in
> > advance.
> > > > > > >> >> >> >
> > > > > > >> >> >> >
> > > > > > >> >> >> > Thanks,
> > > > > > >> >> >> > Chris Allen
> > > > > > >> >> >> > "Chris" <chrisjallen@.comcast.net> wrote in message
> > > > > > >> >> >> > news:%23TqEPJTFFHA.3492@.TK2MSFTNGP12.phx.gbl...
> > > > > > >> >> >> >> Sorry for the half question.. I need to find a way
to
> > only
> > > > > > >> >> >> >> export
> > > > > > >> >> >> >> as
> > > > > > >> >> >> >> an
> > > > > > >> >> >> >> excel file. Even when i select it and hit export it
> > spits
> > > > out
> > > > > > > HTML
> > > > > > >> >> >> >> content
> > > > > > >> >> >> >> in my XLS File. Anyone got any suggestions?
> > > > > > >> >> >> >>
> > > > > > >> >> >> >> --
> > > > > > >> >> >> >>
> > > > > > >> >> >> >>
> > > > > > >> >> >> >> Thanks,
> > > > > > >> >> >> >> Chris Allen
> > > > > > >> >> >> >> "Chris" <chrisjallen@.comcast.net> wrote in message
> > > > > > >> >> >> >> news:%23caPmBTFFHA.1524@.TK2MSFTNGP09.phx.gbl...
> > > > > > >> >> >> >> > I have read previous posts and am still having an
> > issue.
> > > > Our
> > > > > > >> >> > production
> > > > > > >> >> >> >> > server is running SP1 and still exports Excel
Files
> as
> > > web
> > > > > > >> >> >> >> > archive
> > > > > > >> >> >> > format.
> > > > > > >> >> >> >> > So the files end up being 10 to 20 MB and not 1
MB.
> > Any
> > > > help
> > > > > > >> >> >> >> > would
> > > > > > >> >> >> >> > be
> > > > > > >> >> >> >> > appreciated. Thanks in advance
> > > > > > >> >> >> >> >
> > > > > > >> >> >> >> > --
> > > > > > >> >> >> >> >
> > > > > > >> >> >> >> >
> > > > > > >> >> >> >> > Thanks,
> > > > > > >> >> >> >> > Chris Allen
> > > > > > >> >> >> >> >
> > > > > > >> >> >> >> >
> > > > > > >> >> >> >>
> > > > > > >> >> >> >>
> > > > > > >> >> >> >
> > > > > > >> >> >> >
> > > > > > >> >> >>
> > > > > > >> >> >>
> > > > > > >> >> >
> > > > > > >> >> >
> > > > > > >> >>
> > > > > > >> >>
> > > > > > >> >
> > > > > > >> >
> > > > > > >>
> > > > > > >>
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>|||Until SP1 my Excel users had to use the CSV option. Then they have to go
through the step of taking the data that is all in one column and getting it
split into individual columns. Not hard but definitely not user friendly.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Chris" <chrisjallen@.comcast.net> wrote in message
news:uhH6cbEGFHA.3596@.TK2MSFTNGP12.phx.gbl...
> We do run this during off hours at night. But we had to stop because of
> the
> large report it was creating that nobody could open. I wonder if there is
> a
> better method. I have tried to export to CSV and even though it is
> considerably smaller it proves to be a pain because when you open it up in
> Excel it only inserts data in column A. It doesn't break the lines apart
> into each column that it should. Trying to make it as user friendly as
> possible.
> --
>
> Thanks,
> Chris Allen
> Senior Systems Developer
> Optimus Solutions LLC
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:ubF$NtDGFHA.392@.TK2MSFTNGP14.phx.gbl...
>> Again, it depends on what they are doing with it. Usually managers are
>> interested in summaries and then want to drill into data. The drill
> through
>> capabilities are great for this. On demand reporting (versus batching
> which
>> is essentially what you are doing here). They might be used to it one
>> way.
> A
>> human does not look at thousands of rows of data (which is what you have
>> with your report). I bet they end up just searching through it to get
>> what
>> they want. I might have been the only way to do it before but now you can
>> create reports that are so fast and easy to use that they could do it
>> differently. As I said, 40 Meg Excel file (which would be the absolute
> best
>> you would get even if RS did exactly the same as Excel) is a huge file.
>> Still, if they have to have it then I suggest seeing how big CSV is.
>> Going
>> with CSV should also put less strain on RS when it is rendering it.
> Although
>> this big is going to be a problem I bet. RS does everything in RAM and
>> extremely large reports can bring it to its knees. Again, the design
>> philosophy is to be fast and extremely easy for the end user to get
> reports
>> on demand (drill down, drill through, jump to another report etc). I
>> think
>> that you are going to find it problematic running this report unless you
> can
>> run it at off peak times.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Chris" <chrisjallen@.comcast.net> wrote in message
>> news:e3rpvUDGFHA.3472@.TK2MSFTNGP09.phx.gbl...
>> > The report I am working with is an inventory report which shows all
>> > inventory for a specific time. we do filter it based on product line
>> > but
>> > this is the main report for the managers which cannot be filtered
> anymore.
>> >
>> > --
>> >
>> >
>> > Thanks,
>> > Chris Allen
>> > Senior Systems Developer
>> > Optimus Solutions LLC
>> >
>> >
>> >
>> > "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> > news:eBlLT7CGFHA.2296@.TK2MSFTNGP15.phx.gbl...
>> > > Just to clarify. When you open it up now it no longer thinks it is a
>> mime
>> > > files does it (when you do a save as). It now recognizes it as a xls
>> file?
>> > > If so, then it looks like reapplying sp1 solved the problem.
>> > >
>> > > I don't know about why it gets smaller when you save it. Mine got
> larger
>> > > when I saved it. Could be that yours has many more columns that mine
>> does
>> > > and it affects how it creates it, it doesn't create it as
>> > > efficiently.
>> > Just
>> > > a guess.
>> > >
>> > > So an 80 MB file would be 40 MB when saved. This is still huge. Do
> they
>> > > really need all that data? I work with process engineers pulling over
>> > > process data and usually they can isolate a smaller period of time
> they
>> > are
>> > > interested in.
>> > >
>> > > If they are actually number crunching in Excel with this data then my
>> > > suggestion is to see how exporting in csv works. What size do you get
>> with
>> > > that. I have seen that users of Excel tend to be pretty comfortable
>> > opening
>> > > up csv files.
>> > >
>> > > One of the things I have seen with RS is that it is very easy to
> create
>> > new
>> > > ways for people to get data so previous ways of working (having a
> report
>> > > have everything including the kitchen sink in it) is not necessary.
>> > >
>> > >
>> > > --
>> > > Bruce Loehle-Conger
>> > > MVP SQL Server Reporting Services
>> > >
>> > >
>> > >
>> > > "Chris" <chrisjallen@.comcast.net> wrote in message
>> > > news:eDwbHeCGFHA.2756@.TK2MSFTNGP15.phx.gbl...
>> > > >
>> > >
>> >
> http://ohqsqlrpt01/ReportServer?%2fUsers+Folders%2fOPTIMUS+callenohc%2fMy+Reports%2fTestSizeReport&rs%3aCommand=Render&rs%3AFormat=EXCEL
>> > > >
>> > > > Running this on my server comes back with a 770K file now with a
>> reapply
>> > > of
>> > > > the SP1. But its still an issue because if I open and resave the
> same
>> > > > document it is only 400K. We have reports running that come up as
>> 80MB.
>> > > > Which is definitely too big for our clients to open. There systems
>> lock
>> > up
>> > > > when trying to open them. Even my system which is a IBM T40 Series.
> 2
>> > Gig
>> > > of
>> > > > RAM we/ 1.4 centrino.
>> > > >
>> > > > Any reason why it would still be larger than normal?
>> > > >
>> > > > --
>> > > >
>> > > >
>> > > > Thanks,
>> > > > Chris Allen
>> > > > Senior Systems Developer
>> > > > Optimus Solutions LLC
>> > > >
>> > > >
>> > > >
>> > > > "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> > > > news:%23JbeTECGFHA.1264@.TK2MSFTNGP12.phx.gbl...
>> > > > > With the report you emailed me I see the same thing you do, it is
>> not
>> > in
>> > > > > Excel format. However, when I export a report of mine it is in
> Excel
>> > > > format
>> > > > > and it is significantly smaller than what you are seeing. I did a
> 15
>> > > page
>> > > > > report and it was 700K. A single page report was 18K. When I open
> it
>> > in
>> > > > > Excel and do a save as it says Excel workbook. Again, what I
>> > > > > would
>> > > expect
>> > > > > but not what I see with the report you sent me.
>> > > > >
>> > > > > When you export you should end up with IE with the URL that
>> performed
>> > > the
>> > > > > export. Mine looked like this:
>> > > > >
>> > > >
>> > >
>> >
> http://cgincin2/ReportServer?%2fInventory%2fBy+WSP+Summary&RegulatedStatus=Y&rs%3aCommand=Render&rs%3AFormat=EXCEL
>> > > > >
>> > > > > What does yours look like?
>> > > > >
>> > > > > Also, do you have an old version of Excel around (Excel 2000,
> Excel
>> > 97).
>> > > > It
>> > > > > seems to me that for whatever reason that maybe you are still
>> getting
>> > > > Excel
>> > > > > in the old format (pre-SP1), not the native format. If so, you
> would
>> > not
>> > > > be
>> > > > > able to open it up in Excel 2000 or 97.
>> > > > >
>> > > > > If you have the same type of URL as I show above then my
> suggestion
>> is
>> > > to
>> > > > > re-apply the SP1 upgrade. Not sure how it would happen and I have
>> > never
>> > > > seen
>> > > > > it but something is just not right with your installation
> (assuming,
>> > as
>> > > I
>> > > > > said, that you have the same type of URL as I do).
>> > > > >
>> > > > >
>> > > > > --
>> > > > > Bruce Loehle-Conger
>> > > > > MVP SQL Server Reporting Services
>> > > > >
>> > > > >
>> > > > > "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> > > > > news:uNJOMo4FFHA.1260@.TK2MSFTNGP12.phx.gbl...
>> > > > > > Just email it to me. Take out the nospam from the email
>> > > > > > address.
>> > > > > >
>> > > > > >
>> > > > > > --
>> > > > > > Bruce Loehle-Conger
>> > > > > > MVP SQL Server Reporting Services
>> > > > > >
>> > > > > > "Chris" <chrisjallen@.comcast.net> wrote in message
>> > > > > > news:%23CqZR8vFFHA.3608@.TK2MSFTNGP14.phx.gbl...
>> > > > > > > MS newsgroup would not allow me to upload the 3 MB file.
>> > > > > > > Sorry
>> > > > > > >
>> > > > > > > --
>> > > > > > >
>> > > > > > >
>> > > > > > > Thanks,
>> > > > > > > Chris Allen
>> > > > > > > "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in
> message
>> > > > > > > news:uTZGrItFFHA.560@.TK2MSFTNGP15.phx.gbl...
>> > > > > > >> Well, you definitely have SP1. Could you take a small
>> > > > > > >> report,
>> > > export
>> > > > it
>> > > > > > >> as
>> > > > > > >> Excel and include it with a posting.
>> > > > > > >>
>> > > > > > >> --
>> > > > > > >> Bruce Loehle-Conger
>> > > > > > >> MVP SQL Server Reporting Services
>> > > > > > >>
>> > > > > > >>
>> > > > > > >> "Chris" <chrisjallen@.comcast.net> wrote in message
>> > > > > > >> news:OAlu3csFFHA.3972@.TK2MSFTNGP15.phx.gbl...
>> > > > > > >> > Microsoft SQL Server Reporting Services Version
>> > > > > > >> > 8.00.878.00
>> > > > > > >> >
>> > > > > > >> >
>> > > > > > >> > SP1 is installed and i get the issue either way. Using a
>> > > > subscription
>> > > > > > >> > or
>> > > > > > >> > going to the portal and exporting manually. Also on my
> local
>> > > > machine
>> > > > > i
>> > > > > > > am
>> > > > > > >> > using Visual Studio to export and i get the same result.
>> > > > > > >> >
>> > > > > > >> > --
>> > > > > > >> >
>> > > > > > >> >
>> > > > > > >> > Thanks,
>> > > > > > >> > Chris Allen
>> > > > > > >> > "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in
>> message
>> > > > > > >> > news:e9LDhIsFFHA.1476@.TK2MSFTNGP09.phx.gbl...
>> > > > > > >> >> Please, just to make sure we are not wasting time, go to
>> > > > > > >> >> //yourserver/reportserver and find the version and then
> post
>> > it
>> > > > > here.
>> > > > > > >> >>
>> > > > > > >> >> Also, how are you getting the excel export? Are you
>> rendering
>> > > via
>> > > > > URL
>> > > > > > > or
>> > > > > > >> >> Webservices or are you just using the reportmanager
>> > > > > > >> >> portal
>> and
>> > > > > > >> >> selected
>> > > > > > >> >> export?
>> > > > > > >> >>
>> > > > > > >> >> What happens if you export from Visual Studio when doing
>> > > > > > >> >> a
>> > > preview
>> > > > > > >> >> from
>> > > > > > >> >> there (I assume you have upgraded the visual studio
>> > > > > > >> >> Report
>> > > > Designer
>> > > > > as
>> > > > > > >> > well,
>> > > > > > >> >> SP1 needed to be applied at both).
>> > > > > > >> >>
>> > > > > > >> >> --
>> > > > > > >> >> Bruce Loehle-Conger
>> > > > > > >> >> MVP SQL Server Reporting Services
>> > > > > > >> >>
>> > > > > > >> >>
>> > > > > > >> >>
>> > > > > > >> >> "Chris" <chrisjallen@.comcast.net> wrote in message
>> > > > > > >> >> news:ul8qippFFHA.2824@.tk2msftngp13.phx.gbl...
>> > > > > > >> >> > Yes I am very sure. I installed it not long ago when I
> ran
>> > > into
>> > > > > > >> >> > other
>> > > > > > >> >> > issues
>> > > > > > >> >> > which forced me to install SP1.
>> > > > > > >> >> >
>> > > > > > >> >> > --
>> > > > > > >> >> >
>> > > > > > >> >> >
>> > > > > > >> >> > Thanks,
>> > > > > > >> >> > Chris Allen
>> > > > > > >> >> > "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in
>> > > message
>> > > > > > >> >> > news:%23NiHrdpFFHA.2736@.TK2MSFTNGP09.phx.gbl...
>> > > > > > >> >> >> Are you sure that your production server is running
> SP1?
>> > > What
>> > > > > > > version
>> > > > > > >> > is
>> > > > > > >> >> >> shown when you go to //servername/reportserver ?
>> > > > > > >> >> >>
>> > > > > > >> >> >> SP1 definitely exports as native. Prior to SP1 you
> could
>> > not
>> > > > open
>> > > > > > > the
>> > > > > > >> >> > Excel
>> > > > > > >> >> >> export file in Excel 2000, after SP1 I could. This is
>> > because
>> > > > of
>> > > > > a
>> > > > > > >> > format
>> > > > > > >> >> >> change.
>> > > > > > >> >> >>
>> > > > > > >> >> >>
>> > > > > > >> >> >> --
>> > > > > > >> >> >> Bruce Loehle-Conger
>> > > > > > >> >> >> MVP SQL Server Reporting Services
>> > > > > > >> >> >>
>> > > > > > >> >> >>
>> > > > > > >> >> >>
>> > > > > > >> >> >> "Chris" <chrisjallen@.comcast.net> wrote in message
>> > > > > > >> >> >> news:OB%23bA3hFFHA.3312@.TK2MSFTNGP15.phx.gbl...
>> > > > > > >> >> >> > Here is a cutout of the document to show what's
>> > happening.
>> > > > When
>> > > > > I
>> > > > > > >> >> >> > select
>> > > > > > >> >> >> > EXCEL and I hit export via the web I get this...
>> > > > > > >> >> >> >
>> > > > > > >> >> >> >
>> > > > > > >> >> >> > "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"
>> > > > > > >> >> >> >
>> > > > > > >> >> >> >
>> > > > > > >> >> >> >
>> > > > > > >> >> >> >
>> > > > > > >> >> >> > Anyone have answers or do i have to just switch
>> > solutions?
>> > > We
>> > > > > > >> >> >> > will
>> > > > > > >> > rely
>> > > > > > >> >> >> > heavily on exporting and if this doesnt work then
>> > > > > > >> >> >> > its
>> > back
>> > > to
>> > > > > the
>> > > > > > >> >> > drawing
>> > > > > > >> >> >> > board... Any help would be appreciated. Thanks in
>> > advance.
>> > > > > > >> >> >> >
>> > > > > > >> >> >> >
>> > > > > > >> >> >> > Thanks,
>> > > > > > >> >> >> > Chris Allen
>> > > > > > >> >> >> > "Chris" <chrisjallen@.comcast.net> wrote in message
>> > > > > > >> >> >> > news:%23TqEPJTFFHA.3492@.TK2MSFTNGP12.phx.gbl...
>> > > > > > >> >> >> >> Sorry for the half question.. I need to find a way
> to
>> > only
>> > > > > > >> >> >> >> export
>> > > > > > >> >> >> >> as
>> > > > > > >> >> >> >> an
>> > > > > > >> >> >> >> excel file. Even when i select it and hit export it
>> > spits
>> > > > out
>> > > > > > > HTML
>> > > > > > >> >> >> >> content
>> > > > > > >> >> >> >> in my XLS File. Anyone got any suggestions?
>> > > > > > >> >> >> >>
>> > > > > > >> >> >> >> --
>> > > > > > >> >> >> >>
>> > > > > > >> >> >> >>
>> > > > > > >> >> >> >> Thanks,
>> > > > > > >> >> >> >> Chris Allen
>> > > > > > >> >> >> >> "Chris" <chrisjallen@.comcast.net> wrote in message
>> > > > > > >> >> >> >> news:%23caPmBTFFHA.1524@.TK2MSFTNGP09.phx.gbl...
>> > > > > > >> >> >> >> > I have read previous posts and am still having an
>> > issue.
>> > > > Our
>> > > > > > >> >> > production
>> > > > > > >> >> >> >> > server is running SP1 and still exports Excel
> Files
>> as
>> > > web
>> > > > > > >> >> >> >> > archive
>> > > > > > >> >> >> > format.
>> > > > > > >> >> >> >> > So the files end up being 10 to 20 MB and not 1
> MB.
>> > Any
>> > > > help
>> > > > > > >> >> >> >> > would
>> > > > > > >> >> >> >> > be
>> > > > > > >> >> >> >> > appreciated. Thanks in advance
>> > > > > > >> >> >> >> >
>> > > > > > >> >> >> >> > --
>> > > > > > >> >> >> >> >
>> > > > > > >> >> >> >> >
>> > > > > > >> >> >> >> > Thanks,
>> > > > > > >> >> >> >> > Chris Allen
>> > > > > > >> >> >> >> >
>> > > > > > >> >> >> >> >
>> > > > > > >> >> >> >>
>> > > > > > >> >> >> >>
>> > > > > > >> >> >> >
>> > > > > > >> >> >> >
>> > > > > > >> >> >>
>> > > > > > >> >> >>
>> > > > > > >> >> >
>> > > > > > >> >> >
>> > > > > > >> >>
>> > > > > > >> >>
>> > > > > > >> >
>> > > > > > >> >
>> > > > > > >>
>> > > > > > >>
>> > > > > > >
>> > > > > > >
>> > > > > >
>> > > > > >
>> > > > >
>> > > > >
>> > > >
>> > > >
>> > >
>> > >
>> >
>> >
>>
>