Click here to Skip to main content
15,314,843 members

Comments by Pranav_ (Top 7 by date)

Pranav_ 12-May-14 7:44am View
   
bro u are awesome, but I am looking for a SSIS solution in BIDS
Pranav_ 12-May-14 0:26am View
   
Maciej Los: the problem is that range is not fixed. it starts from 6th row and ends up at the row before /////(5 forward slashes).
Pranav_ 3-Dec-13 22:06pm View
   
i added it but yet not resolved
Pranav_ 3-Dec-13 21:49pm View
   
no.
Pranav_ 28-Oct-13 10:57am View
   
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*/
Pranav_ 28-Oct-13 10:51am View
   
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*/
Pranav_ 30-Aug-13 1:39am View
   
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();