report

test.cs

            {
                var con = new MySqlConnection(
                    "server=localhost;userid=root;password=admin;database=POS_DB;persistsecurityinfo=True;");
                var cmd = new MySqlCommand(
                "Select DISTINCT Sales.InvoiceNo, Sales.CustomerID, Sales.GrandTotal, Sales.TotalPayment, Sales.PaymentDue, Sales.InvoiceDate, ProductSold.ConfigID, ProductSold.ProductName, ProductSold.Quantity, ProductSold.Price, ProductSold.TotalAmount " +
               "From ProductSold, Sales, Branch " +
               "Where Sales.InvoiceNo='INV-559216' And branch.BranchID='1'", con);
              var sqlData = new MySqlDataAdapter { SelectCommand = cmd };
              sqlData.Fill(set, "Sales");
                sqlData.Fill(set, "ProductSold");
                sqlData.Fill(set, "Branch");

                var receipt = new SaleRecipt();
receipt.Refresh();
                receipt.SetDataSource(set);
                RptViewer.Instance.crystal.ReportSource = receipt;
                RptViewer.Instance.ShowDialog();