I have searched through forums for a solution but none seem to work for me.
I have an ASP Webform/MySql application which displays Crystal Reports.
The ones which do not require a user to enter a parameter display fine and I am able to click on export on the CR toolbar and download, e.g. .pdf format.
On the report that require a user to enter a parameter, the report renders fine but when I click on the export button, i get the prompt:
"The report you requested requires further information"
asking for DB login credentials. How can I avoid this?
My Code:
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["report"] != null)
{
string reportToGet = Convert.ToString(Request.QueryString["report"]);
switch (reportToGet)
{
case "payslip":
PaySlip();
break;
case "pastpayslip":
PanelPastPaySlip.Visible = true;
break;
case "paysummary":
break;
case "pastpaysummary":
break;
default:
break;
}
}
}
protected void btnSearch_Click(object sender, EventArgs e)
{
if (txtDate.Text != null || txtDate.Text != string.Empty)
if (DateTime.TryParseExact(txtDate.Text, "yyyy-MM-dd", CultureInfo.InvariantCulture,
DateTimeStyles.None, out date))
PastPaySlip();
}
private void PastPaySlip() { // Some code..... PayMasterDataSetTableAdapters.pastpayslipcasualviewTableAdapter ta =
new PayMasterDataSetTableAdapters.pastpayslipcasualviewTableAdapter();
PayMasterDataSet.pastpayslipcasualviewDataTable dt = new PayMasterDataSet.pastpayslipcasualviewDataTable();
ta.FillBy(dt, userId, businessId);
cReport = new ReportDocument();
string reportPath = Server.MapPath("~/Views/CasualLabour/Reports/PastPaySlip.rpt");
cReport.Load(reportPath);
cReport.SetDataSource((DataTable)dt);
cReport.SetParameterValue("Date", date);
CrystalReportViewer1.ReportSource = cReport;
CrystalReportViewer1.ReuseParameterValuesOnRefresh = true;
Member
1 Points
11 Posts
Crystal Reports prompt issue on export: “The report you requested requires further information”
Aug 13, 2014 07:28 PM|kkjay|LINK
I have searched through forums for a solution but none seem to work for me.
I have an ASP Webform/MySql application which displays Crystal Reports.
The ones which do not require a user to enter a parameter display fine and I am able to click on export on the CR toolbar and download, e.g. .pdf format.
On the report that require a user to enter a parameter, the report renders fine but when I click on the export button, i get the prompt:
asking for DB login credentials. How can I avoid this?
My Code:
protected void Page_Load(object sender, EventArgs e) { if (Request.QueryString["report"] != null) { string reportToGet = Convert.ToString(Request.QueryString["report"]); switch (reportToGet) { case "payslip": PaySlip(); break; case "pastpayslip": PanelPastPaySlip.Visible = true; break; case "paysummary": break; case "pastpaysummary": break; default: break; } } }protected void btnSearch_Click(object sender, EventArgs e) { if (txtDate.Text != null || txtDate.Text != string.Empty) if (DateTime.TryParseExact(txtDate.Text, "yyyy-MM-dd", CultureInfo.InvariantCulture, DateTimeStyles.None, out date)) PastPaySlip(); }asp CrystalReports
All-Star
101931 Points
20703 Posts
Moderator
Re: Crystal Reports prompt issue on export: “The report you requested requires further informatio...
Aug 13, 2014 07:40 PM|MetalAsp.Net|LINK
Maybe you need to call the setdatabaselogon() method?
Or maybe try the solution here: http://forums.asp.net/t/1177298.aspx?Logon+failed+SetDatabaseLogon (Verify Database)
asp CrystalReports
Member
1 Points
11 Posts
Re: Crystal Reports prompt issue on export: “The report you requested requires further informatio...
Aug 13, 2014 07:52 PM|kkjay|LINK
Hi,
I have tried the SetDatabaseLogon method:
cReport.SetDatabaseLogon("userID", "password", "server", "db");But I still get the prompt.
asp CrystalReports