Menu
Download Free Trial

Titles on reports

Hi
I have been asked to display a title on the reports, when the data is exported to Excel. Currently, only the pivot table data is shown, but no title or date is displayed.
Is there any chance to add some static data to the Excel file, when exported?

3 answers

Public
Tanya Gryshko Flexmonster September 13, 2017

Hello Alberto,
Thank you for writing.
Please try adding the title to your report. You can set the title you want and it will be exported to the Excel file. Check the example on JSFiddle that shows how to set grid title: http://jsfiddle.net/flexmonster/afr1g5Lf/.
Does it work for you?
Regards,
Tanya

Public
Alberto Nudman September 14, 2017

Dear Tanya,
This is very useful. However, it would be even better if I could set the title in the report static definition, without having to use the button. Is there any chance to set it in the following structures?
var pivot = new Flexmonster({
    container: “pivot-container”,
  componentFolder: “https://cdn.flexmonster.com/”,
  width: “100%”,
  height: 430,
  toolbar: true,
  report: {
    dataSource: {
      data: getData()
    },
    slice: {
…  }
});

Public
Ian Sadovy Flexmonster September 14, 2017

Hello Alberto,
 
Sure, you can define the title in the report configuration.
Please use report.options.grid.title property for that.
Let me know if you have any further questions.
 
Regards,
Ian

Please login or Register to Submit Answer