Indicate to a Table the DataSource has a GROUPING SET from SQL

[NerdBrick]

Hello, 

We are binding a Table DataSource to a SQL Sproc that is taking advantage of GROUPING SETS where the last row in the result set that has the aggregation already applied to the data based on the DB design requirements. 

What is the best way to tell the Table that the data set has this special last row so we can: 

1) format the row in a special way (bold, font size, and such)
2) Set a couple cells to a special text value ("Total", "Summary") 

Do we just use Conditional Formatting rules on each cell the last row? Or is there a better way to do this?

Thank you.

[Nasko]

Hello Brick,

All of the rows coming from the data source are interpreted as detail data rows by the Table item. The item cannot and should not make a difference between the rows and whether they contain detail data, grouped data or even hierarchical data. Thus, in order to set different formatting to the last row text boxes you will need to use Conditional Formatting, as you suggested.

Regards,
Nasko
Telerik