New to Telerik Reporting? Download free 30-day trial

Right to Left Format in Table

Environment

Product Progress® Telerik® Reporting

Description

By default, the group value will be displayed on the left side of the table. There are some workarounds that allow putting the group on the right.

Solution

Workaround 1 demonstrated in Report1:

1) Add a CSV DataSource (with Group, Item and Value fields) and set it to be the DataSource of the report.

2) Add a group to the report: right-click outside the report -> Add New Group and set the Expression to be "=Fields.Group";

3) In the groupHeaderSection add a textbox whose Value is "=Fields.Group";

4) In the detail section, add textboxes containing "= Fields.Value" and "= Fields.Item"

Workaround 2 demonstrated in Report2:

1) Add a CSV DataSource (with Group, Item and Value fields) but don't set it to be the datasource of the report;

2) Add a table through the Table Wizard -> set its DataSource to the csvDataSource -> add only the Item and Value fields.

3) Right-click over the table -> Add group -> Row group - Parent Group;

- Set the **Expression** to be "=Fields.Group";

- Mark **Add Header** -> **OK**;

4) Right-click over the table -> Insert row -> Outside Group Above;

- Move the headers of the table in the new empty row over "= Fields.Value" and "= Fields.Item";

5) Right-click over the table -> Insert Column -> Right;

- Merge the upper header and set its **Value** to be  "=Fields.Group";

6) Remove the unnecessary column of the group (Delete column only) and row;

Note that the limitation of this solution is that if you set the property ColumneHeadersPrintOnEveryPage will not work as expected.

Notes

You can download the reports from here.

In this article