Get Free Trial

Titles on reports

Alberto Nudman asked on September 12, 2017

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

Tanya Gryshko 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:
Does it work for you?

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: “”,
  width: “100%”,
  height: 430,
  toolbar: true,
  report: {
    dataSource: {
      data: getData()
    slice: {
…  }

Ian Sadovy 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.

Please login or Register to Submit Answer