Export excel along with additional details.

posted on May 18th, 2016

Answered

kumar asked on May 18, 2016

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

Export excel along with additional details.

8 answers

Please login or Register to Submit Answer