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.