Intersoft Community - WebGrid Enterprise - Imposible to export to Excel or PDF with IIS7

Imposible to export to Excel or PDF with IIS7

Glayaar — Thu, 01 Oct 2009 03:39:27 GMT

Based on the error,

System.Web.HttpUnhandledException: Exception of type 'System.Web.HttpUnhandledException' was thrown. ---> System.Exception: Printer does not support Letter papersize. Please use PaperKind.Custom in your PageSettings or specify a papersize supported by the current printer ---> DataDynamics.ActiveReports.ReportException: Printer does not support Letter papersize. Please use PaperKind.Custom in your PageSettings or specify a papersize supported by the current printer

We already have a KB article for such an issue. You will need to set the printer name to empty in the PrepareExportExecute server side event. Here is the snippet

private void WebGrid1_PrepareExportExecute (object sender, ISNet.WebUI.WebGrid.PrepareExportExecuteEventArgs e) 
{
  e.ReportObject.Document.Printer.PrinterName = ""; 
}

You could read the complete KB article in the support page, Under WebGrid >> Knowledge Base >> Exporting >> Fixes for printer problem exporting data into Excel

Imposible to export to Excel or PDF with IIS7

Glayaar — Thu, 01 Oct 2009 03:33:12 GMT

I have inquired our developer regarding this issue and have also mention all the latest finding, works in English windows but on the Spanish windows teh issue still occurs, based on your test. We will inform you if there is any update or progress regarding this issue.

Imposible to export to Excel or PDF with IIS7

whodurun4@gmail.com — Wed, 30 Sep 2009 15:57:36 GMT

Thanks, Fernando.

I was able to figure out the part with granting full control to the tempReports folder this morning and that resolved the issue on our staging server, but we're still receiving the error in our production environment. Both are English environments.

We have a couple printers configured on both machines as well.

Are there any other suggestions?

Here is the error:

System.Web.HttpUnhandledException: Exception of type 'System.Web.HttpUnhandledException' was thrown. ---> System.Exception: Printer does not support Letter papersize. Please use PaperKind.Custom in your PageSettings or specify a papersize supported by the current printer ---> DataDynamics.ActiveReports.ReportException: Printer does not support Letter papersize. Please use PaperKind.Custom in your PageSettings or specify a papersize supported by the current printer

Imposible to export to Excel or PDF with IIS7

fernandosv — Wed, 30 Sep 2009 11:34:21 GMT

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

whodurun4@gmail.com — Wed, 30 Sep 2009 08:48:46 GMT

We are experiencing a similar error. Were able to solve this issue?

Thanks,

Andrew

Imposible to export to Excel or PDF with IIS7

fernandosv — Tue, 22 Sep 2009 19:56:27 GMT

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

Glayaar — Thu, 17 Sep 2009 20:57:06 GMT

You could send the credential to technical@intersoftpt.com and mention that this issue has been discussed in the forum and also please provide the link to this thread

Imposible to export to Excel or PDF with IIS7

fernandosv — Thu, 17 Sep 2009 19:29:15 GMT

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

Glayaar — Wed, 16 Sep 2009 23:37:18 GMT

The sample will run correctly after setting the administrator and standard user account with the proper access to the TempReports folder. The account must be able to have write access to the folder to allow them to create the export file in the TempReports.

After setting the proper access the issue will not occur using the scenario you describe

Tested using IIS7 in Windows Vista on .NET Framework 2.0, Impersonation True with Windows Authenthication, and Anonymous access disabled with the sample you provided

Imposible to export to Excel or PDF with IIS7

fernandosv — Wed, 16 Sep 2009 20:20:19 GMT

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

fernandosv — Fri, 04 Sep 2009 21:02:07 GMT

We have been working in an application development over a year. Web Grid is heavily used in our application and its export funtions to PDF and Excel. We use this export function in hundreds of web forms. It is important to add that the export funcion is called from the client using the command webgrid.ExportGrid.

The only way to manage to export is to run the application from the server with windows authentication and impersonate=true!!

It is also important to add:

The error message is "Printer does not support Letter papersize. Please use PaperKind. Custom in your PageSettings or specify a papersize supported by the current printer"
We already try the fix in your support page but it doesn't work. This fix involves using the event PrepareExportExecute, and the object e.ReportObject.Document.Printer.PrinterName = ""; When we try to use the object we get an error stating that we have to reference the assembly ISNet.ActiveReports.Exporting, which is already referenced.
The folder TempReports already have write permission
Our server language is spanish, we also read the foreign language fix (Didn't work)
We update to the latest webUI Framework and webUI Grid. (Didn't work)

Our deployment is already delayed 4 days because of this issue. If you need more details please let me know ASAP.

[Edited by moderator: Generalized capitalization and unnecessary message]