This is a migrated thread and some comments may be shown as answers.

Rad Pivot Grid Not displaying Data

2 Answers 119 Views
PivotGrid and PivotFieldList
This is a migrated thread and some comments may be shown as answers.
Abhay
Top achievements
Rank 1
Abhay asked on 22 Sep 2017, 06:42 AM

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

 

2 Answers, 1 is accepted

Sort by
0
Abhay
Top achievements
Rank 1
answered on 22 Sep 2017, 07:57 AM
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?
0
Hristo
Telerik team
answered on 22 Sep 2017, 01:14 PM
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
Try our brand new, jQuery-free Angular 2 components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
Tags
PivotGrid and PivotFieldList
Asked by
Abhay
Top achievements
Rank 1
Answers by
Abhay
Top achievements
Rank 1
Hristo
Telerik team
Share this question
or