Crystal Report needs further info

[SSesham]

I get
"The report you requested requires further information"
no matter what i do to run a report, it displays few text boxes for entering login info on the IE 7.0

.NET 2005 (c#) front end
CR 10 advanced developer

ours is a table driven report display system.the user clicks on a report and based on the report i create a dataset and return it to report document. The reportdocument binds to crystalreport viewer and displays report. here is the code.

GetCrystalData is a method and is querying and returning data from SQl server 2000 in the form of a dataset. when i see ds in the debug mode it has data as well!

DataSet ds = new DataSet();
ds = GetCrystalData(m_sp_name, m_viewname, Request.QueryString["timeperiod"], m_ad_sp_name, m_ad_table_array, m_req_sp_params);

myReport.SetDataSource(ds);
CrystalReportViewer1.EnableDrillDown = true;

CrystalReportViewer1.ReportSource = myReport;
CrystalReportViewer1.DataBind();

Any ideas on fixing this please reply back..thank you very much in advance.

 

[dgillz]

If you run this report in crystal reports designer and not in another application, does it run?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[SSesham]

Yes! It runs fine in crystal designer.
Its looking for a DSN defaults to that even though i'm giving it a report document with data in it. the crystal viewer is not binding well with the report document looks like! i dont understand where this dsn is coming from that its defaulting to on the web page..?

 

[dgillz]

So it is an error in the .net code, not crystal itself.

You are probably in the wrong forum.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[SSesham]

I figured it myself!

here is the code that will end this problem...

myReport.Load(m_crystalfilename);
DataSet ds = new DataSet();
ds = GetCrystalData();

for (int tableIndex =0;tableIndex<ds.Tables.Count;tableIndex++)
{
myReport.Database.Tables[tableIndex].SetDataSource(ds.Tables[tableIndex]);
}

getcrysstaldata() is a methodcall that connects to database and returns dataset (i got rid of parameters for simplicity)

PS: if you see logon parameters while dynamically supplying a dataset to crystal use this logic and it will go away..

thanks,

srinath