Rad Pivot Grid Not displaying Data

3 posts, 0 answers
  1. Abhay
    Abhay avatar
    2 posts
    Member since:
    Jul 2017

    Posted 22 Sep Link to this post

    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. Abhay
    Abhay avatar
    2 posts
    Member since:
    Jul 2017

    Posted 22 Sep in reply to Abhay Link to this post

    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?
  3. Hristo
    Admin
    Hristo avatar
    1019 posts

    Posted 22 Sep Link to this post

    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
    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.
Back to Top