logo

Warning: The forum is now for consultation only. Please use GitHub Discussions to post any questions or comments.


Welcome Guest ! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
Erwin  
#1 Posted : Friday, April 15, 2022 3:27:38 PM(UTC)
Erwin

Rank: Newbie

Groups: Registered
Joined: 4/15/2022(UTC)
Posts: 1
Indonesia
Location: Jakarta

Is posible if i want to create datatable column seal report like this?
Name value position
Jack 50 Manager
John 60 Staff
Total 110

Because currently, i cant set value column to middle of table.
Value with total always at right position cant set at middle

Please anybody help..
epf  
#2 Posted : Sunday, April 17, 2022 7:05:31 AM(UTC)
epf

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 1,209
Switzerland

Thanks: 14 times
Was thanked: 205 time(s) in 198 post(s)
it is not so easy to do that.

You can use the Advanced Element properties 'Custom SQL' to define an aggregate (e.g. 'SUM(amount)'), plus 'Force Aggregate' to True.
This allow to define aggregate in Rows or Columns elements.
However it will not gives the Total row.

For this, you have to change data in Task Scripts, or to change the Rendering in the Data Table Template.
Users browsing this topic
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.