Report view not printing current sales

public void LoadReport()
{
    ReportDataSource rptReportDataSource;
    try
    {
        this.reportViewer1.LocalReport.ReportPath = Application.StartupPath + @"\rptReceipt.rdlc";
        this.reportViewer1.LocalReport.DataSources.Clear();

        foreach (DataGridViewRow dgvRow in DVBClientBill.Rows)
        {
            DataRow dataRow = dtReceipt.NewRow();

            // Assuming column indexes or names match the DataGridView columns
            dataRow["SName"] = dgvRow.Cells["SName"].Value?.ToString(); // Change the SName with actual DVBClientBill colunm name
            dataRow["SDate"] = Convert.ToDateTime(dgvRow.Cells["SDate"].Value);
            dataRow["SProductName"] = dgvRow.Cells["SProductName"].Value?.ToString();
            dataRow["SPrice"] = Convert.ToDecimal(dgvRow.Cells["SPrice"].Value);
            dataRow["SQty"] = Convert.ToInt32(dgvRow.Cells["SQty"].Value);
            dataRow["SAmount"] = Convert.ToDecimal(dgvRow.Cells["SAmount"].Value);

            dtReceipt.Rows.Add(dataRow);
        }

        ReportParameter pTotal = new ReportParameter("pTotal", fm.lblGrandTotal.Text);
        ReportParameter pStore = new ReportParameter("pStore", store);
        ReportParameter pAddress = new ReportParameter("pAddress", address);
        ReportParameter pPhone = new ReportParameter("pPhone", phone);

        reportViewer1.LocalReport.SetParameters(pTotal);
        reportViewer1.LocalReport.SetParameters(pStore);
        reportViewer1.LocalReport.SetParameters(pAddress);
        reportViewer1.LocalReport.SetParameters(pPhone);
        rptReportDataSource = new ReportDataSource("DataSet1", dataTable);
        reportViewer1.LocalReport.DataSources.Add(rptReportDataSource);
        reportViewer1.SetDisplayMode(Microsoft.Reporting.WinForms.DisplayMode.PrintLayout);
       
    }
    catch (Exception ex)
    {
        MessageBox.Show(ex.Message);
    }
}

After the data saved into the database then only you can able to print the data . 

if there concern please comment

  I bind DGVClientBill DataGridView to frmPrintReceipt as indicated in the code, but my question is how do I include my dataTable content and as well the DGVClientBill DataGridView  content here please, thank you

frmBilling fm;

 public frmPrintReceipt(frmBilling fmliist)
        {
            InitializeComponent();
            this.fm = fmliist;
        }

 foreach (DataGridViewColumn dgvColumn in fm.DGVClientBill.Columns)
                {
                    dataTable.Columns.Add(dgvColumn.HeaderText);
                }

                foreach (DataGridViewRow dgvRow in fm.DGVClientBill.Rows)
                {
                    DataRow dataRow = dataTable.NewRow();

                    foreach (DataGridViewCell dgvCell in dgvRow.Cells)
                    {
                        // Use DBNull.Value for empty cells
                       dataRow[dgvCell.ColumnIndex] = dgvCell.Value ?? DBNull.Value;
                                             
                    }

                    dataTable.Rows.Add(dataRow);
                }

And this is my DGVClientBill DataGridView

dgvIDD
dgvProduct
dgvSellingPrice2
dgvQunatity
dgvTotal

Thank you Amity,

Please do I need to use my DataTable content here, because after applying your code, this what came 

dataRow[dgvCell.ColumnIndex] = dgvCell.Value ?? DBNull.Value;

when I modify it like this, I get an error like the name SProductName does not exist in the current context, dataRow[dgvCell.ColumnIndex] = dgvCell.Value ?? SProductName; 

and this is my DataTable

If you want to use DVBClientBill to print the sales receipt, then store the DVBClientBill data to a datatable and use that datable in your LoadReport().

public void LoadReport()
{
    ReportDataSource rptReportDataSource;
    try
    {
        this.reportViewer1.LocalReport.ReportPath = Application.StartupPath + @"\rptReceipt.rdlc";
        this.reportViewer1.LocalReport.DataSources.Clear();

        DataTable dataTable = new DataTable();
        foreach (DataGridViewColumn dgvColumn in DVBClientBill.Columns)
        {
            dataTable.Columns.Add(dgvColumn.HeaderText);
        }

        foreach (DataGridViewRow dgvRow in DVBClientBill.Rows)
        {
            DataRow dataRow = dataTable.NewRow();

            foreach (DataGridViewCell dgvCell in dgvRow.Cells)
            {
                // Use DBNull.Value for empty cells
                dataRow[dgvCell.ColumnIndex] = dgvCell.Value ?? DBNull.Value;
            }

            dataTable.Rows.Add(dataRow);
        }

        ReportParameter pTotal = new ReportParameter("pTotal", fm.lblGrandTotal.Text);                            
        ReportParameter pStore = new ReportParameter("pStore", store);
        ReportParameter pAddress = new ReportParameter("pAddress", address);
        ReportParameter pPhone = new ReportParameter("pPhone", phone);               

        reportViewer1.LocalReport.SetParameters(pTotal);                            
        reportViewer1.LocalReport.SetParameters(pStore);
        reportViewer1.LocalReport.SetParameters(pAddress);
        reportViewer1.LocalReport.SetParameters(pPhone);           
        rptReportDataSource = new ReportDataSource("DataSet1", dataTable);
        reportViewer1.LocalReport.DataSources.Add(rptReportDataSource);
        reportViewer1.SetDisplayMode(Microsoft.Reporting.WinForms.DisplayMode.PrintLayout);
        reportViewer1.ZoomMode = ZoomMode.Percent;
        reportViewer1.ZoomPercent = 100;
    }
    catch (Exception ex)
    {
        MessageBox.Show(ex.Message);
    }
}

May be the another option to get order sales receipt printed is to use DVBClientBill as data source but can someone here assist me how to go about it please 

Could it be like there is an issue with               where convert(varchar(10), SDate, 102) = convert(varchar(10), getdate(), 102)

Because when I remove it, it load all the sales data as stated earlier 

Hello Hello  Samantaray,

It is the same condition please

Hi Emmanuel,

Based on which condition u want records in report viewer

Check ur right side image where the 2 records are loading. You need to check what condition that 2 records are loading. The same condition u need to put in below code in loadreport ()

da.SelectCommand = new SqlCommand("select SNum,SDate,SProductName,SPrice,SQty,SAmount, SCustomer from tblSales where "put ur condition"

Hi Samantaray, thank you for help, the receipt came but didn't show any data, 

Hi Emmanuel,

Modify the select statement using filter in ur loadreport() code as below. Here filter is based on current date like this u can filter records as per requirement. The below code as reference.

da.SelectCommand = new SqlCommand("select SNum,SDate,SProductName,SPrice,SQty,SAmount, SCustomer from tblSales where
convert(varchar(10), SDate, 102) = convert(varchar(10), getdate(), 102", con);

Hello  Samantaray,

I tried to seperate the print button from SaveBill button but it didn't work,

How do i filter current sales with the data, I will happy if you can give me example here

Ohk Samantaray  I will check and revert

Hi Emmanuel,

As I said earlier, put a filter in the below query of code

da.SelectCommand = new SqlCommand("select SNum, SDate,SProductName,SPrice,SQty,SAmount, SCustomer from tblSales", con);

Here u can filter based on date. So, it will show current sales on report viewer instead of all records.

How do I go about please 

The issue is the query(select SNum,SDate,SProductName,SPrice,SQty,SAmount,SCustomer from tblSales), which is fetching all data present in the tblSales table. You have to fetch selected data by using some condition.

public void LoadReport()
        {
            ReportDataSource rptReportDataSource;
            try
            {
                this.reportViewer1.LocalReport.ReportPath = Application.StartupPath + @"\rptReceipt.rdlc";
                this.reportViewer1.LocalReport.DataSources.Clear();
                DataSet ds = new DataSet();
                SqlDataAdapter da = new SqlDataAdapter();

                con.Open();
                da.SelectCommand = new SqlCommand("select SNum, SDate,SProductName,SPrice,SQty,SAmount, SCustomer from tblSales", con);
                da.Fill(ds.Tables["dtReceipt"]);
                con.Close();
                ReportParameter pTotal = new ReportParameter("pTotal", fm.lblGrandTotal.Text);                            
                ReportParameter pStore = new ReportParameter("pStore", store);
                ReportParameter pAddress = new ReportParameter("pAddress", address);
                ReportParameter pPhone = new ReportParameter("pPhone", phone);               

                reportViewer1.LocalReport.SetParameters(pTotal);                            
                reportViewer1.LocalReport.SetParameters(pStore);
                reportViewer1.LocalReport.SetParameters(pAddress);
                reportViewer1.LocalReport.SetParameters(pPhone);           
                rptReportDataSource = new ReportDataSource("DataSet1", ds.Tables["dtReceipt"]);
                reportViewer1.LocalReport.DataSources.Add(rptReportDataSource);
                reportViewer1.SetDisplayMode(Microsoft.Reporting.WinForms.DisplayMode.PrintLayout);
                reportViewer1.ZoomMode = ZoomMode.Percent;
                reportViewer1.ZoomPercent = 100;
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
    }
}

Please provide the code for LoadReport() method.

Check your button click event that savebill method for inserting records but as per requirement u need to generate the report only.

To print the sales order, u need to check loadreport() and showdialog() method.

Check your code in button2_Click() event. Because that performs both save records as well as print records. That's why it is printing both the current and the previous sales from database. 

You need to use one button for savebill() method and other for loadreport().

For better findings u need to use breakpoint in each methods under button2 click event. In loadreport() method u need to use filter to generate reports for current sales.

Hello Satyaprakash,

I am trying to print current sales but the sytem ended up printing both the current and the previous sales from database.

I just want to print the sales order not the one already saved in the database

The Report Viewer provides print report option in the toolbar to print a copy of the report. The page setup dialog allows you to set the paper size or other page setup properties. To see print margins, click Print Layout on the toolbar.

Refer link and modify your code as per requirement

Click here >> https://tinyurl.com/3xdm6kfx