Display Row Count on Dashboards / Grids

Feature Requests and Suggestions
1

Would love something like this. Simple row counts just like Excel does it.

2

You can do this by adding a calculated field with ROW_NUMBER()

It’s a Window Function so you will need to at least use an ORDER like: ROW_NUMBER() OVER (ORDER BY SysRowID)

3

If the grid control has a numeric datatype field displayed, you can display a count of rows by right clicking on the grid and selecting “Show Summaries”, then select “Count” to display a count of rows.
image
image

4

But that number is then locked to that row.

If you sort by a different field, that number follows its row.

5

Gotcha, I read it as a BAQ question. Wouldn’t it just be an Infragistics setting then?

6

You can also add a Column to your dataset that is hard coded, to some “x” then group by that Column it will give you a count

7

Use this code in initialiseCode

YourDataGrid.DisplayLayout.Override.RowSelectorNumberStyle = RowSelectorNumberStyle.RowIndex;

It will show the row numbers in first column of the grid.

Pierre

1 Like