Runtime error when opening crystal report from remote server

vensali
vensali used Ask the Experts™
on
I have published Asp.net webapplication in IIS7  of Remote server. I am able to open the application and work with all aspx pages. But when i try to open crystal report in viewer  it throws up the following msg.


Runtime Error
  Description: An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed remotely (for security reasons). It could, however, be viewed by browsers running on the local server machine.

Details: To enable the details of this specific error message to be viewable on remote machines, please create a <customErrors> tag within a "web.config" configuration file located in the root directory of the current web application. This <customErrors> tag should then have its "mode" attribute set to "Off".



<!-- Web.Config Configuration File -->

<configuration>
    <system.web>
        <customErrors mode="Off"/>
    </system.web>
</configuration>
 

Notes: The current error page you are seeing can be replaced by a custom error page by modifying the "defaultRedirect" attribute of the application's <customErrors> configuration tag to point to a custom error page URL.



<!-- Web.Config Configuration File -->

<configuration>
    <system.web>
        <customErrors mode="RemoteOnly" defaultRedirect="mycustompage.htm"/>
    </system.web>
</configuration>


But i am able to open the same through visual studio
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Commented:
WHat version of Crystal?
Some will have issues with IIS7

WHat application are you using to display the reports?

mlmcc

Author

Commented:
now I have another problem. In visual studio and local host  I am able to view the report.  When I publish to the remote server ( iis7)  and click on the print button on client  browser nothing is displayed on the client browser page. ( No Error message also)

I have copied the reports folder to the published folder on the remote server.  What might be issue ?

Author

Commented:
Report is developed in SAP Crystalreports for vs2010.  Report is viewed in crystal report viewer placed on aspx page.

Code in the said aspx page is as below

 Private Sub Page_Init(sender As Object, e As System.EventArgs) Handles Me.Init
        ip = Request.QueryString("ip")
        Dim objDis As New UCTrn_Clinical

        Dim ds As New DataSet

        ds = objDis.print(ip)

        If ds.Tables(0).Rows(0)("DS_ENTDATE").ToString = "" Then
            lblmsg.Visible = True
        Else
            lblmsg.Visible = False
            crystalReport.Load(Server.MapPath("~/Reports/DisSumRpt.rpt"))
            crystalReport.SetDataSource(ds.Tables(0))
            CrystalReportViewer1.ReportSource = crystalReport
            CrystalReportViewer1.RefreshReport()
        End If
       

    End Sub
HTML5 and CSS3 Fundamentals

Build a website from the ground up by first learning the fundamentals of HTML5 and CSS3, the two popular programming languages used to present content online. HTML deals with fonts, colors, graphics, and hyperlinks, while CSS describes how HTML elements are to be displayed.

Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Commented:
You have the Crystal display code inside the ELSE clause.

mlmcc

Author

Commented:
This is to check whether discharge summary is entered or not.  Only if the discharge summary is entered then only report is displayed.
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Commented:
Are you sure the dataset has data?

mlmcc

Author

Commented:
same application when opened from local machine works fine
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Commented:
WIll the recordset have more than 1 row?  You are only checking 1 row.

mlmcc

Author

Commented:
the dataset is having only one row
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Commented:
Have you displayed the data in the application?

Perhaps the arrays (because they are for Crystal) are 1 based.

mlmcc
Commented:
set enable 32 bit application in appl pool = true and it started working

Author

Commented:
set enable 32 bit application in appl pool = true and it started working

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial