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

 

i found the exact problem test applicatioin's target .net framwork is 4. and my original application target framwork is 3.5 when i convert my test application in to 3.5 it aslo stop displaying data. now the question is how can i run this code on 3.5 applicaiton?

Hi Abhay,

Thank you for writing.

Since your project is targeting .NET 3.5 please use the .NET 2.0 version of our assemblies. Please note that all of the Telerik assemblies need to heave the same versions. In case your problem persists, please send me a sample project reproducing the issue. In order to allow project attachments, I am converting this forum thread to a support ticket and you can find it in your Telerik account.

I hope this helps. Should you have further questions please do not hesitate to write back.

Regards,
Hristo
Progress Telerik