private void LoadReport()
{
try
{
RptLedger.Reset();
ReportDataSource data = new ReportDataSource("Ledger", BLL.Ledger.toList.Where(x => Ledger_Filter(x)).ToList());
ReportDataSource data1 = new ReportDataSource("CompanyDetail", BLL.CompanyDetail.toList.Where(x => x.Id == BLL.UserAccount.Company.Id).ToList());
RptLedger.LocalReport.DataSources.Add(data);
RptLedger.LocalReport.DataSources.Add(data1);
RptLedger.LocalReport.ReportPath = @"rpt\master\RptLedger.rdlc";
RptLedger.RefreshReport();
}
catch (Exception ex)
{
}
}
public void LoadReport()
{
try
{
RptLedger.Reset();
ReportDataSource data = new ReportDataSource("Ledger", BLL.Ledger.toList);
ReportDataSource data1 = new ReportDataSource("CompanyDetail", BLL.CompanyDetail.toList.Where(x => x.Id == BLL.UserAccount.User.UserType.Company.Id).ToList());
RptLedger.LocalReport.DataSources.Add(data);
RptLedger.LocalReport.DataSources.Add(data1);
RptLedger.LocalReport.ReportPath = @"Transaction\rptLedgerOpening.rdlc";
RptLedger.RefreshReport();
}
catch (Exception ex)
{
}
}
private void LoadReport()
{
try
{
RptLedger.Reset();
ReportDataSource data = new ReportDataSource("Ledger", BLL.Ledger.toList.Where(x => Ledger_Filter(x)).ToList());
ReportDataSource data1 = new ReportDataSource("FundMaster", BLL.FundMaster.toList.Where(x => x.Id == BLL.UserAccount.User.UserType.Fund.Id).ToList());
RptLedger.LocalReport.DataSources.Add(data);
RptLedger.LocalReport.DataSources.Add(data1);
RptLedger.LocalReport.ReportPath = @"Transaction\rptLedgerOpening.rdlc";
RptLedger.RefreshReport();
}
catch (Exception ex)
{
}
}
private void LoadReport()
{
try
{
RptLedger.Reset();
ReportDataSource data = new ReportDataSource("Ledger", BLL.Ledger.toList.Where(x => Ledger_Filter(x)).Select(x => new { x.LedgerName, x.AddressLine1, x.AddressLine2, x.CityName, x.OPCr, x.OPDr, x.LedgerCode, PersonIncharge = x.AccountGroup.GroupName }).OrderBy(x => x.LedgerCode).ToList());
ReportDataSource data1 = new ReportDataSource("CompanyDetail", BLL.CompanyDetail.toList.Where(x => x.Id == BLL.UserAccount.User.UserType.Company.Id).ToList());
RptLedger.LocalReport.DataSources.Add(data);
RptLedger.LocalReport.DataSources.Add(data1);
RptLedger.LocalReport.ReportPath = @"Master\RptLedger.rdlc";
ReportParameter[] param = new ReportParameter[1];
param[0] = new ReportParameter("Title", "LEDGER LIST");
RptLedger.LocalReport.SetParameters(param);
RptLedger.RefreshReport();
}
catch (Exception ex)
{
}
}