Always display multiple unique columns

posted on March 11th, 2022

Answered

Stelios asked on March 11, 2022

Hello,

We are considering to buy flexmonster, to transition our existing reporting tool, and I have a couple of questions.

In some of our reports, we use two unique columns to identify each row.

(TaxNumber and Company Name)
Is there a way to always display these two rows in those reports, without the need for the expand arrow??
(Check the attached image)

2) When clicking on a numeric cell, it displays the "Details" pop-up.
Is there a way to export to EXCEL from this window??

Thank you.

Attachments:
flexmonster-columns.png

2 answers

Public

Nadia Khodakivska ⋅ Flexmonster ⋅ March 11, 2022

Hello, Stelios,

Thank you for reaching out to us.

Please find the answers below:

To show both columns without needing to expand each row, you can set expandAll property to true in the expands object of the slice:
```
"expands": {
   expandAll: true
}
```
Please check the following sample illustrating the described approach: https://jsfiddle.net/flexmonster/xsdqj5yp/
To export the data from the "Details" pop-up, you should open the necessary window, hover a cursor over the "Export" tab on the Toolbar, and click on export to Excel just like you would do with a regular report.

Please let us know if everything works fine. Looking forward to hearing from you.

Kind regards,
Nadia

Public

Stelios ⋅ March 14, 2022

Hello, Nadia,

Thank you for your response.

The answers you provided seem to do what we need.

However, as I was testing, I noticed a weird behavior in the SUM column.
The generated (from the script) column only sums the integer part of the numbers, while the column I added manually, sums correctly the decimal parts.
(In the image "Total sum of Total" is the generated column, while "GrandTotal" is the column I added manually).

Is there something I need to do in the script code??

The code for the report I am using:

report: {
dataSource: {data: jsonData},
slice: {
rows: [
{uniqueName: "TaxNumber"},
{uniqueName: "Company Name"}
],
measures: [{
uniqueName: "Total",
aggregation: "sum"
}],
expands: {
expandAll: true
}
},
options: {
grid: {
viewType: "grid",
type: "classic"
}
}
},

Kind regards,
Stelios

Attachments:
flexmonster-sum-error.png

↪ Nadia Khodakivska created a new ticket #44720 from this answer

Changes to Flexmonster Software License Agreement

Always display multiple unique columns

2 answers

Please login or Register to Submit Answer