Deployment error with CR XI R2 on Windows Server

Hot Topic

Help still broken
OperationContracts and parameters
Migration from Clearcase to VSS
Implement similar behavior as http:// address for Network File Path in word
TFS Version Control with Visual Studio 2003 ?
MouseDown event in an image
Automation in SS 2005
VS 2005 and Release 2 in asp.net web reporting Errors
2.0 deployment?
svg + xaml

Visual Studio

Binding a WrapPanel's ItemWidth to a Grid's Column width ...
AuthorizationDomain class gone in FebCTP
Problem with sorting in a ListView
How to send credentials to reportserver with webform reportviewer??
Vista Beta 2 IIS7 setup
2005 debugger is very slow
Word Macro to create a footer only for current page
Crystal reports
How do I add a Search filter for my dev language?
Run a target if a specific file is updated.

Deployment error with CR XI R2 on Windows Server

Crystal Reports XI Release 2. Deployed on Windows Server. Built with VS 2005.

I'm trying to get my first web deployment of CR going. I'm getting the following error:

Failed to open the connection. Failed to open the connection. C:\WINDOWS\TEMP\ReedCorpReport {046213D8-2B13-4959-9F93-525104CB2FB3}.rpt

CrystalReportViewer - myCrystalReportViewer

Error: Object reference not set to an instance of an object.

I built the Crystal Report web app using the tutorial and it works fine on my development PC. (like everyone else!)

Here is my code, Default.aspx, Default.aspx.vb, and web.config.

I apologize ahead of time for the amount of code I pasted into thread but I am very frustrated and hope someone can lend a hand.

Thanks for any insight on this:

Kevin

=======================

Option Strict On

Imports CrystalDecisions.CrystalReports.Engine

Imports CrystalDecisions.Shared

Imports System.Collections

Partial Class _Default

Inherits System.Web.UI.Page

Private Const PARAMETER_FIELD_NAME As String = "Enterprise"

Private Sub ConfigureCrystalReports()

Dim reportPath As String

reportPath = Server.MapPath("reports\ReedCorpReport.rpt")

Dim myConnectionInfo As ConnectionInfo = New ConnectionInfo()

myConnectionInfo.ServerName = "My Server Name"

myConnectionInfo.DatabaseName = "My Database Name"

myConnectionInfo.UserID = "My User ID"

myConnectionInfo.Password = "My User ID Password"

Dim myArrayList As ArrayList = New ArrayList()

myArrayList.Add("29")

myArrayList.Add("36")

myCrystalReportViewer.ReportSource = reportPath

Dim myParameterFields As ParameterFields = myCrystalReportViewer.ParameterFieldInfo

SetCurrentValuesForParameterField(myParameterFields, myArrayList)

SetDBLogonForReport(myConnectionInfo)

End Sub

Protected Sub Page_Init(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Init

ConfigureCrystalReports()

End Sub

Private Sub SetDBLogonForReport(ByVal myConnectionInfo As ConnectionInfo)

Dim myTableLogOnInfos As TableLogOnInfos = myCrystalReportViewer.LogOnInfo

For Each myTableLogOnInfo As TableLogOnInfo In myTableLogOnInfos

myTableLogOnInfo.ConnectionInfo = myConnectionInfo

End Sub

Private Sub SetCurrentValuesForParameterField(ByVal myParameterFields As ParameterFields, ByVal myArrayList As ArrayList)

Dim currentParameterValues As ParameterValues = New ParameterValues()

For Each submittedValue As Object In myArrayList

Dim myParameterDiscreteValue As ParameterDiscreteValue = New ParameterDiscreteValue()

myParameterDiscreteValue.Value = submittedValue.ToString()

currentParameterValues.Add(myParameterDiscreteValue)

Dim myParameterField As ParameterField = myParameterFields(PARAMETER_FIELD_NAME)

myParameterField.CurrentValues = currentParameterValues

End Sub

End Class

=================================================

My Default.aspx page with the Crystal Viewer looks like this:

<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default" %>

<%@ Register Assembly="CrystalDecisions.Web, Version=11.5.3700.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"

Namespace="CrystalDecisions.Web" TagPrefix="CR" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<title>Untitled Page</title>

</head>

<body>

<div>

<CR:CrystalReportViewer ID="myCrystalReportViewer" runat="server" AutoDataBind="true" />

</div>

</form>

</body>

</html>

=================================================

My web.config

< xml version="1.0" >

<!--

Note: As an alternative to hand editing this file you can use the

web admin tool to configure settings for your application. Use

the Website->Asp.Net Configuration option in Visual Studio.

A full list of settings and comments can be found in

machine.config.comments usually located in

\Windows\Microsoft.Net\Framework\v2.x\Config

-->

</appSettings>

<system.web>

<!--

Set compilation debug="true" to insert debugging

symbols into the compiled page. Because this

affects performance, set this value to true only

during development.

Visual Basic options:

Set strict="true" to disallow all data type conversions

where data loss can occur.

Set explicit="true" to force declaration of all variables.

-->

<pages>

</namespaces>

</pages>

<!--

The <authentication> section enables configuration

of the security authentication mode used by

ASP.NET to identify an incoming user.

-->

<!--

The <customErrors> section enables configuration

of what to do if/when an unhandled error occurs

during the execution of a request. Specifically,

it enables developers to configure html error pages

to be displayed in place of a error stack trace.

</customErrors>

-->

</configuration>

Answer this question