public static ReportDataSource ApplyParameters(this ReportDataSource source, ReportParameterInfoCollection parameters)
{
var values = (IEnumerable <object>)source.Value;
var result = values.Where(i => parameters.Comply(i));
return(new ReportDataSource(source.Name, result));
}
private void getData(string fdate, string tdate, string Commodity_Id)
{
while (this.ReportViewer1.ServerReport.IsDrillthroughReport)
{
this.ReportViewer1.PerformBack();
}
pnlreport.Visible = true;
string folder = ConfigurationManager.ConnectionStrings["rptfolder"].ProviderName;
string reportURL = "";
reportURL = ConfigurationManager.ConnectionStrings["rpturl"].ProviderName;
ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote;
ReportViewer1.ServerReport.ReportServerUrl = new Uri(reportURL);
ReportViewer1.ServerReport.ReportPath = folder + "TruckDispatch_commwise";
ReportViewer1.ServerReport.ReportServerCredentials = new ReportServerNetworkCredentials();
ReportParameterInfoCollection pInfo = default(ReportParameterInfoCollection);
System.Collections.Generic.List <ReportParameter> paramList = new System.Collections.Generic.List <ReportParameter>();
paramList.Add(new ReportParameter("Commodity_Id", Commodity_Id, false));
paramList.Add(new ReportParameter("frmdate", fdate, false));
paramList.Add(new ReportParameter("todate", tdate, false));
ReportViewer1.ServerReport.SetParameters(paramList);
pInfo = ReportViewer1.ServerReport.GetParameters();
ReportViewer1.ServerReport.Refresh();
}
private void get_Data(string frmdate, string todate)
{
while (this.ReportViewer1.ServerReport.IsDrillthroughReport)
{
this.ReportViewer1.PerformBack();
}
string folder = ConfigurationManager.ConnectionStrings["rptfolder"].ProviderName;
string reportURL = "";
reportURL = ConfigurationManager.ConnectionStrings["rpturl"].ProviderName;
ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote;
ReportViewer1.ServerReport.ReportServerUrl = new Uri(reportURL);
ReportViewer1.ServerReport.ReportPath = folder + "State_GodownWiseDeposit";
ReportViewer1.ServerReport.ReportServerCredentials = new ReportServerNetworkCredentials();
ReportParameterInfoCollection pInfo = default(ReportParameterInfoCollection);
System.Collections.Generic.List <ReportParameter> paramList = new System.Collections.Generic.List <ReportParameter>();
paramList.Add(new ReportParameter("frmdate", frmdate, false));
paramList.Add(new ReportParameter("todate", todate, false));
ReportViewer1.ServerReport.SetParameters(paramList);
pInfo = ReportViewer1.ServerReport.GetParameters();
ReportViewer1.ServerReport.Refresh();
}
private void get_billdata(string district, string billno, string monthId, string Cropyear)
{
while (this.ReportViewer1.ServerReport.IsDrillthroughReport)
{
this.ReportViewer1.PerformBack();
}
pnlreport.Visible = true;
string folder = ConfigurationManager.ConnectionStrings["rptfolder"].ProviderName;
string reportURL = "";
reportURL = ConfigurationManager.ConnectionStrings["rpturl"].ProviderName;
ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote;
ReportViewer1.ServerReport.ReportServerUrl = new Uri(reportURL);
ReportViewer1.ServerReport.ReportPath = folder + "rpt_FPSwisepayment_detail";
ReportViewer1.ServerReport.ReportServerCredentials = new ReportServerNetworkCredentials();
ReportParameterInfoCollection pInfo = default(ReportParameterInfoCollection);
System.Collections.Generic.List <ReportParameter> paramList = new System.Collections.Generic.List <ReportParameter>();
paramList.Add(new ReportParameter("district", district, false));
paramList.Add(new ReportParameter("billno", billno, false));
paramList.Add(new ReportParameter("Allotmentmonth", monthId, false));
paramList.Add(new ReportParameter("Allotmentyear", Cropyear, false));
ReportViewer1.ServerReport.SetParameters(paramList);
pInfo = ReportViewer1.ServerReport.GetParameters();
ReportViewer1.ServerReport.Refresh();
}
private void get_RackData(string districtId, string racknum)
{
while (this.ReportViewer1.ServerReport.IsDrillthroughReport)
{
this.ReportViewer1.PerformBack();
}
string folder = ConfigurationManager.ConnectionStrings["rptfolder"].ProviderName;
string reportURL = "";
reportURL = ConfigurationManager.ConnectionStrings["rpturl"].ProviderName;
ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote;
ReportViewer1.ServerReport.ReportServerUrl = new Uri(reportURL);
ReportViewer1.ServerReport.ReportPath = folder + "RackReport_frmprocurement_RacknumWise";
ReportViewer1.ServerReport.ReportServerCredentials = new ReportServerNetworkCredentials();
ReportParameterInfoCollection pInfo = default(ReportParameterInfoCollection);
System.Collections.Generic.List <ReportParameter> paramList = new System.Collections.Generic.List <ReportParameter>();
paramList.Add(new ReportParameter("DistID", districtId, false));
paramList.Add(new ReportParameter("RackNumber", racknum, false));
//district_code
ReportViewer1.ServerReport.SetParameters(paramList);
pInfo = ReportViewer1.ServerReport.GetParameters();
ReportViewer1.ServerReport.Refresh();
}
private void getDistData(string CropYear, string DistCode)
{
while (this.ReportViewer1.ServerReport.IsDrillthroughReport)
{
this.ReportViewer1.PerformBack();
}
pnlreport.Visible = true;
string folder = ConfigurationManager.ConnectionStrings["rptfolder"].ProviderName;
string reportURL = "";
reportURL = ConfigurationManager.ConnectionStrings["rpturl"].ProviderName;
ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote;
ReportViewer1.ServerReport.ReportServerUrl = new Uri(reportURL);
ReportViewer1.ServerReport.ReportPath = folder + "Date_Wise_rpt";
ReportViewer1.ServerReport.ReportServerCredentials = new ReportServerNetworkCredentials();
ReportParameterInfoCollection pInfo = default(ReportParameterInfoCollection);
System.Collections.Generic.List <ReportParameter> paramList = new System.Collections.Generic.List <ReportParameter>();
paramList.Add(new ReportParameter("CropYear", CropYear, false));
paramList.Add(new ReportParameter("District", DistCode, false));
ReportViewer1.ServerReport.SetParameters(paramList);
pInfo = ReportViewer1.ServerReport.GetParameters();
ReportViewer1.ServerReport.Refresh();
}
private void getData(string fdate, string todate, string DistrictId, string IssueId, string pcid)
{
while (this.ReportViewer1.ServerReport.IsDrillthroughReport)
{
this.ReportViewer1.PerformBack();
}
string folder = ConfigurationManager.ConnectionStrings["rptfolder"].ProviderName;
string reportURL = "";
reportURL = ConfigurationManager.ConnectionStrings["rpturl"].ProviderName;
ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote;
ReportViewer1.ServerReport.ReportServerUrl = new Uri(reportURL);
ReportViewer1.ServerReport.ReportPath = folder + "FAq_NoFaq";
ReportViewer1.ServerReport.ReportServerCredentials = new ReportServerNetworkCredentials();
ReportParameterInfoCollection pInfo = default(ReportParameterInfoCollection);
System.Collections.Generic.List <ReportParameter> paramList = new System.Collections.Generic.List <ReportParameter>();
paramList.Add(new ReportParameter("Distid", DistrictId, false));
paramList.Add(new ReportParameter("issuecenter", IssueId, false));
paramList.Add(new ReportParameter("frmdate", fdate, false));
paramList.Add(new ReportParameter("todate", todate, false));
paramList.Add(new ReportParameter("Purchase_Center", pcid, false));
ReportViewer1.ServerReport.SetParameters(paramList);
pInfo = ReportViewer1.ServerReport.GetParameters();
ReportViewer1.ServerReport.Refresh();
}
private void get_Datacust(string Transport_order, string issue_id)
{
while (this.ReportViewer1.ServerReport.IsDrillthroughReport)
{
this.ReportViewer1.PerformBack();
}
pnlreport.Visible = true;
string folder = ConfigurationManager.ConnectionStrings["rptfolder"].ProviderName;
string reportURL = "";
reportURL = ConfigurationManager.ConnectionStrings["rpturl"].ProviderName;
ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote;
ReportViewer1.ServerReport.ReportServerUrl = new Uri(reportURL);
ReportViewer1.ServerReport.ReportPath = folder + "rpt_Transport_OrderDetail";
ReportViewer1.ServerReport.ReportServerCredentials = new ReportServerNetworkCredentials();
ReportParameterInfoCollection pInfo = default(ReportParameterInfoCollection);
System.Collections.Generic.List <ReportParameter> paramList = new System.Collections.Generic.List <ReportParameter>();
paramList.Add(new ReportParameter("Transportorder", Transport_order, false));
paramList.Add(new ReportParameter("issuecenter", issue_id, false)); // Issue id
ReportViewer1.ServerReport.SetParameters(paramList);
pInfo = ReportViewer1.ServerReport.GetParameters();
ReportViewer1.ServerReport.Refresh();
}
private void getData(string Comdty, string CropYear, string Month, string ComdtyName, string MonthName)
{
while (this.ReportViewer1.ServerReport.IsDrillthroughReport)
{
this.ReportViewer1.PerformBack();
}
pnlreport.Visible = true;
string folder = ConfigurationManager.ConnectionStrings["rptfolder"].ProviderName;
string reportURL = "", Year = "";
Year = DateTime.Now.Year.ToString();
reportURL = ConfigurationManager.ConnectionStrings["rpturl"].ProviderName;
ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote;
ReportViewer1.ServerReport.ReportServerUrl = new Uri(reportURL);
ReportViewer1.ServerReport.ReportPath = folder + "PDS_TruckMovmt";
ReportViewer1.ServerReport.ReportServerCredentials = new ReportServerNetworkCredentials();
ReportParameterInfoCollection pInfo = default(ReportParameterInfoCollection);
System.Collections.Generic.List <ReportParameter> paramList = new System.Collections.Generic.List <ReportParameter>();
paramList.Add(new ReportParameter("CropYear", CropYear, false));
paramList.Add(new ReportParameter("Comdty", Comdty, false));
paramList.Add(new ReportParameter("Month", Month, false));
paramList.Add(new ReportParameter("ComdtyName", ComdtyName, false));
paramList.Add(new ReportParameter("MonthName", MonthName, false));
paramList.Add(new ReportParameter("Year", Year, false));
ReportViewer1.ServerReport.SetParameters(paramList);
pInfo = ReportViewer1.ServerReport.GetParameters();
ReportViewer1.ServerReport.Refresh();
}
private void getPaddyData(string fdate, string tdate, string DistID, string cropyear, string commodity)
{
while (this.ReportViewer1.ServerReport.IsDrillthroughReport)
{
this.ReportViewer1.PerformBack();
}
pnlreport.Visible = true;
string folder = ConfigurationManager.ConnectionStrings["rptfolder"].ProviderName;
string reportURL = "";
reportURL = ConfigurationManager.ConnectionStrings["rpturl"].ProviderName;
ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote;
ReportViewer1.ServerReport.ReportServerUrl = new Uri(reportURL);
ReportViewer1.ServerReport.ReportPath = folder + "AcptNoteKharif2016_District";
ReportViewer1.ServerReport.ReportServerCredentials = new ReportServerNetworkCredentials();
ReportParameterInfoCollection pInfo = default(ReportParameterInfoCollection);
System.Collections.Generic.List <ReportParameter> paramList = new System.Collections.Generic.List <ReportParameter>();
paramList.Add(new ReportParameter("Distt_ID", DistID, false));
paramList.Add(new ReportParameter("FromDate", fdate, false));
paramList.Add(new ReportParameter("toDate", tdate, false));
paramList.Add(new ReportParameter("Crop_Year", cropyear, false));
paramList.Add(new ReportParameter("Commodity_Id", commodity, false));
ReportViewer1.ServerReport.SetParameters(paramList);
pInfo = ReportViewer1.ServerReport.GetParameters();
ReportViewer1.ServerReport.Refresh();
}
//Process subreport(s) which you include in main report (from ToolBox)
public void SubreportProcessingEventHandler(object sender, SubreportProcessingEventArgs e)
{
ReportParameterInfoCollection infoParam = e.Parameters;
string strCaseId = infoParam[0].Values[0].ToString();
switch (e.ReportPath)
{
case "subreport1":
;
break;
case "ReportCustomersAddress":
cmd.CommandText = strCustomerAddress + @" where ""CustomerID"" = '" + strCaseId + "'";
var dtCustomersAddress = dc.GetDataSet(cmd, CommandType.Text, null).Tables[0];
e.DataSources.Add(new ReportDataSource("dtCustomersAddress", dtCustomersAddress));
break;
case "subreport3":
;
break;
default:
break;
}
}
private void get_Datacust(string division, string fdate)
{
while (this.ReportViewer1.ServerReport.IsDrillthroughReport)
{
this.ReportViewer1.PerformBack();
}
pnlreport.Visible = true;
string folder = ConfigurationManager.ConnectionStrings["rptfolder"].ProviderName;
string reportURL = "";
reportURL = ConfigurationManager.ConnectionStrings["rpturl"].ProviderName;
ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote;
ReportViewer1.ServerReport.ReportServerUrl = new Uri(reportURL);
ReportViewer1.ServerReport.ReportPath = folder + "rpt_Opening_balance_Region";
ReportViewer1.ServerReport.ReportServerCredentials = new ReportServerNetworkCredentials();
ReportParameterInfoCollection pInfo = default(ReportParameterInfoCollection);
System.Collections.Generic.List <ReportParameter> paramList = new System.Collections.Generic.List <ReportParameter>();
paramList.Add(new ReportParameter("division_id", division, false));
paramList.Add(new ReportParameter("Stock_Date", fdate, false));
ReportViewer1.ServerReport.SetParameters(paramList);
pInfo = ReportViewer1.ServerReport.GetParameters();
ReportViewer1.ServerReport.Refresh();
}
private void frmReportViewer_Load(object sender, EventArgs e)
{
if (_Report == null)
{
this.reportViewer1.LocalReport.ReportPath = sReportPath; //sReportPath;
this.reportViewer1.LocalReport.SetParameters(new ReportParameter("Encabezado1", Parametros.ParametrosSucursal.EncabezadoFactura1));
this.reportViewer1.LocalReport.SetParameters(new ReportParameter("Encabezado2", Parametros.ParametrosSucursal.EncabezadoFactura2));
this.reportViewer1.LocalReport.SetParameters(new ReportParameter("Encabezado3", Parametros.ParametrosSucursal.EncabezadoFactura3));
if (sTitulo != "")
{
this.reportViewer1.LocalReport.SetParameters(new ReportParameter("Titulo", sTitulo));
}
this.reportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSet1", dt));
this.reportViewer1.LocalReport.Refresh();
this.reportViewer1.RefreshReport();
this.reportViewer1.RefreshReport();
}
else
{
//****************************
//assign report Path
reportViewer1.LocalReport.ReportPath = _Report.ReportPath;
//****************************
//****************************
//assign data-sources
foreach (ReportDataSource MyDS in _Report.DataSources)
{
reportViewer1.LocalReport.DataSources.Add(MyDS);
}
//****************************
//****************************
//Assign parameters
//get a list of actual parameters in the report, with the actual assigned value
ReportParameterInfoCollection MyOrigParams = _Report.GetParameters(); //I didn't find simpler way to fetch params...
//create a List of parameter [to feed the reportViewer]
List <ReportParameter> MyListOfPArams = new List <ReportParameter>();
//for each params found through GetParameters(), add it to the List<> of params
for (int i = 0; i < MyOrigParams.Count; i++)
{
MyListOfPArams.Add(new ReportParameter(MyOrigParams[i].Name, MyOrigParams[i].Values[0]));
}
//final assignation of the parameters
reportViewer1.LocalReport.SetParameters(MyListOfPArams);
//****************************
//show the report
reportViewer1.RefreshReport();
}
}
private void RenderAllLocalReportPages(LocalReport localReport)
{
string deviceInfo = CreateEMFDeviceInfo();
ReportParameterInfoCollection rpc = (ReportParameterInfoCollection)localReport.GetParameters();
localReport.Render("IMAGE", deviceInfo, LocalReportCreateStreamCallback, out Warning[] warnings);
}
private void getData(string DistId, string Depot_ID, string fdate, string tdate, string OrderNo)
{
while (this.ReportViewer1.ServerReport.IsDrillthroughReport)
{
this.ReportViewer1.PerformBack();
}
pnlreport.Visible = true;
string folder = ConfigurationManager.ConnectionStrings["rptfolder"].ProviderName;
string reportURL = "";
reportURL = ConfigurationManager.ConnectionStrings["rpturl"].ProviderName;
ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote;
ReportViewer1.ServerReport.ReportServerUrl = new Uri(reportURL);
ReportViewer1.ServerReport.ReportPath = folder + "Rpt_IC_SugarSupplyOrder";
ReportViewer1.ServerReport.ReportServerCredentials = new ReportServerNetworkCredentials();
ReportParameterInfoCollection pInfo = default(ReportParameterInfoCollection);
System.Collections.Generic.List <ReportParameter> paramList = new System.Collections.Generic.List <ReportParameter>();
paramList.Add(new ReportParameter("DistID", DistId, false));
paramList.Add(new ReportParameter("Depot_ID", Depot_ID, false));
paramList.Add(new ReportParameter("Orderno", OrderNo, false));
paramList.Add(new ReportParameter("fromDate", fdate, false));
paramList.Add(new ReportParameter("toDate", tdate, false));
ReportViewer1.ServerReport.SetParameters(paramList);
pInfo = ReportViewer1.ServerReport.GetParameters();
ReportViewer1.ServerReport.Refresh();
}
private void get_Data(string fdate, string tdate)
{
while (this.ReportViewer1.ServerReport.IsDrillthroughReport)
{
this.ReportViewer1.PerformBack();
}
//
//[Dist_ID]
//
//
pnlreport.Visible = true;
string folder = ConfigurationManager.ConnectionStrings["rptfolder"].ProviderName;
string reportURL = "";
reportURL = ConfigurationManager.ConnectionStrings["rpturl"].ProviderName;
ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote;
ReportViewer1.ServerReport.ReportServerUrl = new Uri(reportURL);
ReportViewer1.ServerReport.ReportPath = folder + "PendingAcceptanceNoteDetail";
ReportViewer1.ServerReport.ReportServerCredentials = new ReportServerNetworkCredentials();
ReportParameterInfoCollection pInfo = default(ReportParameterInfoCollection);
System.Collections.Generic.List <ReportParameter> paramList = new System.Collections.Generic.List <ReportParameter>();
paramList.Add(new ReportParameter("FromDate", fdate, false));
paramList.Add(new ReportParameter("ToDate", tdate, false));
ReportViewer1.ServerReport.SetParameters(paramList);
pInfo = ReportViewer1.ServerReport.GetParameters();
ReportViewer1.ServerReport.Refresh();
}
private List <ReportParameter> SetReportParameters(ReportParameterInfoCollection reportParameters)
{
var parameters = new List <ReportParameter>();
var additional = StringHelpers.ToDictionary(ReportExtra.AdditionalParameters, ',');
// report parameters
foreach (var parameterInfo in reportParameters)
{
var p = new ReportParameter(parameterInfo.Name);
foreach (ParameterInfo parameter in State.Parameters)
{
if (parameter.ParameterName == p.Name)
{
if (parameter.Values != null)
{
foreach (var val in parameter.Values)
{
p.Values.Add(val);
}
}
break;
}
}
if (additional.ContainsKey(p.Name))
{
p.Values.Add(ReplaceReportTokens(additional[p.Name], null));
}
parameters.Add(p);
}
return(parameters);
}
private void get_Data(string monthId, string Cropyear, string Commodity_Id)
{
while (this.ReportViewer1.ServerReport.IsDrillthroughReport)
{
this.ReportViewer1.PerformBack();
}
pnlreport.Visible = true;
string folder = ConfigurationManager.ConnectionStrings["rptfolder"].ProviderName;
string reportURL = "";
reportURL = ConfigurationManager.ConnectionStrings["rpturl"].ProviderName;
ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote;
ReportViewer1.ServerReport.ReportServerUrl = new Uri(reportURL);
ReportViewer1.ServerReport.ReportPath = folder + "rpt_Regionwise_allotment_lifting_DistributionStatus";
ReportViewer1.ServerReport.ReportServerCredentials = new ReportServerNetworkCredentials();
ReportParameterInfoCollection pInfo = default(ReportParameterInfoCollection);
System.Collections.Generic.List <ReportParameter> paramList = new System.Collections.Generic.List <ReportParameter>();
paramList.Add(new ReportParameter("Allotmentmonth", monthId, false));
paramList.Add(new ReportParameter("Allotmentyear", Cropyear, false));
paramList.Add(new ReportParameter("commodity", Commodity_Id, false));
paramList.Add(new ReportParameter("division", Session["Region_id"].ToString(), false));
ReportViewer1.ServerReport.SetParameters(paramList);
pInfo = ReportViewer1.ServerReport.GetParameters();
ReportViewer1.ServerReport.Refresh();
}
private void getData(string Comdty, string FrmDate, string ToDate)
{
while (this.ReportViewer1.ServerReport.IsDrillthroughReport)
{
this.ReportViewer1.PerformBack();
}
pnlreport.Visible = true;
string folder = ConfigurationManager.ConnectionStrings["rptfolder"].ProviderName;
string reportURL = "";
reportURL = ConfigurationManager.ConnectionStrings["rpturl"].ProviderName;
ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote;
ReportViewer1.ServerReport.ReportServerUrl = new Uri(reportURL);
ReportViewer1.ServerReport.ReportPath = folder + "Cancel_PDSMO_ByRack";
ReportViewer1.ServerReport.ReportServerCredentials = new ReportServerNetworkCredentials();
ReportParameterInfoCollection pInfo = default(ReportParameterInfoCollection);
System.Collections.Generic.List <ReportParameter> paramList = new System.Collections.Generic.List <ReportParameter>();
paramList.Add(new ReportParameter("comdty", Comdty, false));
paramList.Add(new ReportParameter("FrmDate", FrmDate, false));
paramList.Add(new ReportParameter("ToDate", ToDate, false));
ReportViewer1.ServerReport.SetParameters(paramList);
pInfo = ReportViewer1.ServerReport.GetParameters();
ReportViewer1.ServerReport.Refresh();
}
private void get_Data_CG()
{
string district = "23" + dist_code;
while (this.ReportViewer1.ServerReport.IsDrillthroughReport)
{
this.ReportViewer1.PerformBack();
}
string folder = ConfigurationManager.ConnectionStrings["rptfolder_MPMS2013"].ProviderName;
string reportURL = "";
reportURL = ConfigurationManager.ConnectionStrings["rpturl_MPMS2013"].ProviderName;
ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote;
ReportViewer1.ServerReport.ReportServerUrl = new Uri(reportURL);
ReportViewer1.ServerReport.ReportPath = folder + "rpt_CenterWiseProcTrans_CSMS_Dist";
ReportViewer1.ServerReport.ReportServerCredentials = new ReportServerNetworkCredentials();
ReportParameterInfoCollection pInfo = default(ReportParameterInfoCollection);
System.Collections.Generic.List <ReportParameter> paramList = new System.Collections.Generic.List <ReportParameter>();
paramList.Add(new ReportParameter("district", district, false));
ReportViewer1.ServerReport.SetParameters(paramList);
pInfo = ReportViewer1.ServerReport.GetParameters();
ReportViewer1.ServerReport.Refresh();
}
private void get_Data(string Crop_Year, string commodity)
{
while (this.ReportViewer1.ServerReport.IsDrillthroughReport)
{
this.ReportViewer1.PerformBack();
}
string folder = ConfigurationManager.ConnectionStrings["rptfolder"].ProviderName;
string reportURL = "";
reportURL = ConfigurationManager.ConnectionStrings["rpturl"].ProviderName;
ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote;
ReportViewer1.ServerReport.ReportServerUrl = new Uri(reportURL);
ReportViewer1.ServerReport.ReportPath = folder + "state_detilsprocurement";
ReportViewer1.ServerReport.ReportServerCredentials = new ReportServerNetworkCredentials();
ReportParameterInfoCollection pInfo = default(ReportParameterInfoCollection);
System.Collections.Generic.List <ReportParameter> paramList = new System.Collections.Generic.List <ReportParameter>();
paramList.Add(new ReportParameter("Crop_Year", Crop_Year, false));
paramList.Add(new ReportParameter("Commodity_Id", commodity, false));
ReportViewer1.ServerReport.SetParameters(paramList);
pInfo = ReportViewer1.ServerReport.GetParameters();
ReportViewer1.ServerReport.Refresh();
}
private void TestParameters(object expected, ReportParameterInfoCollection actual)
{
int count = 0;
foreach (ReportParameterInfo actualReportParameterInfo in actual)
{
PropertyInfo expectedPropertyInfo = expected.GetType().GetProperty(actualReportParameterInfo.Name);
if (expectedPropertyInfo != null)
{
count++;
Assert.AreEqual(expectedPropertyInfo.Name, actualReportParameterInfo.Name);
string expectedValue = expectedPropertyInfo.GetValue(expected).ToString();
if (String.IsNullOrEmpty(expectedValue))
{
Assert.IsTrue(actualReportParameterInfo.Values.Count == 0);
}
else
{
Assert.AreEqual(expectedValue, actualReportParameterInfo.Values[0]);
}
}
}
Assert.IsTrue(expected.GetType().GetProperties().LongLength == count);
}
private void get_Data()
{
while (this.ReportViewer1.ServerReport.IsDrillthroughReport)
{
this.ReportViewer1.PerformBack();
}
string folder = ConfigurationManager.ConnectionStrings["rptfolder"].ProviderName;
string reportURL = "";
reportURL = ConfigurationManager.ConnectionStrings["rpturl"].ProviderName;
ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote;
ReportViewer1.ServerReport.ReportServerUrl = new Uri(reportURL);
ReportViewer1.ServerReport.ReportPath = folder + "Rpt_CSMS_DefaulterOperator_list";
ReportViewer1.ServerReport.ReportServerCredentials = new ReportServerNetworkCredentials();
ReportParameterInfoCollection pInfo = default(ReportParameterInfoCollection);
System.Collections.Generic.List <ReportParameter> paramList = new System.Collections.Generic.List <ReportParameter>();
ReportViewer1.ServerReport.SetParameters(paramList);
pInfo = ReportViewer1.ServerReport.GetParameters();
ReportViewer1.ServerReport.Refresh();
}
private void get_Data(string distId, string month, string year)
{
while (this.ReportViewer1.ServerReport.IsDrillthroughReport)
{
this.ReportViewer1.PerformBack();
}
string folder = ConfigurationManager.ConnectionStrings["rptfolder"].ProviderName;
string reportURL = "";
reportURL = ConfigurationManager.ConnectionStrings["rpturl"].ProviderName;
ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote;
ReportViewer1.ServerReport.ReportServerUrl = new Uri(reportURL);
ReportViewer1.ServerReport.ReportPath = folder + "FIN_DistrictReport_WheatDCP";
ReportViewer1.ServerReport.ReportServerCredentials = new ReportServerNetworkCredentials();
ReportParameterInfoCollection pInfo = default(ReportParameterInfoCollection);
System.Collections.Generic.List <ReportParameter> paramList = new System.Collections.Generic.List <ReportParameter>();
paramList.Add(new ReportParameter("Year", year, false));
paramList.Add(new ReportParameter("District_id", distId, false));
paramList.Add(new ReportParameter("Month", month, false));
ReportViewer1.ServerReport.SetParameters(paramList);
pInfo = ReportViewer1.ServerReport.GetParameters();
ReportViewer1.ServerReport.Refresh();
}
private void get_Data(string IssueID, string DistrictId, string DoNum)
{
while (this.ReportViewer1.ServerReport.IsDrillthroughReport)
{
this.ReportViewer1.PerformBack();
}
string folder = ConfigurationManager.ConnectionStrings["rptfolder"].ProviderName;
string reportURL = "";
reportURL = ConfigurationManager.ConnectionStrings["rpturl"].ProviderName;
ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote;
ReportViewer1.ServerReport.ReportServerUrl = new Uri(reportURL);
ReportViewer1.ServerReport.ReportPath = folder + "DPY_Issue_DOWise";
ReportViewer1.ServerReport.ReportServerCredentials = new ReportServerNetworkCredentials();
ReportParameterInfoCollection pInfo = default(ReportParameterInfoCollection);
System.Collections.Generic.List <ReportParameter> paramList = new System.Collections.Generic.List <ReportParameter>();
paramList.Add(new ReportParameter("issueCentre_code", IssueID, false));
paramList.Add(new ReportParameter("district_code", DistrictId, false));
paramList.Add(new ReportParameter("delivery_order_no", DoNum, false));
ReportViewer1.ServerReport.SetParameters(paramList);
pInfo = ReportViewer1.ServerReport.GetParameters();
ReportViewer1.ServerReport.Refresh();
}
public static bool Comply(this ReportParameterInfoCollection source, object obj)
{
var temp1 = source.Any(p => p.Comply(obj));
var temp2 = source.All(p => p.Comply(obj));
return(temp1 && temp2);
}
private void get_Data(string From_Date, string to_Date, string Dist_ID, string Depot_ID)
{
Label1.Visible = false;
ReportViewer1.Visible = true;
string folder = ConfigurationManager.ConnectionStrings["rptfolder"].ProviderName;
// For Report
string reportURL = "";
reportURL = ConfigurationManager.ConnectionStrings["rpturl"].ProviderName;
ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote;
ReportViewer1.ServerReport.ReportServerUrl = new Uri(reportURL);
ReportViewer1.ServerReport.ReportPath = folder + "DailyReceiptRegistor2016";
ReportViewer1.ServerReport.ReportServerCredentials = new ReportServerNetworkCredentials();
ReportParameterInfoCollection pInfo = default(ReportParameterInfoCollection);
System.Collections.Generic.List <ReportParameter> paramList = new System.Collections.Generic.List <ReportParameter>();
paramList.Add(new ReportParameter("fromDate", From_Date, false));
paramList.Add(new ReportParameter("toDate", to_Date, false));
paramList.Add(new ReportParameter("DistID", Dist_ID, false));
paramList.Add(new ReportParameter("Depot_ID", Depot_ID, false));
ReportViewer1.ServerReport.SetParameters(paramList);
pInfo = ReportViewer1.ServerReport.GetParameters();
ReportViewer1.ServerReport.Refresh();
}
private void get_DataKharif2016(string dist)
{
while (this.ReportViewer1.ServerReport.IsDrillthroughReport)
{
this.ReportViewer1.PerformBack();
}
string folder = ConfigurationManager.ConnectionStrings["rptfolder"].ProviderName;
string reportURL = "";
reportURL = ConfigurationManager.ConnectionStrings["rpturl"].ProviderName;
ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote;
ReportViewer1.ServerReport.ReportServerUrl = new Uri(reportURL);
ReportViewer1.ServerReport.ReportPath = folder + "TruckReceived_DistKharif2016";
ReportViewer1.ServerReport.ReportServerCredentials = new ReportServerNetworkCredentials();
ReportParameterInfoCollection pInfo = default(ReportParameterInfoCollection);
System.Collections.Generic.List<ReportParameter> paramList = new System.Collections.Generic.List<ReportParameter>();
paramList.Add(new ReportParameter("district_code", dist, false));
ReportViewer1.ServerReport.SetParameters(paramList);
pInfo = ReportViewer1.ServerReport.GetParameters();
ReportViewer1.ServerReport.Refresh();
}
private void getData(string Comdty, string fdate, string DistrictId, string IssueId, string DistName, string ICName, string CmodtyName, string ToDate)
{
while (this.ReportViewer1.ServerReport.IsDrillthroughReport)
{
this.ReportViewer1.PerformBack();
}
pnlreport.Visible = true;
string folder = ConfigurationManager.ConnectionStrings["rptfolder"].ProviderName;
string reportURL = "";
reportURL = ConfigurationManager.ConnectionStrings["rpturl"].ProviderName;
ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote;
ReportViewer1.ServerReport.ReportServerUrl = new Uri(reportURL);
ReportViewer1.ServerReport.ReportPath = folder + "Rcpt_PaddyProc2016";
ReportViewer1.ServerReport.ReportServerCredentials = new ReportServerNetworkCredentials();
ReportParameterInfoCollection pInfo = default(ReportParameterInfoCollection);
System.Collections.Generic.List <ReportParameter> paramList = new System.Collections.Generic.List <ReportParameter>();
paramList.Add(new ReportParameter("comdty", Comdty, false));
paramList.Add(new ReportParameter("Distt_ID", DistrictId, false));
paramList.Add(new ReportParameter("IssueCenter_ID", IssueId, false));
paramList.Add(new ReportParameter("fdate", fdate, false));
paramList.Add(new ReportParameter("DistName", DistName, false));
paramList.Add(new ReportParameter("ICName", ICName, false));
paramList.Add(new ReportParameter("CmodtyName", CmodtyName, false));
paramList.Add(new ReportParameter("ToDate", ToDate, false));
ReportViewer1.ServerReport.SetParameters(paramList);
pInfo = ReportViewer1.ServerReport.GetParameters();
ReportViewer1.ServerReport.Refresh();
}
private void get_Data(string IssueID, string deltype)
{
while (this.ReportViewer1.ServerReport.IsDrillthroughReport)
{
this.ReportViewer1.PerformBack();
}
string folder = ConfigurationManager.ConnectionStrings["rptfolder"].ProviderName;
string reportURL = "";
reportURL = ConfigurationManager.ConnectionStrings["rpturl"].ProviderName;
ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote;
ReportViewer1.ServerReport.ReportServerUrl = new Uri(reportURL);
ReportViewer1.ServerReport.ReportPath = folder + "DeleteRecord_IsCenter";
ReportViewer1.ServerReport.ReportServerCredentials = new ReportServerNetworkCredentials();
ReportParameterInfoCollection pInfo = default(ReportParameterInfoCollection);
System.Collections.Generic.List <ReportParameter> paramList = new System.Collections.Generic.List <ReportParameter>();
paramList.Add(new ReportParameter("IssueCenter_ID", IssueID, false));
paramList.Add(new ReportParameter("Status", deltype, false));
//district_code
ReportViewer1.ServerReport.SetParameters(paramList);
pInfo = ReportViewer1.ServerReport.GetParameters();
ReportViewer1.ServerReport.Refresh();
}
public void LoadSubReportSourceDataSet(ReportParameterInfoCollection reportParameters)
{
int i = 0;
DataSet dsTemp = new DataSet();
IDbDataParameter[] sqlParam;
Boolean needToLoad = false;
foreach (RDLTable rtTable in dsreport.Tables)
{
sqlParam = new IDbDataParameter[rtTable.Parameters.Count];
i = 0;
foreach (RDLParameter param in rtTable.Parameters)
{
sqlParam[i] = new SqlParameter();
sqlParam[i].ParameterName = param.Name;
sqlParam[i].DbType = param.DbType;
foreach (ReportParameterInfo paramInfo in reportParameters)
{
if (paramInfo.Name == param.Prompt)
{
sqlParam[i].Value = paramInfo.Values[0];
if (param.Value.NotEquals(paramInfo.Values[0]))
needToLoad = true;
param.Value = paramInfo.Values[0];
break;
}
}
i++;
}
//
if (needToLoad)
{
LoadReportSourceDataSet(ref dsTemp, rtTable.CommandType, rtTable.CommandText, sqlParam);
dsTemp.Tables[0].TableName = rtTable.TableName;
if (dsSource.Tables.Contains(rtTable.TableName))
dsSource.Tables.Remove(rtTable.TableName);
dsSource.Tables.Add(dsTemp.Tables[rtTable.TableName].Copy());
}
}
}
/// <summary>
/// Invokes and executes a call to the Kirkwood database via Xapi to obtain report data.
/// </summary>
/// <param name="reportKey"></param>
/// <param name="currentParams"></param>
/// <returns></returns>
private string GetReportData(string reportKey, ReportParameterInfoCollection currentParams)
{
string returnValue = string.Empty;
List<string> reportQueryParams;
reportQueryParams = _reportInfo.ReportQueryParameterNames;
reportQueryParams.Add("UTCOffset");
reportQueryParams.Add("LocaleCode");
Dictionary<string, string> parms = new Dictionary<string, string>();
for (int i = 0; i < reportQueryParams.Count; i++)
{
parms[reportQueryParams[i].ToString()] = currentParams[reportQueryParams[i].ToString()].Values[0].ToString();
}
AsyncAction a = new WlbReportAction(Pool.Connection,
Helpers.GetMaster(Pool.Connection),
reportKey,
_reportInfo.ReportName,
false,
parms);
new ActionProgressDialog(a, ProgressBarStyle.Marquee).ShowDialog();
if (a.Succeeded)
{
returnValue = a.Result;
}
else
{
_bDisplayedError = true;
}
return returnValue;
}
//private static List<string> GetList(string listname)
//{
// List<string> lst = (List<string>)BrokerConnection.InstanceOf().Request(listname, null);
// return lst;
//}
//private void cmdAdd_Click(object sender, EventArgs e)
//{
// AddSelectedReport();
//}
//private void AddSelectedReport()
//{
// selectedReports.Add(selectedReports.Count, this.treeAvailableReports.SelectedNode.Text.Trim());
// selectedArgs.Add(selectedArgs.Count, new DataGridViewRow[0]);
// RefreshLists();
//}
//private void cmdRemove_Click(object sender, EventArgs e)
//{
// selectedReports.Remove(lstSelectedReports.SelectedIndex);
// selectedArgs.Remove(lstSelectedReports.SelectedIndex);
// RefreshLists();
//}
//private void RefreshLists()
//{
// lstSelectedReports.Items.Clear();
// foreach (string s in selectedReports.Values)
// lstSelectedReports.Items.Add(s);
//}
//private void lstAvailableReports_DoubleClick(object sender, EventArgs e)
//{
// AddSelectedReport();
//}
//private void lstSelectedReports_SelectedValueChanged(object sender, EventArgs e)
//{
// if (selectedArgs[lstSelectedReports.SelectedIndex].Length == 0)
// selectedArgs[lstSelectedReports.SelectedIndex] = GetReport();
// else
// {
// try
// {
// dgvParameters.Rows.Clear();
// foreach (DataGridViewRow dr in selectedArgs[lstSelectedReports.SelectedIndex])
// {
// Object customCell = null;
// DataGridViewRow drc = (DataGridViewRow)dr.Clone();
// drc.Cells[0].Value = dr.Cells[0].Value;
// switch (dr.Cells[1].GetType().Name)
// {
// case "DataGridViewTextBoxCell":
// DataGridViewTextBoxCell newTextCell = new DataGridViewTextBoxCell();
// newTextCell.Value = dr.Cells[1].Value;
// customCell = newTextCell;
// break;
// case "DataGridViewComboBoxCell":
// DataGridViewComboBoxCell newCbCell = new DataGridViewComboBoxCell();
// newCbCell.Value = dr.Cells[1].Value;
// customCell = newCbCell;
// break;
// case "CalendarCell":
// CalendarCell newCalCell = new CalendarCell();
// newCalCell.Value = dr.Cells[1].Value;
// customCell = newCalCell;
// break;
// }
// drc.Cells[1] = (DataGridViewCell)customCell;
// dgvParameters.Rows.Add(drc);
// }
// }
// catch (Exception ex)
// {
// Console.Write(ex);
// }
// }
// UpdateDates();
// UpdateCommandLine();
//}
private DataGridViewRow[] DisplayReportArgs(ReportParameterInfoCollection rpic)
{
int i = 0;
dgvParameters.Rows.Clear();
foreach (ReportParameterInfo rp in rpic)
{
try
{
Object customCell = null;
if (rp.ValidValues != null)
{
DataGridViewComboBoxCell cbCell = new DataGridViewComboBoxCell();
int ii = 0;
string[] vals = new string[rp.ValidValues.Count];
foreach (object o in rp.ValidValues)
vals[ii++] = ((Microsoft.Reporting.WinForms.ValidValue)o).Value;
cbCell.Items.AddRange(vals);
customCell = cbCell;
}
else if (rp.DataType.Equals(ParameterDataType.DateTime))
{
CalendarCell calCell = new CalendarCell();
customCell = calCell;
}
else
{
DataGridViewTextBoxCell dgt = new DataGridViewTextBoxCell();
customCell = dgt;
}
dgvParameters.Rows.Add();
DataGridViewTextBoxCell dgtLabel = new DataGridViewTextBoxCell();
dgtLabel.Value = rp.Name;
dgvParameters[0, i] = dgtLabel;
dgvParameters[1, i] = (DataGridViewCell)customCell;
i++;
}
catch (Exception ex)
{
Console.Write(ex);
}
}
DataGridViewRow[] arr = new DataGridViewRow[dgvParameters.Rows.Count];
dgvParameters.Rows.CopyTo(arr, 0);
return arr;
}
private void GetReportArgs(ReportParameterInfoCollection rpic)
{
int i = 0;
dgvParameters.Rows.Clear();
foreach (ReportParameterInfo rp in rpic)
{
try
{
Object customCell = null;
if (rp.ValidValues != null)
{
DataGridViewComboBoxCell cbCell = new DataGridViewComboBoxCell();
int ii = 0;
string[] vals = new string[rp.ValidValues.Count];
foreach (object o in rp.ValidValues)
vals[ii++] = ((Microsoft.Reporting.WinForms.ValidValue)o).Value;
cbCell.Items.AddRange(vals);
customCell = cbCell;
}
else if (rp.DataType.Equals(ParameterDataType.DateTime))
{
CalendarCell calCell = new CalendarCell();
customCell = calCell;
}
else
{
DataGridViewTextBoxCell dgt = new DataGridViewTextBoxCell();
customCell = dgt;
}
if ( !rp.Name.Equals("Portfolio") &&
!rp.Name.Equals("Consolidate") &&
!rp.Name.Equals("AccountingFilters"))
continue;
dgvParameters.Rows.Add();
DataGridViewTextBoxCell dgtLabel = new DataGridViewTextBoxCell();
dgtLabel.Value = rp.Name;
dgvParameters[0, i] = dgtLabel;
((DataGridViewCell)customCell).Value = argLookup[rp.Name];
dgvParameters[1, i] = (DataGridViewCell)customCell;
i++;
}
catch (Exception ex)
{
Console.Write(ex);
}
}
}
