Ksim
January 4, 2019, 5:17am
1
Continuing the discussion from Freezing Columns in Report :
I followed @magic-overflow method and successfully freezing the column, however all my query reports is no longer clickable.
It’s working fine at my side.
Can you click any cell in second row?
Ksim
January 4, 2019, 8:06am
3
It works fine and all, but it cant have a redirect link to another doctype.
Eg, it works before i apply your feature, it has a underline and can click to go another doctype/link.
Link is working fine.A100000 | CURRENT ASSETS , it will redirect to General Ledger and filter by account A100000 | CURRENT ASSETS .
Ksim
January 4, 2019, 8:25am
5
Could it be my Custom Report problem?
Profit and Loss Statement (Not custom) seems to work fine.
I’m not quite sure about Dynamic Link field in the report.
But you can see Trial Balance report below, it doesn’t use Dynamic Link , it use formatter.
This Trial Balance report example:
"fieldname": "show_zero_values",
"label": __("Show zero values"),
"fieldtype": "Check"
},
{
"fieldname": "show_unclosed_fy_pl_balances",
"label": __("Show unclosed fiscal year's P&L balances"),
"fieldtype": "Check"
}
],
"formatter": erpnext.financial_statements.formatter,
"tree": true,
"name_field": "account",
"parent_field": "parent_account",
"initial_depth": 3
}
});
formatter js function:
frappe.provide("erpnext.financial_statements");
erpnext.financial_statements = {
"filters": get_filters(),
"formatter": function(value, row, column, data, default_formatter) {
if (column.fieldname=="account") {
value = data.account_name;
column.link_onclick =
"erpnext.financial_statements.open_general_ledger(" + JSON.stringify(data) + ")";
column.is_tree = true;
}
value = default_formatter(value, row, column, data);
Edit:
Column type need to be Link.
row["has_value"] = has_value
data.append(row)
data.extend([{},total_row])
return data
def get_columns():
return [
{
"fieldname": "account",
"label": _("Account"),
"fieldtype": "Link",
"options": "Account",
"width": 300
},
{
"fieldname": "currency",
"label": _("Currency"),
"fieldtype": "Link",
"options": "Currency",
