Grand Total with Count function showing 0 in Report Footer

2 posts, 0 answers
  1. Savan
    Savan avatar
    22 posts
    Member since:
    Oct 2015

    Posted 21 Jun 2016 Link to this post


    I have added a Table in my report and data source is added to that table. I have added Row Group in the table and also added group row below the Row that shows actual data and in the new row i am displaying count of particular fields. i have added group on Company field and for every unique company i am showing Total using count function.

    Ex. i have two companies with fields as shown below:

    Company          PO       PO1       PO2

    aaa                   1                           2

                             2             3            1

    Total(count fn)  2             1            2  


    bbb                   2             1            4

                             1             7            2

    Total(count fn)  2             2            2 


    Grand Total     4              3            4

    In my case Grand total is showing 0 instead of actual count value, in fact when i click on report footer then data explorer is not showing Data source i have added.

    The reason why i have opted for Table in the report is that i want to display Report Header and Page Header both in this report and because of design of the Telerik reports Page Header always gets displayed at the top, when i look to find a way which will allow me to display Report header above Page header, i found that it is not possible but found alternative solution where i can add table and then set ColumnHeaderPrintonEveryPage property to True.



    Savan Parmar

  2. Nasko
    Nasko avatar
    1094 posts

    Posted 24 Jun 2016 Link to this post

    Hello Savan,

    Each Data Item has its own data source. The Table item and the Report are separate data items.
    The Data Explorer in the context of the Table item will display data fields from the Table.DataSource and you can work with those data fields in expressions inside the Table item.
    The Data Explorer in the context of the Report will display data fields from the Report.DataSource. If Report.DataSource is empty, there will be no data fields in the Data Explorer.
    You cannot use the Table data fields outside of the Table item. For more information, please refer to the Data Items help article.

    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Back to Top