IVR to Database to Web

Hello all

I am about to begin a project that will be implemented in a local company. It involves using an IVR(interactive voice response) to collect information with regards a customer satisfaction survey. The results are then to be presented on the web. Thus I have an IVR connected to a database which is connected to the web. The results are to be presented in stats and graphs on the web.

I was originally going to use an Oracle database however it has worked out that it is not feesable to use Oracle for such a small application. I am now looking at SQL server. However, I have never dealt with it before. I have extensive knowledge of SQL. What I need to know is SQL server suitable to use when it comes to connecting to a web application, querying the data to show graphs and stats and is it easy to learn for a person who has extensive knowledge of databases? Id appreciate your knowledge and advice on this topicHowdy,

Greetings from sunny Surrey in the UK!!

Well the short answer is - yes - if you are willing to take the time to learn SQLs eccentricities.

Regards size , we have 5 MB databases running ( some with web app links ) so small isnt an issue.

SQL Server is pretty easy to learn, and if you are just quering the database or writing data into it from a web app, it should all be straight forward. Mind you...how long is a bit of string?

Do you have a DBA to set up the server or are you it?

Cheers,

SGsql

IUSR Web Access to DB - Separate Servers

I have NT SQL 7 and Web Server on same box. I have a new server with W2K and SQL 2000 installed (no IIS). I am migrating the databases over and when done I will install W2K on the old box and it will remain the IIS Web server front end to the new SQL 2000 Server.

On the old configuration, IIS and SQL 7 on the same box, I added the IUSER to the database from the local computer users list when needed for web access. How do I add that user now that the boxes are seperate? The acccout is not a local account on the new machine and the account is a loca account on the other machine so it does not authenticate to the domain so I can't pull it in from there.

Thanks for any help.

--Steve

ssantos@.csuchico.eduSimple answer is to use SQL Authentication.

Create a SQL user on your SQL box, then use a non-SSPI connection in your ASP/ASPX.

More complicated, but ultimately better answer:
Create a new domain user, give it the same permissions on the IIS machine as the IUSER, restrict it's permissions elsewhere on the domain, then add them as a database user in the SQL box.

Iterating

Hi,

I have a 6 different textboxes in my web application. I have 6 different tables in my database such as tbl1,tbl2,tbl3 etc.

When the user clicks the submit button I have to check whether the values in the textboxes match the value in the database. (if in txt1 the user enters 3 I need to go to tbl1 and check if there is such a value).

What is the most efficient way to perform such a check? Will I need to write 6 select statements or can I use a loop and if I can use a loop I would appreciate an example

Thanks

Why do you need to do this?

If you are loading the value into the textbox to begin with, and you simply want to check whether the text has changed, there is a text changed event raised by the textbox. If that doesn't work for you, you could always store the initial value of the textbox in a custom property when you populate the textbox:

myTextBox1.Attributes.Add('initValue',myValue)

Then simply check to see whether it has changed.

If you MUST check these against values from the database (i.e.; for data volatility reasons), you should retrieve all six from the db in a single SQL query, if possible. It would be more efficient...

|||

I need to do this coz the user enters a code in the textboxes and I need to check if such a code exists in the db and if there is no such a code then the user must select another code.

How can I retrieve all 6 values in a single query from 6 different tables?

ItemTypeEnum = Resource question

I have a Resource file that is a htm file in a sub-folder on reporting
services. Using the web service I am getting the catalog items using
ListChildren. I want to be able to extract out the contents of the htm file.
It is stored as a text/html MIMEType. I don't know if this is the correct
forum for this question or not but any assistance is appreciated.
JamesI found the answer myself and will post for reference:
byte[] resourceDefinition = null;
string mimeType = null;
string res = null;
resourceDefinition = rs.GetResourceContents(strReportName, out mimeType);
System.Text.UTF8Encoding enc = new System.Text.UTF8Encoding();
res = enc.GetString(resourceDefinition);
"James Tow" wrote:
> I have a Resource file that is a htm file in a sub-folder on reporting
> services. Using the web service I am getting the catalog items using
> ListChildren. I want to be able to extract out the contents of the htm file.
> It is stored as a text/html MIMEType. I don't know if this is the correct
> forum for this question or not but any assistance is appreciated.
> James

It's slow to use ServerXMLHTTP to submit a query to SQLXML virtual directory

I'm using ServerXMLHTTP object in an ASP page (web server) to submit a query to our database server (SQL Server 2000) via SQLXML virtual directory. The ServerXMLHTTP object will return me more than 5000 rows in XML format which is about 15M in size.

The problem is, it takes 1 minute for the ServerXMLHTTP object to get the response from SQLXML web service. That makes our web application not workable because it's really slow.

However, if I use XMLHTTP object instead of ServerXMLHTTP object, it only takes seconds to finish the same query. I know these 2 objects are implemented in different ways. XMLHTTP is designed for client applications and relies on URLMon, which is built upon Microsoft Win32 Internet (WinInet). ServerXMLHTTP is designed for server applications and relies on a new HTTP client stack, WinHTTP. ServerXMLHTTP offers reliability and security and is server-safe. So I'd better use ServerXMLHTTP in my web application if I know how to solve the speed issue.

Can somebody help me out? Thank you very much in advance. This problem happens recently. The program had been working for 3 years.

The url opened by ServerXMLHTTP object is like http://myserver/myvd?sql=select * from staff where gender='M' and staff_id<5000 for xml auto&root=Root

Here are some things to look at.

ServerXMLHTTP can have proxy issues. Check if the time is spent making the connection. [more]

It can take 15+ seconds to negotiate certificates. Are certificates involved? If so, are you reusing the ServerXMLHTTP object? If so does the delay occurs only on the first use of the ServerXMLHTTP object?

If it's possible in your scenario (not enough info for me to tell), you can use ServerXMLHTTP in asynchronous mode to increase concurrency in your app (work while you wait).

HTH!

Tim

sql

Issues with Report Manager on both a web server and the report server?

My reports have been run off of a combined IIS/SQL server. I have a new application, which is using the SQL server, but runs on its own web server. The developer would like to deploy his reports to the new IIS server. Are there any issues with just installing a copy of the Report Manager on the new IIS server and putting reports there while continuing to run the original application on the combined server?

TIA

Daniel

Hi,

From your description, it seems that you want to deploy your reporting service on other server than the server with SQLServer, right?

I'm afraid you have to install components for SQLServer reporting service on that new IIS. Only n this way, you can re-configure the settings in SQL Server Reporting Services Configuration, including Web Service Identity, report server and report manager virtual directory, also the new database server's information. After that , you can run your reporting service with other database servers.

For more information on each components of Reporting service, see:

http://msdn2.microsoft.com/en-us/library/ms155792.aspx

Thanks.

|||

Michael,

I want to deploy report manager on two servers, the SQL server itself and on another server running just as a web server. I have not found a definitive answer, but based on what I have found I am thinking you can only have one report manager set up.

Regards,

Daniel

|||

Hi,

the SQL server itself and on another server running just as a web server.

No matter how many machines you want to run your Report Manager, you should install the SQLServer client component to enable the SQL Report manager. (connecting a remote database).

sql

Issues with 1.1 framework calling SQL 2005 CLR sprocs?

Are there any issues calling SQL 2005 CLR bases stored procedures and functions from a web application which uses the dotnet 1.1 framework?

I assume not, but would like advice from those who've been there...

Thanks,

Marie

Hi,

no there are nor problems. Even calling SP from other program with the MDAC stack does not bring any problems. You will not be able to use certain features as they are only supportedby the ADO.NET 2.0 framework (like query notification) but there any no problems with the "old" functionality.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||Thanks Jens!

Issues with 1.1 framework calling SQL 2005 CLR sprocs?

Are there any issues calling SQL 2005 CLR bases stored procedures and functions from a web application which uses the dotnet 1.1 framework?

I assume not, but would like advice from those who've been there...

Thanks,

Marie

Hi,

no there are nor problems. Even calling SP from other program with the MDAC stack does not bring any problems. You will not be able to use certain features as they are only supportedby the ADO.NET 2.0 framework (like query notification) but there any no problems with the "old" functionality.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||Thanks Jens!

Issues connecting to SQL Server 2005 from SQL Server Mgmt Studio - Please help!!!

Hi Everyone,

I am running into a problem and have been browsing the web and reading nonstop for answers with no success. My company just installed SQL Server 2005 and I am trying to connect to it via SQL Server Management Studio from my network computer in the same office building.

When I browse for Local or Network Servers in the initial popup box at SQL Management Studio Startup, it doesn't show any servers at all. Is there something I need to enable on the Server using the Configuration Manager or one of the other tools to allow my network computer to "see" the SQL Server?

Any insight would be MUCH appreciated. Even a link to a how-to would suffice. Thank you.

Is your server and your computer on the same network? To enumerate SQL server on your network, you must turn on SQL Browser on your server machine. Make sure UDP port 1434 is not blocked by any firewall on your server. Keep in mind you are not guaranteed to see all network instance as the enumration is UDP based and is not realiable. So, in this case, you'd better type your server name into the box directly. such server1 or server1\inst1, etc.

|||

read these article

http://msdn2.microsoft.com/en-us/library/ms165724.aspx

http://support.microsoft.com/default.aspx/kb/914277

http://support.microsoft.com/kb/287932/en

Madhu

Issues about deploy Business Logic Handler to a web server for web replication.

Pocket PC 2003, SQL Compact Edition, SQL2005, IIS6.0

I implemented a business logic handler to deal with conflicts. When I deploy it on the SQL server which is also the web replication server, the logic handler seems working fine. However, if I deploy this handler to another web server. The logic handler failed to be loaded.

My enviroment settings are desribed as below.

Machine A, distributor, with database and publication. The business logic handler is deployed at C:\Program Files\Microsoft SQL Server\90\COM\BusinessLogicHandler.dll. It's registered by using sp_registercustomresolver. The @.assembly is specified as @.assembly=C:\Program Files\Microsoft SQL Server\90\COM\BusinessLogicHandler.dll';

Machine B, IIS server. The same business logic handler is deployed at C:\Program Files\Microsoft SQL Server\90\COM\BusinessLogicHandler.dll on the Machine B itself.

When I ran the web replication, the Merge Agent reported the error as below.

Error loading custom assembly "C:\Program Files\Microsoft SQL Server\90\COM\BusinessLogicHandler.dll", Error: "Could not load file or assembly 'C:\\Program Files\\Microsoft SQL Server\\90\\COM\\BusinessLogicHandler.dll' or one of its dependencies. The given assembly name or codebase was invalid.

It seemed that the Merge Agent had trouble to find my logic handler because the path reported in the error log has two backward slashes. I have no idea where did that came from. I am not sure if that's the cause of the error. Without business logic handler. I had successfully finished web replication of Machine B to sync with Machine A. If I setup web replication directly on Machine A with business logic handler, I can successfully sync as well.

Does anyone has any idea about how to correctly deploy business logic handler on a web server?

Thanks,

Nigel

It seems that if I sign the dll and install it in the global assembly of Mahine B. The problem went away. Does it mean we should deploy our assembly in the global assembly instead of the path "@.assembly" of distributor when we deploy our business logic handle to a IIS web replication server? The SQL2005 document does not specify how we should deploy the business logic handler for the web synchronization server. It would be nice if it could MS can provide more detail in business logic handler deploymont. However, it still seems to me it's a bug for the Merge Agent not be able to find the business logic handler in my previous post. Still don't know where the backward slashes come from.

If anyone has more details about this issue, please advise.

Thanks,

Nigel

Issue with running reports on machine that does not have report services

I am trying to run reports from a web application. If I am on the machine
with reporting services then the report will pull up. If I try from a PC
that doesn't have reporting services I get a "Page cannot be displayed"
error. I have checked permissions on most everything I could think of.
Please help. I have been researching and trying to resolve this for over
two weeks. Thanks!
--
Message posted via http://www.sqlmonster.comDo you mean you can't get to http://servername/reports from a remote
machine? Or are you trying to embed a report viewer control in an asp.net
app that's on a different machine?
Mike G.
"JC via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:f491c9d8986847cbbd8e3872e85aabca@.SQLMonster.com...
>I am trying to run reports from a web application. If I am on the machine
> with reporting services then the report will pull up. If I try from a PC
> that doesn't have reporting services I get a "Page cannot be displayed"
> error. I have checked permissions on most everything I could think of.
> Please help. I have been researching and trying to resolve this for over
> two weeks. Thanks!
> --
> Message posted via http://www.sqlmonster.com|||I can get the http//servername/reportserver to pull up after logging in as
an administrator, but what I need I will explain below.
I have a reportviewer embedded in my asp.net webapplication, but when I
click on the link from a PC that does not have report services loaded it
gives me the page cannot be displayed error.
Thanks!
Jill
--
Message posted via http://www.sqlmonster.com|||The report control doesn't require anything to be installed with the
browser. It just renders an iframe that points to the reportserver. This
may sound silly, but just to be sure, perhaps did you specify localhost as
part of the serverurl property of the viewer? If you did, the iframe won't
be pointing at the remote report server, but would still be looking at
localhost a.k.a itself.
Even if you didn't use localhost, from the client, type in what's in the
serverurl property and make sure you can get to the server from the client.
Also, you can always do a view source on the page, look for the iframe and
take a look at the src property.
Mike G.
"JC via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:de02341f0922462dba9a2ec5cdcb3992@.SQLMonster.com...
>I can get the http//servername/reportserver to pull up after logging in as
> an administrator, but what I need I will explain below.
> I have a reportviewer embedded in my asp.net webapplication, but when I
> click on the link from a PC that does not have report services loaded it
> gives me the page cannot be displayed error.
> Thanks!
> Jill
> --
> Message posted via http://www.sqlmonster.com|||Whoops...(blushes). I found where I had the localhost in the url. I
thought I had taken it out, but I must have not saved it. Thanks for that
tip.
The report is trying to come up now, but it prompts the user for a username
and password. I don't want the user to have to do that. Is there a way
around this?
Thanks!
--
Message posted via http://www.sqlmonster.com|||What is IIS set to allow? For an intranet, you probably want just windows
integrated (not anonymous). Of course, that means giving giving the
users/groups the correct permissions to the reports in the report manager.
Mike G.
"JC via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:183115a982ba408a8600324cca74f560@.SQLMonster.com...
> Whoops...(blushes). I found where I had the localhost in the url. I
> thought I had taken it out, but I must have not saved it. Thanks for that
> tip.
> The report is trying to come up now, but it prompts the user for a
> username
> and password. I don't want the user to have to do that. Is there a way
> around this?
> Thanks!
> --
> Message posted via http://www.sqlmonster.com

Issue with ReportViewer dll and accessing reports

Question,
I have an external web server that uses the ReportViewer dll to point to a
Report Server located internally - Not visible to the outside world just to
the intranet. I get a page not found error when trying to view a report via
the reportviewer dll. I have a feeling this is being caused because the
serverurl property is set to point to the server inside the firewall. I can
run the web app just fine from the intranet but whenever I try externally I
get that page not found problem. I was under the impression that the Report
Server Dll was an ASP.Net server control and would run on the server but it
seems as if it is somehow tied to the client. The reason I think this is it
seems as if the client is looking for localhost which of course doesnt exist
on the clients end. Any help and or tips would be appreciated.
Thanks,
Scott EguiresHI, Scott:
I have the same issue. I have a external web cluster to host my website. And
I use the reportview web control to embed the report to my website. My report
server is internally. It works ok from inside, but from outside, I get the
result "The page can not be display". I think it can not find the server.
Did you solve your problem finally? And how did you solve it?
Thanks a lot.
-summer
"Scott Eguires" wrote:
> Question,
> I have an external web server that uses the ReportViewer dll to point to a
> Report Server located internally - Not visible to the outside world just to
> the intranet. I get a page not found error when trying to view a report via
> the reportviewer dll. I have a feeling this is being caused because the
> serverurl property is set to point to the server inside the firewall. I can
> run the web app just fine from the intranet but whenever I try externally I
> get that page not found problem. I was under the impression that the Report
> Server Dll was an ASP.Net server control and would run on the server but it
> seems as if it is somehow tied to the client. The reason I think this is it
> seems as if the client is looking for localhost which of course doesnt exist
> on the clients end. Any help and or tips would be appreciated.
> Thanks,
> Scott Eguires|||Yes I did. I wrote my own report viewer control to view the reports
externally without having to pay for an extra SQL Server license. It was a
real pain but it works beautifully and has a fairly nice interface. I still
need to add security to it though.
Scott Eguires
"summer" wrote:
> HI, Scott:
> I have the same issue. I have a external web cluster to host my website. And
> I use the reportview web control to embed the report to my website. My report
> server is internally. It works ok from inside, but from outside, I get the
> result "The page can not be display". I think it can not find the server.
> Did you solve your problem finally? And how did you solve it?
> Thanks a lot.
> -summer
> "Scott Eguires" wrote:
> > Question,
> >
> > I have an external web server that uses the ReportViewer dll to point to a
> > Report Server located internally - Not visible to the outside world just to
> > the intranet. I get a page not found error when trying to view a report via
> > the reportviewer dll. I have a feeling this is being caused because the
> > serverurl property is set to point to the server inside the firewall. I can
> > run the web app just fine from the intranet but whenever I try externally I
> > get that page not found problem. I was under the impression that the Report
> > Server Dll was an ASP.Net server control and would run on the server but it
> > seems as if it is somehow tied to the client. The reason I think this is it
> > seems as if the client is looking for localhost which of course doesnt exist
> > on the clients end. Any help and or tips would be appreciated.
> >
> > Thanks,
> >
> > Scott Eguires|||Do I need an extra SQL license if I only install the Reoprt server on the web
server, and keep the Report database on another machine with already has a
SQL license?
Do you mind to tell me how you build your own report viewer? Did you use SOAP?
Thanks a lot.
"Scott Eguires" wrote:
> Yes I did. I wrote my own report viewer control to view the reports
> externally without having to pay for an extra SQL Server license. It was a
> real pain but it works beautifully and has a fairly nice interface. I still
> need to add security to it though.
> Scott Eguires
> "summer" wrote:
> > HI, Scott:
> >
> > I have the same issue. I have a external web cluster to host my website. And
> > I use the reportview web control to embed the report to my website. My report
> > server is internally. It works ok from inside, but from outside, I get the
> > result "The page can not be display". I think it can not find the server.
> >
> > Did you solve your problem finally? And how did you solve it?
> >
> > Thanks a lot.
> >
> > -summer
> > "Scott Eguires" wrote:
> >
> > > Question,
> > >
> > > I have an external web server that uses the ReportViewer dll to point to a
> > > Report Server located internally - Not visible to the outside world just to
> > > the intranet. I get a page not found error when trying to view a report via
> > > the reportviewer dll. I have a feeling this is being caused because the
> > > serverurl property is set to point to the server inside the firewall. I can
> > > run the web app just fine from the intranet but whenever I try externally I
> > > get that page not found problem. I was under the impression that the Report
> > > Server Dll was an ASP.Net server control and would run on the server but it
> > > seems as if it is somehow tied to the client. The reason I think this is it
> > > seems as if the client is looking for localhost which of course doesnt exist
> > > on the clients end. Any help and or tips would be appreciated.
> > >
> > > Thanks,
> > >
> > > Scott Eguires|||Yes you do need another SQL Server license in this scenario. That is why I
wrote my own Report Manager/Viewer. I can give you more information on
Monday or Tuesday of next week as I am currently out of town on a business
trip. You can email me at scott@.eguires.net for further discussions if you
wish and I can show you what I have done thus far and you can give me your
opinion on it.
Thanks,
Scott Eguires
"summer" wrote:
> Do I need an extra SQL license if I only install the Reoprt server on the web
> server, and keep the Report database on another machine with already has a
> SQL license?
> Do you mind to tell me how you build your own report viewer? Did you use SOAP?
> Thanks a lot.
> "Scott Eguires" wrote:
> > Yes I did. I wrote my own report viewer control to view the reports
> > externally without having to pay for an extra SQL Server license. It was a
> > real pain but it works beautifully and has a fairly nice interface. I still
> > need to add security to it though.
> >
> > Scott Eguires
> >
> > "summer" wrote:
> >
> > > HI, Scott:
> > >
> > > I have the same issue. I have a external web cluster to host my website. And
> > > I use the reportview web control to embed the report to my website. My report
> > > server is internally. It works ok from inside, but from outside, I get the
> > > result "The page can not be display". I think it can not find the server.
> > >
> > > Did you solve your problem finally? And how did you solve it?
> > >
> > > Thanks a lot.
> > >
> > > -summer
> > > "Scott Eguires" wrote:
> > >
> > > > Question,
> > > >
> > > > I have an external web server that uses the ReportViewer dll to point to a
> > > > Report Server located internally - Not visible to the outside world just to
> > > > the intranet. I get a page not found error when trying to view a report via
> > > > the reportviewer dll. I have a feeling this is being caused because the
> > > > serverurl property is set to point to the server inside the firewall. I can
> > > > run the web app just fine from the intranet but whenever I try externally I
> > > > get that page not found problem. I was under the impression that the Report
> > > > Server Dll was an ASP.Net server control and would run on the server but it
> > > > seems as if it is somehow tied to the client. The reason I think this is it
> > > > seems as if the client is looking for localhost which of course doesnt exist
> > > > on the clients end. Any help and or tips would be appreciated.
> > > >
> > > > Thanks,
> > > >
> > > > Scott Eguires

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
>> > > > > > >> >> >> >> >
>> > > > > > >> >> >> >> >
>> > > > > > >> >> >> >>
>> > > > > > >> >> >> >>
>> > > > > > >> >> >> >
>> > > > > > >> >> >> >
>> > > > > > >> >> >>
>> > > > > > >> >> >>
>> > > > > > >> >> >
>> > > > > > >> >> >
>> > > > > > >> >>
>> > > > > > >> >>
>> > > > > > >> >
>> > > > > > >> >
>> > > > > > >>
>> > > > > > >>
>> > > > > > >
>> > > > > > >
>> > > > > >
>> > > > > >
>> > > > >
>> > > > >
>> > > >
>> > > >
>> > >
>> > >
>> >
>> >
>>
>