Table formatting

[Taras]

A couple of questions regarding tables..

I know how to get a total for a column, but the row shows the cell grids for all columns in that "total" row. Table total row.jpg

Is there a way to suppress that and show text that says Total similar to something like in Preferred table total.jpg  It doesn't have to appear immediately below the row.

I also have a need to sometimes charge a sales tax so need something that looks like in Alternate table total.jpg.  This would be determined by a field that is in an "Invoice Header" data source.

I don't know how to reference the =Sum(Fields.ShiftTotal) from the table, outside the table

If the total row is a couple of separate boxes, I can then put the tax into a hidden box and display when required.

 

I guess an alternative would be to have the total in the Invoice Header data source rather than calculated from the Invoice Detail data source

[Dimitar]

Hello Taras,

Thank you for the attached screenshots and the additional information!

If I understand correctly, you would like to remove the borders from the total row of the table, is that correct?

You may do so from the Style.BorderStyle property of the table cells on that row or from the controls in the report designer toolbar, for example:

You can apply new border settings to the whole row by selecting it through the table control, or to the table cells on that row one by one.

Regarding the case with the alternate total, the data of the table cannot be accessed outside the table item, only by its child items. In the "alternate" image, I see that the second total is below the first total so you may add another row to the end of the table. You can also hide its borders to achieve the "alternate" look.

If you do not wish to always display the "alternate total" row at the end, you may hide the row dynamically depending on the value of the "Invoice Header" field by using a Binding on the Visible property of the row or Conditional Formatting.

I hope that the provided information and suggestions will help. If you need further assistance, please send me sample data that I can use locally to prepare a sample report where the requirements are implemented.

Regards,
Dimitar
Progress Telerik

[Taras]

Dimitar,

Thanks for this.  I'll investigate.

 

Regards,

Taras