Hello,
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.
Regards,
Savan Parmar
1 Answer, 1 is accepted
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.
Regards,
Nasko
Telerik