Comments by lucasgrohl (Top 25 by date)

I check all the items.

I changed my DataTable1's fields name in my DataSet1 to the same name as it returns in my DataTable dtInvoiceDescriptionDetails

The values in the table in my Rdlc are:
=Fields!detail_description.Value / =Fields!detail_value.Value / =Fields!ind_taxible.Value
(the same name as in my datasource datatable)

I checked the data straight after it has been filled in on the code. It is full populated.

I changed the Dataset Name to "DataSet1_DataTable1".

And the Rdlc is in the project, so I don't need the add its path.

When I execute the programme there is no error. Only the data doesn't appear.
The table in my Rdlc shows the hearder with the name of the fields, but no data.

Any idea? =(

thanks!

Strogg,

I created a DataSet, named DataSet1, and added a DataTable in it, named DataTable1, with the fields "field1", "field2" and "field3".

I added the DataSet1 as a DataSource to my Report1.rdlc through the visual mode and dragged and dropped the DataTable1 fields into my table contained in my Report1.rdlc

Now, in the RepF_Load my code is filling in my DataTables as shown in my question and at the end I put the code:

private void RepF_Load(object sender, EventArgs e)
{ ...

reportViewer1.LocalReport.DataSources.Add(new Microsoft.Reporting.WinForms.ReportDataSource("DataSet1_DataTable1", dtInvoiceDescriptionDetails));

reportViewer1.RefreshReport();
}

But, when I execute the program it is still empty.

Do you have any idea of the reason this is not working yet?

Thanks! =)

Even when I create a public method that returns a DataTable I can`t find it when I add the class this method is contained in my Report1.rdlc data souces.

I tried the solution described on the link - http://www.gotreportviewer.com/objectdatasources/index.html

But when I create a method which returns a string, for example, I cant't see it after adding the class this method is contained as my RDLC data source.

Any idea?

PS: I am not using a DataSet. I only have those 5 DataTables. If it is really necessary to use a DataSet, how can I create a DataSet and Include those 5 DataTables into it?

Thanks!

Thanks a lot man! You really helped me! Now it works perfectly fine! =)

Now I think this is more clear =)

Principal -> Form that contains the GET property to access the textBox2.Text (where I already have the invoice number generated). This form uses newForm.ShowDialog()

newForm -> Form that needs to get the information contained in textBox2.Text to use as a clause in my SQL statement.

I think now it is more clear =)

I got it. Makes sense. In fact I am using showDialog() in the form where the user enter the invoice number to open the new form (the one I want to access the property in the parent form). But how can I access this variable (in the parent form)?

I asking you because what happens is, I have a form where an user enter all the details of an invoice (client, payment type, etc), and then the system generates automatically the invoice number. After that the user clicks on the button "Create invoice" and the system registers the invoice on the database and asks if the user wants to print it. If the user clicks yes, the system opens a new form containing a reportviewer and user the invoice number (generated in the parent form), to colect the rest of the informations on the database.

Got it?

The first point I got. But, I have 5 MySqlDataAdapters which fill 5 DataTables. Can I add these 5 MySqlDataAdapters into the same DataSet?

The second point I didn't get because I am using Microsoft Report Viewer, not Crystal Report.

Thanks! You helped a lot! =)

Thanks but the error occurs as well. I don't understand, do I have to initiate the Cells Content or any other thing?

Pawan Kiran
I replaced the code for the one you pasted above. What is happening now is:

1 - If one one the columns is empty (not even has been clicked), occurs the same error
2 - If both columns are filled, it works for the lines that are filled. But, when the for command reaches the last line (the blank line dataGridView creates automatically), occurs the same error

I think the second case will be solved if first one is solved. But, I am not understanding why it is not working if I also included the 'null' verification in the if conditions.

for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
if (dataGridView1.Rows[i].Cells["Column1"].Value.ToString().Length == 0 || dataGridView1.Rows[i].Cells["Column1"].Value == null && dataGridView1.Rows[i].Cells[1].Value.ToString().Length != 0)
{
MessageBox.Show("You must enter a description for each value.");
return;
}

if (dataGridView1.Rows[i].Cells["Column2"].Value.ToString().Length == 0 || dataGridView1.Rows[i].Cells["Column2"].Value == null && dataGridView1.Rows[i].Cells[0].Value.ToString().Length != 0)
{
MessageBox.Show("You must enter a value for each description.");
return;
}
}

Can you help me?

Thank you so much for the support you're giving me!

After I tried it, nothing happened. I mean, the code stopped at the same point as before.
I understand, in this case, both Cells are already initialized, right?

I replaced the previous code for:

for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
if (dataGridView1.Rows[i].Cells[0].Value.ToString().Length == 0 || dataGridView1.Rows[i].Cells[0].Value == null && dataGridView1.Rows[i].Cells[1].ToString().Length != 0)
{
MessageBox.Show("You must enter a description for each value.");
return;
}

if (dataGridView1.Rows[i].Cells[1].Value.ToString().Length == 0 || dataGridView1.Rows[i].Cells[0].Value == null && dataGridView1.Rows[i].Cells[0].ToString().Length != 0)
{
MessageBox.Show("You must enter a value for each description.");
return;
}
}

But the error persists =(

Hum, I see that. Thank you very much for the advice. For sure this is gonna solve many of my problems! =)

Thank you very much! That is exactly what I needed and now it is working fine =)

When I execute the application with this code it shows me the message: "Object reference not set to an instance of an object."

Any idea of what it can be?

PS: I set this column as typeof(double) in the Form Load event and I am also using a column format as C2(currency). In this case, after entering the value, it puts the symbol $ in front of the value. Can it interfere in anyway?

The problem is that this is for when I already have the data stored. In my case, the user is typing the values and the sum of all the cells of this columns has to be shown in run time in a label. =/