Solved

How do I setup Crystal Reports 2008 on a remote webserver running Server 2008?

Posted on 2009-07-13
7
889 Views
Last Modified: 2013-11-15
How do I setup Crystal Reports 2008 on a remote webserver running Server 2008 to deploy an asp.net web page with an embedded Crystal Report created with MS Visual Studio 2005 Pro?

Trying to implement the Crystal Report Viewer in our existing web application, have installed crystal reports 2008 and registered, not sure about the merge modules the business objects website has lots of dead links to those downloads.

When I copy over the web.config file and try to load any of the web applications pages I get an Error: 500 in the web browser.

I have changed the version to ver. 12 in the web.config code also, there has to be an easier way to do this!
0
Comment
Question by:prlit
  • 4
  • 3
7 Comments
 
LVL 100

Expert Comment

by:mlmcc
ID: 24856123
Did you use the CR2008 dlls when you built the application?

mlmcc
0
 
LVL 1

Author Comment

by:prlit
ID: 24857963
I was not sure where to find these dlls or how to install the merge modules, when I build the website locally (CR for VS 2005) on the dev machine they work perfectly.

When deployed to our web server (CR 2008 Installed) they do not, nor will the rest of our application after the web.config file references crystal report assemblies.

I downloaded the merge modules but cant find the documentation on how to install
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 24861943
What includes did you use in the application?

mlmcc
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
LVL 1

Author Comment

by:prlit
ID: 24862183
Here is my web.config file, all assemblies referenced by the application are here, ASP.NET/VB web pages import name spaces but I believe this is what you are referring to as includes.

The version of CR is 2008 Version=12.0.0.683 on the server and the local dev machine for VS 2005 version is 10.2.3600.0, so I had to modify the web.config file to the newer version:

<?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
--><configuration>
 <connectionStrings/>
      <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.
        -->
            <compilation debug="true" strict="false" explicit="true">
                  <assemblies>
                        <add assembly="CrystalDecisions.CrystalReports.Engine, Version=12.0.0.683, Culture=neutral, PublicKeyToken=692fbea5521e1304"/>
                        <add assembly="CrystalDecisions.ReportSource, Version=12.0.0.683, Culture=neutral, PublicKeyToken=692fbea5521e1304"/>
                        <add assembly="CrystalDecisions.Shared, Version=12.0.0.683, Culture=neutral, PublicKeyToken=692fbea5521e1304"/>
                        <add assembly="CrystalDecisions.Web, Version=12.0.0.683, Culture=neutral, PublicKeyToken=692fbea5521e1304"/>
                        <add assembly="CrystalDecisions.ReportAppServer.ClientDoc, Version=12.0.0.683, Culture=neutral, PublicKeyToken=692fbea5521e1304"/>
                        <add assembly="CrystalDecisions.Enterprise.Framework, Version=12.0.0.683, Culture=neutral, PublicKeyToken=692fbea5521e1304"/>
                        <add assembly="CrystalDecisions.Enterprise.InfoStore, Version=12.0.0.683, Culture=neutral, PublicKeyToken=692fbea5521e1304"/></assemblies></compilation>
            <customErrors mode="Off"/>
            <pages>
                  <namespaces>
                        <clear/>
                        <add namespace="System"/>
                        <add namespace="System.Collections"/>
                        <add namespace="System.Collections.Specialized"/>
                        <add namespace="System.Configuration"/>
                        <add namespace="System.Text"/>
                        <add namespace="System.Text.RegularExpressions"/>
                        <add namespace="System.Web"/>
                        <add namespace="System.Web.Caching"/>
                        <add namespace="System.Web.SessionState"/>
                        <add namespace="System.Web.Security"/>
                        <add namespace="System.Web.Profile"/>
                        <add namespace="System.Web.UI"/>
                        <add namespace="System.Web.UI.WebControls"/>
                        <add namespace="System.Web.UI.WebControls.WebParts"/>
                        <add namespace="System.Web.UI.HtmlControls"/>
                  </namespaces>
            </pages>
            <!--
            The <authentication> section enables configuration
            of the security authentication mode used by
            ASP.NET to identify an incoming user.
        -->
            <authentication mode="Windows"/>
            <!--
            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 mode="RemoteOnly" defaultRedirect="GenericErrorPage.htm">
            <error statusCode="403" redirect="NoAccess.htm" />
            <error statusCode="404" redirect="FileNotFound.htm" />
        </customErrors>
        -->
      <httpHandlers><add verb="GET" path="CrystalImageHandler.aspx" type="CrystalDecisions.Web.CrystalImageHandler, CrystalDecisions.Web, Version=12.0.0.683, Culture=neutral, PublicKeyToken=692fbea5521e1304"/></httpHandlers></system.web>
       <location allowOverride="true" inheritInChildApplications="true">
           <appSettings>
               <add key="CrystalImageCleaner-AutoStart" value="true" />
               <add key="CrystalImageCleaner-Sleep" value="60000" />
               <add key="CrystalImageCleaner-Age" value="120000" />
           </appSettings>
       </location>
</configuration>
0
 
LVL 100

Accepted Solution

by:
mlmcc earned 500 total points
ID: 24864406
I think the problem is the application still wants to use the 10.2 dlls.

You need to install CR2008 on the DEV machine so you can include or import the correct dlls.

mlmcc
0
 
LVL 1

Author Comment

by:prlit
ID: 24903073
Worked Thank You!

If I get past this last dll error message I will have it!

Parser Error Message: Could not load file or assembly 'Microsoft.ReportViewer.WebForms, Version=8.0.50727.1843, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)

I can find these dlls in the C:\Windows\Assembly folder and they are the same version as the code points to, I also tried placing them in the bin folder of the apps directory.

These are the dlls that belong to Report Viewer:

Microsoft.ReportViewer.WebForms (Throws the error) - Provides the ReportViewer control for ASP.NET pages.

Microsoft.ReportViewer.Common - Provides core reporting functionality that is common to the ReportViewer Windows forms control and Web server control.
 
Microsoft.ReportViewer.ProcessingObjectModel - Exposes the report object model so that it can be accessed programmatically at run time from expressions in the report definition.
 
Microsoft.ReportViewer.WinForms - Provides the ReportViewer control for Windows applications.

Thanks for the CR tip worked nicely!
0
 
LVL 1

Author Closing Comment

by:prlit
ID: 31602781
Ran ReportViewer.exe on server and changed version in code and that last error disappeared.

Installing CR 2008 on the dev machine is what solved the major issue.

Worked like a charm! Thank You
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If I have to fix slow responding website my first thoughts are server side optimizations: the database may not be optimized or caching is not enabled, or things like that. We often overlook another major part of our web application: the client. We o…
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
This video teaches viewers how to create their own website using cPanel and Wordpress. Tutorial walks users through how to set up their own domain name from tools like Domain Registrar, Hosting Account, and Wordpress. More specifically, the order in…
Learn how to set-up custom confirmation messages to users who complete your Wufoo form. Include inputs from fields in your form, webpage redirects, and more with Wufoo’s confirmation options.

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question