Hello,
i am trying to display Total tax month wise in my project.
SalesDataClassDataContext dc = new SalesDataClassDataContext();
var lstdata = (from im in dc.InvoiceMasters
join it in dc.InvoiceTransactions on im.Id equals it.InvoiceMasterId
join c in dc.CustomerMasters on im.CustomerMasterId equals c.Id
join cm in dc.CompanyMasters on im.CompanyMasterId equals cm.Id
join s in dc.StateMasters on cm.State equals s.Id
where (it.CGST != 0 || it.IGST != 0) && (it.TaxableRate != null)
select new { it.CGST, CGSTAmt = it.CGSTV, im.Date, it.SGST, SGSTAmt = it.SGSTV, it.IGST, IGSTAmt = it.IGSTV }).ToList();
this.radPivotGrid1.RowGroupDescriptions.Add(new DateTimeGroupDescription() { PropertyName = "Date", Step = DateTimeStep.Month, GroupComparer = new GroupNameComparer() });
this.radPivotGrid1.ColumnGroupDescriptions.Add(new PropertyGroupDescription() { PropertyName = "CGST", GroupComparer = new GrandTotalComparer() });
this.radPivotGrid1.ColumnGroupDescriptions.Add(new PropertyGroupDescription() { PropertyName = "SGST", GroupComparer = new GrandTotalComparer() });
this.radPivotGrid1.ColumnGroupDescriptions.Add(new PropertyGroupDescription() { PropertyName = "IGST", GroupComparer = new GrandTotalComparer() });
this.radPivotGrid1.AggregateDescriptions.Add(new PropertyAggregateDescription() { PropertyName = "CGSTAmt", AggregateFunction = AggregateFunctions.Sum });
this.radPivotGrid1.AggregateDescriptions.Add(new PropertyAggregateDescription() { PropertyName = "SGSTAmt", AggregateFunction = AggregateFunctions.Sum });
this.radPivotGrid1.AggregateDescriptions.Add(new PropertyAggregateDescription() { PropertyName = "IGSTAmt", AggregateFunction = AggregateFunctions.Sum });
this.radPivotGrid1.DataSource = lstdata;
Note: this same code when i am using in my test appliation its run good and showing data accuratly but when i put same code in my original application it does'nt show data. please help for the same