Menu
Download Free Trial

Export excel along with additional details.

Hi,
In excel export, can we display/add some additional text on top of actual data along? for example, username, timestamp which are not binded to flexmonster grid.
please refer screenshot.
Thanks & Regards,
Sunilkumar.V

8 answers

Public
Roman Petrusha Flexmonster May 18, 2016

Hi!

Yes, it’s possible please add the following block to your report xml file
<customFields>
<field name=”Field1″ value=”Value1″></field>
<field name=”Field2″ value=”Value2″></field>
</customFields>

Does it work for you?

Regards,
   Roman

Public
kumar May 18, 2016

Hi Roman,
I was using JSON datasource and data will be bind dynamically to flexmonster. I added customFields as an array to report object but, when I export it it’s not exporting custom fields. please look at my code below and suggest.
var report = {
dataSourceType: “json”,
data: jsonData,
rows: [{ uniqueName: “M” }],
columns: [{ uniqueName: “Geography” }, { uniqueName: “[Measures]” }],
measures: [{ uniqueName: “Quantity”}],
configuratorActive: false,
viewType: “grid”,
customFields: [{name:”Field1″,value:”Value1″},{name:”Field2″,value:”Value2″}]
};
flexmonster.setReport(report);
 
Thanks & Regards,
Sunilkumar.V

Public
Dmytro Zvazhii Flexmonster May 19, 2016

Hi Kumar,
Thank you for your question. Unfortunately, there is no such an option to set it via report object in the current version of the component. It will be added within the next minor release 2.214 (ETA Jun 6).
Please let me know if this works for you.
Best regards,
Dima.

Public
kumar May 19, 2016

Hi,
 
Thanks for your support.
We can wait for the minor release 2.214 on export. but, I would like to see how actually displays in excel report when we define customFields.I added below block to my report.xml but, still I was not able to see the additional fields data in exported file.
 
For reference, I sent report.xml through e-mail. please check and let us know.
 
Thanks & Regards,
Sunilkumar.V

Public
Dmytro Zvazhii Flexmonster May 19, 2016

Hi Kumar,
We are sending you a video of how you can do it. The video is made from our web site(flexmonster.com).
Here is the link http://screencast.com/t/bum35nUYhpMP.
Hope it will help you.
Best regards,
Dmytro.

Public
kumar May 19, 2016

 
Hi,
Thank you for detailed video.
 
Thanks & Regards,
Sunilkumar.V

Public
Ian Sadovy Flexmonster June 7, 2016

Hello Sunil,
 
I’m glad to inform you that customFields is now available in JSON.
Please download the fix from our site.
 
Regards,
Ian

Public
kumar June 7, 2016

Hi Ian,
Thanks for an update. I will download latest and check it.
Thanks & Regards,
Sunilkumar.V

Please login or Register to Submit Answer