Comments by Pranav_ (Top 7 by date)

SELECT as2.itemname AS [ITEM NAME], SUM(as2.quantity) / 2 AS PURCHASED, SUM(AS1.quantity) / 2 AS SOLD, SUM(as2.quantity) / 2 - SUM(AS1.quantity) / 2 AS Expr3
FROM purchase AS as2 RIGHT OUTER JOIN
sale AS AS1 ON AS1.itemname = as2.itemname
GROUP BY AS1.itemname, as2.itemname

/*this is more like a jugad thing i need a proper query, if i remove the /2 it doubles the figure of real one*/

ReportParameter[] p = new ReportParameter[3];
p[0] = new ReportParameter("@fromdate", fdt.ToString(), false);
p[1] = new ReportParameter("@todate", tdt.ToString(), false);
/An error occurred during local report processing./ this.ReportViewer1.LocalReport.SetParameters(new ReportParameter[] { p[0], p[1] });
this.selectusedmodelsTableAdapter.Fill(this.inventoryDbDataSet11.selectusedmodels);
DataTable dt = new DataTable();
ReportViewer1.ProcessingMode = Microsoft.Reporting.WinForms.ProcessingMode.Local;
this.ReportViewer1.RefreshReport();
LocalReport localReport = ReportViewer1.LocalReport;
string path = Path.GetDirectoryName(Application.StartupPath);
string reportPath = Path.Combine(path, @"ServiceReport.rdlc");
string originalpath = reportPath.Replace("\\bin", "");
localReport.ReportPath = originalpath;
this.ReportViewer1.Width = 700;
this.ReportViewer1.Height = 300;
ReportDataSource rds = new ReportDataSource();
rds.Name = "Report1";
rds.Value = dt;
//localReport.DataSources.Add(rds);
ReportViewer1.RefreshReport();