C# ReportView Error

Hello Team, I developed C# windowform Application and the print reportview is working perfectly but after a publish it and when I want to print data, I get this ERROR: Value cannot be null.
Parameter name:dataTable

In the report properties I change the follow.

Build Action: Content

Copy to Output: Copy Always

This is my report code

public void LoadReport()
{
ReportDataSource rptDS;
try
{
reportViewer1.LocalReport.ReportPath = Application.StartupPath + @"\ReportData\rptInventory.rdlc";
reportViewer1.LocalReport.DataSources.Clear();
AtteyDataSet3 ds = new AtteyDataSet3();
SqlDataAdapter da = new SqlDataAdapter();

cn.Open();
da.SelectCommand = new SqlCommand("select p.pcode, p.barcode, p.pdescription, b.brand, c.category, p.price, p.qty, p.reorder from tblProduct as p inner join tblBrand as b on p.bid = b.id inner join tblCategory as c on p.cid=c.id", cn);
da.Fill(ds.Tables["dtInventory"]);

cn.Close();
rptDS = new ReportDataSource("AtteyDataSet3", ds.Tables["dtInventory"]);
reportViewer1.LocalReport.DataSources.Add(rptDS);
reportViewer1.SetDisplayMode(Microsoft.Reporting.WinForms.DisplayMode.PrintLayout);
reportViewer1.ZoomMode = ZoomMode.Percent;
reportViewer1.ZoomPercent= 100;
}catch(Exception ex)
{
cn.Close();
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}

Here are a few suggestions to troubleshoot the issue:

Verify that the SQL query select p.pcode, p.barcode, p.pdescription, b.brand, c.category, p.price, p.qty, p.reorder from tblProduct as p inner join tblBrand as b on p.bid = b.id inner join tblCategory as c on p.cid=c.id is returning the expected results when executed against your database. You can try running this query directly in your database management tool to check for any errors or empty results.
Ensure that the connection string cn is properly configured and valid. Double-check the connection details, such as the server name, database name, and credentials, to ensure they are accurate.
Check if the ds.Tables["dtInventory"] table is populated correctly after executing the data adapter's Fill method. You can add a breakpoint at da.Fill(ds.Tables["dtInventory"]) and inspect the ds.Tables["dtInventory"] table in debug mode to verify its contents.
Make sure that the report file "rptInventory.rdlc" is present in the specified location (Application.StartupPath + @"\ReportData\rptInventory.rdlc") and that it contains the necessary report design and placeholders for the dataset.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Rajkiran Swain3y ago
Accepted answer
Here are a few suggestions to troubleshoot the issue:
1. Verify that the SQL query select p.pcode, p.barcode, p.pdescription, b.brand, c.category, p.price, p.qty, p.reorder from tblProduct as p inner join tblBrand as b on p.bid = b.id inner join tblCategory as c on p.cid=c.id is returning the expected results when executed against your database. You can try running this query directly in your database management tool to check for any errors or empty results.
2. Ensure that the connection string cn is properly configured and valid. Double-check the connection details, such as the server name, database name, and credentials, to ensure they are accurate.
3. Check if the ds.Tables["dtInventory"] table is populated correctly after executing the data adapter's Fill method. You can add a breakpoint at da.Fill(ds.Tables["dtInventory"]) and inspect the ds.Tables["dtInventory"] table in debug mode to verify its contents.
4. Make sure that the report file "rptInventory.rdlc" is present in the specified location (Application.StartupPath + @"\ReportData\rptInventory.rdlc") and that it contains the necessary report design and placeholders for the dataset.