ayoob005
(Ayoob)
Août 17, 2021, 10:19
#1
Hi All,
I want to display one grid in which two columns should be under same header, like below screenshot,
The Opening balance is common header for debit and credit column.
Kindly confirm is it possible in Axelor Grid view, If yes, kindly share the code sample to achieve this.
siddique
(Siddique Ahmad)
Août 17, 2021, 12:11
#2
yes, you can create this with custom three columns group by account name, custom views are life saver.
<h1>{{first.total}}</h1>
<small>Total sale</small>
<div class="report-percent font-bold pull-right" ng-class="{'text-error': first.down, 'text-success': !first.down}">{{first.percent | number:2}}% <i class="fa" ng-class="{'fa-level-down': first.down, 'fa-level-up': !first.down}"></i></div>
<div class="report-tags"><span class="label label-success">Monthly</span></div>
</div>
]]>
</template>
</custom>
<!-- dashboard data table with predefined template tag -->
<custom name="report-sales-list" title="Some Title">
<field name="total" type="decimal" x-scale="2" />
<dataset type="jpql" limit="10">
<![CDATA[
SELECT self.name AS name, c.fullName AS customer, self.totalAmount AS total FROM Order self
LEFT join self.customer AS c
WHERE YEAR(self.orderDate) = YEAR(current_date)
AND MONTH(self.orderDate) = MONTH(current_date)
]]>
</dataset>
<template>
ayoob005
(Ayoob)
Août 17, 2021, 12:13
#3
Thank you for your update, i will try this