CODEWITHSUNDEEP
c#asp.netcrystal-reports
Joe Gayetty
Joe Gayetty

Reputation: 1561

Crystal Report generates on dev box, but not web server

I have a CrystalReportViewer control on an ASPX page. On my development machine the Crystal Report generates properly. However, when I publish it and run it on a web server I get the following pop-up screen. Entering in the password does nothing. The same screen just pops up again:

enter image description here

The datasource is configured in the .rpt file. So my code on the CrystalReportViewer is simply the following:

if (Request.QueryString["report"].ToString() != "")
{
    ReportDocument doc = new ReportDocument();
    doc.Load(Request.QueryString["report"].ToString());
    CrystalReportViewer1.ReportSource = doc;
}

If it helps, some of the (more important looking) datasource properties in the .rpt file are as follows:

Also, I have the same ODBC/System DSN (named plmprod) setup on my development machine and on the web server. Using the "Test Connection" option they both test successfully.

I am not sure how to troubleshoot this issue. Nor do I know much about Crystal Reports.

What could be the problem that is causing the report to not generate on the web server?

Upvotes: 0

Views: 239

Answers (1)

Joe Gayetty
Joe Gayetty

Reputation: 1561

I created a 64 bit ODBC/DSN on the web server and it now works!

All of my Crystal Reports Windows apps work fine around the company with 32 bit DSNs so I made a false assumption that is what the web server would want as well...not so as I found out.

Upvotes: 1

Related Questions