R – Crystal reports , the report you requested requires further information, login using ODBC DSN

crystal-reportsdsnodbc

The report is runnig fine in Visual Studio 2005 but fails when I deploy it on IIS. It prompts, the report you requested requires further information. I think it needs to get installed some service pack either of SQL server client, or of Crystal Reports. Please suggest.

Best Answer

You can set data source of your report by code at run time so your report don't need to connect to database.

CrystalReport1 report = new CrystalReport1();
DataTable dt = new DataTable();
report.SetDataSource(dt);
crystalReportViewer1.ReportSource = report;
crystalReportViewer1.Refresh();

Related Solutions

R – Visual Studio Crashes when using Crystal Reports Group Editor

Go to http://connect.microsoft.com/VisualStudio and search the bugs for hotfixes. If it hasn't been reported, report the bug with steps to reproduce.

[ StackOverflow isn't the place to report Visual Studio bugs :) ]

Crystal Reports – “The report you requested requires further information”

I have found the best way to fix a bug is to post the question to StackOverflow and 5 minutes later work it out yourself. Needless to say, I worked this out.

As well as setting all the log on info in the report objects, I also have to do it in the Crystal Viewer component in ASP.NET. So I just write some code like this and it all works, no prompts.

<CR:CrystalReportViewer Height="500px" ID="Viewer" runat="server" />

var connectionInfo = new ConnectionInfo();
    connectionInfo.ServerName = "192.168.x.xxx";
    connectionInfo.DatabaseName = "xxxx";
    connectionInfo.Password = "xxxx";
    connectionInfo.UserID = "xxxx";
    connectionInfo.Type = ConnectionInfoType.SQL;
    connectionInfo.IntegratedSecurity = false;

for (int i = 0; i < Viewer.LogOnInfo.Count; i++)
{
    Viewer.LogOnInfo[i].ConnectionInfo = connectionInfo;
}

Best Answer

Related Solutions

R – Visual Studio Crashes when using Crystal Reports Group Editor

Crystal Reports – “The report you requested requires further information”

Related Topic