Services
Support
Store
©2015 Intersoft Solutions. All rights reserved.

User Profile & Activity

Fernando Romero Member
Imposible to export to Excel or PDF with IIS7
Posted: September 30, 2009 11:34 AM

Andrew, to follow up this issue we even put a test machine so that intersoft people could check the issue. They enter via remote desktop but the test Machine was in spanish so we had to put another environment in english language.

 

After we put the environment in english everything work nice, so this is a problem in spanish only (as I have test so far). If you are having trouble with the inglish version you must try:

-Put everytone with full control to the tempReports folder en your website

-Configure a printer in your machine eventhough the printer does not exits (some time I need to do this)

If you have anspanish environment I have not a solution for the issue.

Imposible to export to Excel or PDF with IIS7
Posted: September 22, 2009 7:56 PM

Glenn, I send this information on 17 Sept and haven't receive a reply. Is there a way to check if you were able to check this issue?

Imposible to export to Excel or PDF with IIS7
Posted: September 17, 2009 7:29 PM

Thank you for your tests. But it is incredibly weird since I have the same problem in tree environments (2 Vista Bussines and 1 Server 2008).

If we don't manage to fix this issue I will have a HUGE lost, I will have to change at least 120 Forms.

 

So I have one last idea, I can give you Remote Desktop access to my test machine (is a laptop), so you can see the issue. Is there a private way to send you credentials for the access? There is nothing important in this test machine it has been just formated and is not part of our domain.

Please tell me how to send you the remote desktops credentials.

Imposible to export to Excel or PDF with IIS7
Posted: September 16, 2009 8:20 PM

I am attaching my test project. Just create a new Web site or Virtual Directory, make sure of:

  • Using Frameworks 2.0
  • Using just Windows Authentication (NO ANONYMOUS)
  • ASP.NET impersonation active!!!
  • Make sure you are using IIS 7 (in Windows Vista if possible)
  • Try running prueba.aspx, from a  remote machine (NOT THE SERVER).
  • Make sure you are using a different user in the remote machine that the one that is logged in the server

IMPORTANT: Just load the ASPX, there will be an empty grid (that is normal). Try to exporta to PDF with the left toolbar button, try to export to Excel with the right toolbar button. The toolbar images are no include THAT IS NORMAL BUTTONS STILL WORK.

If you follow these steps correctly I am 100% sure the problem will be replicated.

 

Imposible to export to Excel or PDF with IIS7
Posted: September 16, 2009 6:05 PM

The issu eis really easy to replicate are you sure that:

  1. You use windows authentication (please deactivate anonymous authentication just to make sure you are using windows)
  2. Are you sure you activate ASP.NET impersonation??
  3. Are you sure you are using IIS7??

I have two completly different environments and the problem is perfectly replicated in both of them. Maybeone important thing is that both test evirinment are with Windows Vista Bussiness.

 

I install the Acrobat Reader (same issue), please remember I also have problem with excel exporty!.

 

Imposible to export to Excel or PDF with IIS7
Posted: September 14, 2009 4:38 PM

Ok, I have manage to replicate the issue in a completly new evironment. To replicate the issue follow these followin steps:

1.      Use IIS7

2.      Connect to the web site with windows authentication

3.      Disable anonymous authentication in the IIS (I need to use windows authentication)

4.      Set ASP.NET impersonation to true

I am using two users

·         TESTMACHINE\FER (is administrator)

·         TESTMACHINE\TEST (is standard user)

I also have set permissions to IUSR and anonymous logon to the BIN and TEMPREPORTS (just in case).

I have made test in the IIS machine (server) and in a remote machine, my test results are:

1.       In IIS Machine :

a.       Setting ASP.NET Impersonation to FALSE works perfetly with both users

b.      Setting impersoante to TRUE with user TESTMACHINE\FER (is administrator):

                                                                                      i.      PDF: access denied to tempReports (user FER has access to this folder)

                                                                                     ii.      Excel: “Error crearing File”

c.       Setting impersonate to TRUE with user TESTMACHINE\TEST (is standard user):

                                                                                      i.      PDF: Printer does not support letter printer size……..

                                                                                     ii.      Excel: “Error creating File”

2.       Remote Machine:

a.       Setting ASP.NET Impersonation to FALSE works perfetly with both users

b.      while user TESTMACHINE\FER is logon to the IIS Machine and IMPERSONATE=true:

                                                                                      i.      with user TESTMACHINE\FER works pefectly

                                                                                     ii.      Setting impersoante to TRUE with user TESTMACHINE\TEST Printer does not support letter printer size……..

c.       while user TESTMACHINE\TEST is logon to the IIS Machine and IMPERSONATE=true:

                                                                                      i.      with user TESTMACHINE\FER Printer does not support letter printer size……..

                                                                                     ii.      Setting impersoante to TRUE with user TESTMACHINE\TEST  works perfectly

d.      while NO user is logged to the IIS Machine and IMPERSONATE=true:

                                                                                      i.      with user TESTMACHINE\FER Printer does not support letter printer size……..

                                                                                     ii.      Setting impersoante to TRUE with user TESTMACHINE\TEST  Printer does not support letter printer size……..

 

I have no doubt in my mind this is a BUG, how it is possible that the behavior changes depending on the user that is logon to the IIS Machine? This is the second evironment with this issue, this new evironment is even outside my domain.

I think you have enough information to reproduce this issue. PLEASE HELP! We already spend in total 45 hours from our developers in this issue.

Imposible to export to Excel or PDF with IIS7
Posted: September 7, 2009 1:50 PM
Please make sure the project bin folder already have ISNet.WebUI.WebGrid.dll, ISNet.WebUI.WebGrid.Resources.dll, and ISNet.ActiveReports.Exporting.dll

In a deployment scenario you do not need to add a reference to the ISNet.ActiveReports.Exporting.dll in you web.config

To fix the issue we area trying everything in the developping machine, all DLL are in the BIN folder.

It is important to note the following:

  • Do Work: If the user executing the ASP.NET process (windows authetication with impersonate = true) is the same user logged to the IIS server machine executing the application everything works great
  • Doesn't WORK: If the same user is logged to the machine but I use anonymous access (network service or IIS-USR) doesn't work
  • Doesn't Work: The same user logged to the IIS machine with windows authentication and Impersonate = False.
  • Do Work: A remote user accesing the application but the application set to a Fixed impersonation to the user logged in the machine.
  • Do Work: We have a pre-production environment with IIS 6 everything works great, for every test
  • The testing machine is Windows Vista (IIS 7).

In conclusion the only way the export to Excel or PDF works is if the ASP.NET process is executed using the credentials of the user logged to the machine with the IIS Server.

How can we proceed to fix this issue? What can we do? Any ideas?

 

All times are GMT -5. The time now is 2:48 PM.
Previous Next