Data retrieval failed for the subreport. Please check the log files for more information.

alibasha

SOLVED CLOSED ACTIVE ANSWERED
User: alibasha
Posted: on May 11, 2013 11:27 AM
Forum: Data Controls
Answer: 3
Views: 33289

Hi,

I am developing one Main rdlc Report Say "C" with Subreports A and B.Each report getting Data with different Datasources(DataSets).When Data is not coming for SubReports A and B, report is generated but I am getting the error message as Data retrieval failed for the subreport, 'Subreport1', located at:Location\SubTrade.rdlc. Please check the log files for more information. Please help me in this regard. Thanks in advance. Below is my piece of code.

private void ProcessMainReport()
{
LocalReport reportContractNote = new LocalReport();  
reportContractNote.SubreportProcessing += new SubreportProcessingEventHandler(prcProcessSubReport);
                    reportContractNote.ReportPath = ReportPath;
 ReportParameter recipientIDConsoCN = new ReportParameter(strparamRecipientIDConsoCN, RecipientID);
                    ReportParameter batchdateConsoCN = new ReportParameter(strparamBatchDateConsoCN, BatchDate.ToString());
                    ReportParameter transmittalreportIDConsoCN = new ReportParameter(strparamTransmittalReportIDConsoCN, TransmittalReportID.ToString());
                    ReportParameter datatypeConsoCN = new ReportParameter(strparamDataTypeConsoCN, DataType.ToString());
                    reportContractNote.SetParameters(new ReportParameter[] { recipientIDConsoCN, batchdateConsoCN, transmittalreportIDConsoCN, datatypeConsoCN });
                    DataTable dtConsolidatedContractNote = new DataTable();
                    dtConsolidatedContractNote = objBll.GetConsolidatedContractNoteData(RecipientID, BatchDate, TransmittalReportID, DataType);
                        reportContractNote.DataSources.Add(new ReportDataSource("DataSet1", dtConsolidatedContractNote));
}

private void prcProcessSubReport(object sender, SubreportProcessingEventArgs e)
{
DataTable dtSubReport = new DataTable();
           
            try
            {
 switch (e.ReportPath)
                {

                    case strSubTrade://Name of the Sub-report Trade Details
                        dtSubReport = objBll.GetTradeDetails(RecipientIDTradeDetails, BatchDateTradeDetails, TransmittalReportIDTradeDetails, 1);
 ReportDataSource rdsTradeDetails = new ReportDataSource("DataSet1", dtSubReport);
                        e.DataSources.Add(rdsTradeDetails);
  break;
  case strSubRecDisb://Name of the Sub-Report Cash Details
                        dtSubReport = objBll.GetCashDetails(RecipientIDCashDetails, BatchDateCashDetails, TransmittalReportIDCashDetails, 2);
ReportDataSource rdsCashDetails = new ReportDataSource("DataSet1", dtSubReport);
                        e.DataSources.Add(rdsCashDetails);
 break;
  default:
                        break;
}
}

  catch (Exception ex)
            {
                CommonFunctions.strTraceMsg = "Exception Occured in  Method *prcProcessSubReport*. Error message:" + ex.Message;
                if (CommonFunctions.strLogIsRequired == CommonFunctions.strLogYes)
                    objCommanFunc.LogEventToTextFile(CommonFunctions.strTraceMsg, CommonFunctions.strFilePath);

               string strErrorMsgContractNote = ex.Message;
               objCommanFunc.LogEventToEventViewer(strErrorMsgContractNote);
            }
finally
            {
                dtSubReport = null;
            }
}

Download FREE API for Word, Excel and PDF in ASP.Net

Mudassar

0 7

Reply
ANSWER
User: Mudassar
Replied: on May 13, 2013 01:58 AM
Report

That's because you are still not passing the DataSource to the reports. You need to pass the DataSource always and handle the condition in database query

Example, suppose you don't need to display records your SP or query must return 0 rows

Mudassar

0 9

Reply
ANSWER
User: Mudassar
Replied: on May 13, 2013 02:39 AM
Report

No you are not. You have used Case Stmts. Which means of the two conditions are not satisifed nothing is set as datasource for sub report

alibasha

0 10

Reply
ANSWER
User: alibasha
Replied: on May 13, 2013 03:44 AM
Report

Yahoo!!! It worked. You are true Mr. Mudassar. Thank you so much for your kind help. I was not binding DataSource to the Subreports in the case if DataTable has zero rows. Now I have modified my code,pls find my modifed code below..

private void prcProcessSubReport(object sender, SubreportProcessingEventArgs e)
{
DataTable dtSubReport = new DataTable();
ReportDataSource rdsSubReport;
try
{
switch (e.ReportPath)
{

case strSubTrade://Name of the Sub-report Trade Details
//Code to fill Data in DataTable and bind it to SubReport SubTrade(Trade Details)
dtSubReport = objBll.GetTradeDetails(RecipientIDTradeDetails, BatchDateTradeDetails, TransmittalReportIDTradeDetails, 1);
if (dtSubReport.Rows.Count < 0)
{
CommonFunctions.strTraceMsg = "Rdlc Report not loaded with Data!";
if (CommonFunctions.strLogIsRequired == CommonFunctions.strLogYes)
objCommanFunc.LogEventToTextFile(CommonFunctions.strTraceMsg, CommonFunctions.strFilePath);
}
else
{
CommonFunctions.strTraceMsg = "Rdlc SubReport SubTrade(Trade Details) has been called successfully with Data by passing parameters RecipientID" + RecipientIDTradeDetails + " Batch Date" + BatchDateTradeDetails + " TransmittalReportID" + TransmittalReportIDTradeDetails;
if (CommonFunctions.strLogIsRequired == CommonFunctions.strLogYes)
objCommanFunc.LogEventToTextFile(CommonFunctions.strTraceMsg, CommonFunctions.strFilePath);
}
rdsSubReport = new ReportDataSource("DataSet1", dtSubReport);
e.DataSources.Add(rdsSubReport);
//Code End
break;


case strSubRecDisb://Name of the Sub-Report Cash Details
//Code to fill Data in DataTable and bind it to SubReport SubRecDisb(Cash Details)
dtSubReport = objBll.GetCashDetails(RecipientIDCashDetails, BatchDateCashDetails, TransmittalReportIDCashDetails, 2);
if (dtSubReport.Rows.Count <= 0)
{
CommonFunctions.strTraceMsg = "Rdlc Report not loaded with Data!";
if (CommonFunctions.strLogIsRequired == CommonFunctions.strLogYes)
objCommanFunc.LogEventToTextFile(CommonFunctions.strTraceMsg, CommonFunctions.strFilePath);

}
else
{
strReturnValue = "Data Found for the Report with Transmittal Id" + TransmittalReportIDTradeDetails;
CommonFunctions.strTraceMsg = "Rdlc SubReport SubRecDisb(Cash Details) has been called successfully with Data by passing parameters RecipientID" + RecipientIDCashDetails + " Batch Date" + BatchDateCashDetails + " TransmittalReportID" + TransmittalReportIDCashDetails;
if (CommonFunctions.strLogIsRequired == CommonFunctions.strLogYes)
objCommanFunc.LogEventToTextFile(CommonFunctions.strTraceMsg, CommonFunctions.strFilePath);
}
rdsSubReport = new ReportDataSource("DataSet1", dtSubReport);
e.DataSources.Add(rdsSubReport);
//Code End
break;

default:
break;

}

}
catch (Exception ex)
{
CommonFunctions.strTraceMsg = "Exception Occured in Method *prcProcessSubReport*. Error message:" + ex.Message;
if (CommonFunctions.strLogIsRequired == CommonFunctions.strLogYes)
objCommanFunc.LogEventToTextFile(CommonFunctions.strTraceMsg, CommonFunctions.strFilePath);

string strErrorMsgContractNote = ex.Message;
objCommanFunc.LogEventToEventViewer(strErrorMsgContractNote);
}
finally
{
dtSubReport = null;
rdsSubReport = null;

}
}

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Data retrieval failed for the subreport. Please check the log files for more information.

Company

Explore

Follow us

Contact Us