Problem in counting rows

[Miriam]

Hi,

I'm trying to create a report with summary of all rows in the table like the example below.

emp_id   emp_name
1                  a
2                  b
3                  c

emp_count: 3

I tried to add TextBox for emp_count with aggregation to emp_id column but because of the textbox doesn't have DataSource, the value was 0.
When I added DataSource to the report, the emp_count's value was correct but the table's data displayed twice. I also tried to use RowCount("reportName") function
but it didn't work. 

Any suggestion?

Thanks

[Stef]

Hi Miriam,

The table item is a data item with its own data source and scope. To display the desired aggregation, you can add a total row in the Table item. Cells in the same group can be merged to create a single cell.

For more details check the Understanding table cells, rows and columns article and the local Crosstab/ProductSales demo report, installed by default under C:\Program Files (x86)\Telerik\Reporting <VERSION>\Examples\CSharp\ReportLibrary.

Regards,
Stef
Telerik