Active Reports

[CsaaGuy]

I get OS errors when I run active reports from code.

The first error is with this code (beware of the commented out code)
Dim oPrinter As New System.Drawing.Printing.PrintDocument
oPrinter.PrinterSettings.PrinterName = "\\CSSFVPNT01\PSFB1F2BL01"
Dim oReport As New Report01
'oReport.Document.Printer.PrinterName = "\\CSSFVPNT01\PSFB1F2BL01"
oReport.ds.SQL = "Select * from tblAssignments, tblUsers where
ClaimNumber = '08-M63254-4' and tblUsers.UserID =
tblAssignments.AdjusterId"
oReport.ds.ConnectionString =
ConfigurationSettings.AppSettings("ConnectionStrin gTLW")
oReport.Run()
oReport.Document.Print(False, False)

I get this error:

An unhandled exception of type
'System.Runtime.Serialization.SerializationExcepti on' occurred in
Unknown Module.

Additional information: The type
System.Drawing.Printing.InvalidPrinterException in Assembly
System.Drawing, Version=1.0.5000.0, Culture=neutral,
PublicKeyToken=b03f5f7f11d50a3a is not marked as serializable.

If i run it with this code (beware of the commented out code)

'Dim oPrinter As New System.Drawing.Printing.PrintDocument
'oPrinter.PrinterSettings.PrinterName = "\\CSSFVPNT01\PSFB1F2BL01"
Dim oReport As New Report01
oReport.Document.Printer.PrinterName = "\\CSSFVPNT01\PSFB1F2BL01"
oReport.ds.SQL = "Select * from tblAssignments, tblUsers where
ClaimNumber = '08-M63254-4' and tblUsers.UserID =
tblAssignments.AdjusterId"
oReport.ds.ConnectionString =
ConfigurationSettings.AppSettings("ConnectionStrin gTLW")
oReport.Run()
oReport.Document.Print(False, False)

I get this error:
An unhandled exception of type 'System.ComponentModel.Win32Exception'
occurred in Unknown Module.

Additional information: The RPC server is unavailable

As a Note, the report works in the webviewer.

Thanks.

[Steve C. Orr [MVP, MCSD]]

By default ASP.NET runs under the ASPNET user account, which has limited
permissions. Specifically, this account does not have access to any
printers. All the errors you recieved are related to this fact. Therefore
you'll likely have better luck using impersonation to have ASP.NET run under
another account.

Here's more info on impersonation:
http://msdn.microsoft.com/library/de...ersonation.asp

--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://SteveOrr.net
"CsaaGuy" <ro********@csaa.com> wrote in message
news:11*********************@g47g2000cwa.googlegro ups.com...

I get OS errors when I run active reports from code.

The first error is with this code (beware of the commented out code)
Dim oPrinter As New System.Drawing.Printing.PrintDocument
oPrinter.PrinterSettings.PrinterName = "\\CSSFVPNT01\PSFB1F2BL01"
Dim oReport As New Report01
'oReport.Document.Printer.PrinterName = "\\CSSFVPNT01\PSFB1F2BL01"
oReport.ds.SQL = "Select * from tblAssignments, tblUsers where
ClaimNumber = '08-M63254-4' and tblUsers.UserID =
tblAssignments.AdjusterId"
oReport.ds.ConnectionString =
ConfigurationSettings.AppSettings("ConnectionStrin gTLW")
oReport.Run()
oReport.Document.Print(False, False)

I get this error:

An unhandled exception of type
'System.Runtime.Serialization.SerializationExcepti on' occurred in
Unknown Module.

Additional information: The type
System.Drawing.Printing.InvalidPrinterException in Assembly
System.Drawing, Version=1.0.5000.0, Culture=neutral,
PublicKeyToken=b03f5f7f11d50a3a is not marked as serializable.

If i run it with this code (beware of the commented out code)

'Dim oPrinter As New System.Drawing.Printing.PrintDocument
'oPrinter.PrinterSettings.PrinterName = "\\CSSFVPNT01\PSFB1F2BL01"
Dim oReport As New Report01
oReport.Document.Printer.PrinterName = "\\CSSFVPNT01\PSFB1F2BL01"
oReport.ds.SQL = "Select * from tblAssignments, tblUsers where
ClaimNumber = '08-M63254-4' and tblUsers.UserID =
tblAssignments.AdjusterId"
oReport.ds.ConnectionString =
ConfigurationSettings.AppSettings("ConnectionStrin gTLW")
oReport.Run()
oReport.Document.Print(False, False)

I get this error:
An unhandled exception of type 'System.ComponentModel.Win32Exception'
occurred in Unknown Module.

Additional information: The RPC server is unavailable

As a Note, the report works in the webviewer.

Thanks.

[CsaaGuy]

Steve C. Orr [MVP, MCSD] wrote:

By default ASP.NET runs under the ASPNET user account, which has limited
permissions. Specifically, this account does not have access to any
printers. All the errors you recieved are related to this fact. Therefore
you'll likely have better luck using impersonation to have ASP.NET run under
another account.

Here's more info on impersonation:
http://msdn.microsoft.com/library/de...ersonation.asp

--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://SteveOrr.net

It does some and thanks. I curious, why does it run from the web viewer?

[Steve C. Orr [MVP, MCSD]]

The web viewer sounds like a client side component, and the client does have
access to the printer.

--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://SteveOrr.net
"CsaaGuy" <ro********@csaa.com> wrote in message
news:11*********************@g14g2000cwa.googlegro ups.com...

Steve C. Orr [MVP, MCSD] wrote:

By default ASP.NET runs under the ASPNET user account, which has limited
permissions. Specifically, this account does not have access to any
printers. All the errors you recieved are related to this fact.
Therefore
you'll likely have better luck using impersonation to have ASP.NET run
under
another account.

Here's more info on impersonation:
http://msdn.microsoft.com/library/de...ersonation.asp

--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://SteveOrr.net

It does some and thanks. I curious, why does it run from the web viewer?

[CsaaGuy]

Ah, thats it. Its an Activex Report Viewer. Thank you again.
Steve C. Orr [MVP, MCSD] wrote:

The web viewer sounds like a client side component, and the client does have
access to the printer.

--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://SteveOrr.net
"CsaaGuy" <ro********@csaa.com> wrote in message
news:11*********************@g14g2000cwa.googlegro ups.com...

Steve C. Orr [MVP, MCSD] wrote:

By default ASP.NET runs under the ASPNET user account, which has limited
permissions. Specifically, this account does not have access to any
printers. All the errors you recieved are related to this fact.
Therefore
you'll likely have better luck using impersonation to have ASP.NET run
under
another account.

Here's more info on impersonation:
http://msdn.microsoft.com/library/de...ersonation.asp

--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://SteveOrr.net

It does some and thanks. I curious, why does it run from the web viewer?