Data retrieval failed for the subreport, 'Subreport1', located at

Posted Jan 01, 1970 12:00 AM

I am trying to get a subreport working. I am using VS 2010. I've inserted a "Subreport1" into my main report and keep getting the error: Data retrieval failed for the subreport, 'Subreport1', located at....

Here's my code:

public partial class rptEngOrd : Form
{
    public rptEngOrd()
    {
        InitializeComponent();
    }

    private List<EngOrd> eoNumParam;
    private string eonum;
    private DataSet dsReport;
    private DataSet dsSubReport;

    private void rptEngOrd_Load(object sender, EventArgs e)
    {
        LoadComboBoxes();
    }

    private void LoadComboBoxes()
    {
        try
        {
            eoNumParam = EngOrdDB.GetDistinctEONum();
            cboEONum.DataSource = eoNumParam;
            cboEONum.SelectedIndex = -1;

        }
        catch (Exception ex)
        {
            MessageBox.Show(ex.Message, ex.GetType().ToString());
        }
    }

    private void btnPreview_Click(object sender, EventArgs e)
    {
        try
        {

            if (cboEONum.SelectedValue.ToString().Equals("zALL"))
            {
                eonum = "";
            }
            else
            {
                eonum = cboEONum.SelectedValue.ToString();
            }

            //get the data
            dsReport = EngOrdDB.GetEngOrdbyEONum(eonum);

            //provide local report information to viewer
            reportViewer1.LocalReport.ReportEmbeddedResource = "CustomMenu.rptEngOrd.rdlc";
            reportViewer1.ProcessingMode = ProcessingMode.Local;

            //prepare report data source
            ReportDataSource rds = new ReportDataSource();
            rds.Name = "dsReport";
            rds.Value = dsReport.Tables[0];
            reportViewer1.LocalReport.DataSources.Clear();
            reportViewer1.LocalReport.DataSources.Add(rds);

            //prepare sub report data source
            dsSubReport = EngOrdTaskDB.GetEngOrdTaskbyEONum(eonum);
            ReportDataSource rdsSub = new ReportDataSource();
            rdsSub.Name = "dsSubReport";
            rdsSub.Value = dsSubReport.Tables[0];
            reportViewer1.LocalReport.DataSources.Add(rdsSub);
            reportViewer1.LocalReport.SubreportProcessing += new SubreportProcessingEventHandler(srptProcessingEventHandler);

            //load the report viewer
            reportViewer1.LocalReport.Refresh();


            //MessageBox.Show(eonum);

        }
        catch (Exception ex)
        {
            //display generic message back to user
            MessageBox.Show(ex.Message);
        }
        finally
        {
        }

        reportViewer1.RefreshReport();

    }

    private void srptProcessingEventHandler(object sender, SubreportProcessingEventArgs e)
    {
        ReportDataSource r = reportViewer1.LocalReport.DataSources[1];
        e.DataSources.Add(r);

    }       

}

Similar Topic Questions

Data retrieval failed for the subreport, Please check the lo

Please anybody can help me who have faced the same above problem while calling RDLC Subreport in winform. I have 2 tables 1) BankAccount & 2)BankAccountDetail. The relation between the two is by using bankCode field. Now I want to...

Posted Nov 30, -0001 12:00 AM

Do I need a database to save a finite set of data, and only for the current session in an ASP.NET MVC app?

I'm working on a calculator type app, three different views to perform three different types of calculations. For example purposes lets say it's just a multiplication table. I want to be able to enter the factors, have the products update, then...

Posted Jan 10, 2014 1:03 AM

ASP.NET IIS6, Forms authentication failed for the request. Reason: The ticket supplied was invalid

Some of you may be familiar with this error and I've tried fixes, i've been bashing my head up a brick wall at this the past day and need some help from someone, somewhere :) Situation: I've got a website that was...

Posted Mar 14, 2011 6:14 AM

What technology does facebook uses for the multiple uploading images at once

I want to make a web application that will allow uploading many images at once but to work also on mobiles. I used html5, this works for IOS phones but on android doesn't work. If i look at facebook, they...

Posted Apr 04, 2014 5:54 AM

"No data exists for the row/column" when connecting to SQL database from VB.net

I'm trying to create a program which has a datagridview, when the user clicks on a cell in the view, it then looks in a SQL database, grabs information from other fields in the same record, and automatically fills corresponding...

Posted Nov 20, 2013 1:15 AM

What's the minimum requirement for the DataSource property of ASPX server side data-bound controls?

I'm trying to trace back the minimum type requirement of a data source that can be assigned to the DataSource property of data-bound ASP.NET controls. I remember that I did this many times earlier every time with a few months or...

Posted Sep 05, 2013 3:28 AM

System.Data.SqlClient.SqlException: Login failed for user 'sumit'

I got this when i run my page plz help me Server Error in '/' Application. Login failed for user 'sumit'. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about...

Posted Nov 25, 2013 7:03 AM

Alternative method for pivot in sql for data retrieval

I am searching for an efficient method for horizontal aggregations in SQL other than pivot and case. What would be the best alternative method to create a pivot other than using groupby and orderby clauses. Let FV be a table containing...

Posted Nov 26, 2013 11:48 AM

What is the format for the data source - Oracle DB Connection

I am trying to connect to an oracle data base in c# .net 4.5. I am using the Oracle.ManagedDataAccess.Client reference and I want to access my database table called Masterfile under the WD schema. I have toad for oracle running and the...

Posted Dec 06, 2013 10:55 AM

Wordament Solver - Data Structure for the Dictionary?

I am working on implementing a Wordament solver and I'm considering using an unordered_map as the data structure to hold my Dictionary. My problem is I don't understand how I can search through the map effeciently. Here is the...

Posted Dec 14, 2013 6:07 AM

Looking for the a better solution for data-driven web application

I am looking to rebuild our internal database-driven web application. Our daily operations relied on calling stored procedures and invoking web services in an online environment. The previous developer has build the system base on Webfuser. (see http://www.webfuser.com/PortalSite.aspx ) -...

Posted Dec 16, 2013 10:13 AM

Best place to store the trial data for the web application

After reading a lot of SO topics about how to design a trial for the desktop software I still have some questions about trial for Web Application. I have a ASP.Net MVC Web Application and I'm offering a time limited trial...

Posted Dec 17, 2013 11:48 AM

Model data for the given tables [on hold]

Assume that there is one train running from Chennai to Madurai so the train starts at Chennai and the train will pass via salem via trichy to reach Madurai, so can anyone help me out to how to fill the below...

Posted Dec 27, 2013 11:41 AM

Spreadsheets gets corrupted for the data size more than 7 MB [on hold]

Am writing an Excel file more than 7 MB using PEAR Spreadsheet_WriteExcel but the excel file is getting corrupted...

Posted Jan 01, 2014 8:34 AM

How to set session for the data in the get method of the function in javascript

I am using translation cloud for language translation in my website, Since by this script it translating for the page which is loaded and if we refresh or another page,the language changes to default language as English. I want...

Posted Jan 03, 2014 1:23 AM

Displays data for the youngest girl?

Compile program functions for: -Enter of a keyboard and a file into an array (by adding) data to 30 girls in the competition "Miss World" number, name, surname, date of birth, physical data, state and display the current contents of the array...

Posted Jan 09, 2014 4:33 AM

The requested page cannot be accessed because the related configuration data for the page is invalid error

I want to upload my own asp.net website on the IIS through IIS manager. But when I do this I get the following error HTTP Error 500.19 - Internal Server Error The requested page cannot be ...

Posted Feb 09, 2012 11:56 AM

Pattern for data retrieval from persistence layer

Consider you have a very huge and complex product database where you want to filter on several fields. For querying I use a denormalized Elasticsearch database. Now you want to display a list (around 300) related categories on the page,...

Posted Jan 11, 2014 5:13 AM

Store matrix data in SQLite for fast retrieval in R

I have 48 matrices of dimensions 1,000 rows and 300,000 columns where each column has a respective ID, and each row is a measurement at one time point. Each of the 48 matrices is of the same dimension and their...

Posted Jan 12, 2014 3:46 AM

 
 
Email:

Username:

Password:


Register

Username:

Password:

Login


Forgot Password
Reset my password!