Despite the COVID-19 outbreak, our team continues operating at full speed. We are always here to support and answer all your questions.

Feel free to reach out by filling this quick form.

Fill the form
Get Free Trial

DrillThrough columns change change after editing the fields

Answered
Devesh asked on August 9, 2019

Hi team,
I have configured the ‘slice.drillThrough’ array with n number of fields. when I double click the cell, I can see all the fields/columns on popup as configured. But when I edit the rows and columns  from ‘Fields’ option in toolbar and apply changes and then double click the cell, I don’t see the pre-configured fields and the ‘drillThrough’ array items are changed by tool.
How can I keep the ‘drillThrough’ array same as configured even after editing columns and rows.

4 answers

Public
Vera Didenko Flexmonster August 12, 2019

Hello,
 
Thank you for your question.
 
For such cases, we kindly advise specifying the slice.drillThrough configuration in the global object:

global: {
slice: {
"drillThrough": [
"Business Type",
"Country",
"Price"
]
}
}

 
Here is a JSFiddle example for illustration: https://jsfiddle.net/flexmonster/0f9c8xg5/

Please let us know if this works fine for you.
 
Best Regards,
Vera

Public
Sangamesh August 13, 2019

Where to include the above global configuration?
 
I am configuring in typescript as below.
 
public pivotReport: any;
this.pivotReport = {
dataSource: {
dataSourceType: “ocsv”,
filename: Url,

},
slice: {
reportFilters: [],
rows: [],
columns: [],
measures: [
],
drillThrough: []
},
};

Public
Vera Didenko Flexmonster August 13, 2019

Hello, 
 
Thank you for your response.
 
The global object is a separate Flexmonster parameter, not part of the report object (see: https://www.flexmonster.com/api/new-flexmonster/ ).
 
Please consider the following example:
1) Let’s specify global in fm-pivot in app.component.html:

<fm-pivot #pivot

...

[height]="450"

[global]="pivotGlobal"

[report]="pivotReport"

....

>

</fm-pivot>

 
2) Next, let’s define pivotGlobal in app.component.ts:

public pivotGlobal = {

slice: {

"drillThrough": [

"Color",

"Country",

"Price"

]

}

};

 
Please let us know if everything works.
 
Best Regards,
Vera

Public
Sangamesh August 14, 2019

Thanks. It worked

Please login or Register to Submit Answer