🍉 Meet Flexmonster Pivot Table & Charts 2.9.Check out all hot features!
Get Free Trial

Why not calculated fields

Hunter asked on August 18, 2017

Input data:
___ocsv2___2.321/2.213 +OfficeName,-CanvassHours,-TotalHours,-PACAmountPFU,-PACAmountNoPFU,-PACCountNoPFU,-PACCountPFU,-OTGAmount,-OTGCount TO Verification,267,0,0.00,29,0,0,0,0 ^0,267,0,0.00,41,0,0,0,0 TO PFU 1,96,0,0.00,18,0,0,0,0 ^1,96,0,0.00,40,0,0,0,0 ^1,96,0,0.00,22,0,0,0,0 ^1,96,0,0.00,15,0,0,0,0 ^1,96,0,0.00,16,0,0,0,0 ^1,96,0,0.00,5,0,0,0,0 ^1,96,0,0.00,44,0,0,0,0 ^1,96,0,0.00,64,0,0,0,0
Saving report in attached file.
When I open this file – PACaNoPFU is no have a data. Cells is empty.


6 answers

Dmytro Zvazhii Dmytro Zvazhii Flexmonster August 21, 2017

Hello Hunter,
Thank you for your question. We have tried to reproduce the issue using the data and the report example but everything works fine. Please have a look here: https://jsfiddle.net/flexmonster/r646krcL/. Could you provide us with some specific information about your case, so we can reproduce it on our side? The code example and the steps to reproduce are appreciated.
Waiting for the update from you.
Best regards,

Hunter August 31, 2017

I working with dinamicaly data. (My URL have parameter date(!))
I need once saved format apply to different reports.
Is FlexMonster have ability to save only format (without loading data)?
Or may be you will advise me how to work with the format in context of the described task

Dmytro Zvazhii Dmytro Zvazhii Flexmonster August 31, 2017

Hi Hunter!
Yes, you can work with dynamic data. 
Please read this article http://www.flexmonster.com/blog/sql-pivot-table-best-performance/ and I hope you will find some useful information there.

Hunter August 31, 2017

Thank you for answer, but this is not what I need.
I tell about formatting cell. How I can save only cell format and apply his to any reports?

Dmytro Zvazhii Dmytro Zvazhii Flexmonster August 31, 2017

Please look at getFormat and setFormat API calls.
You can save formats using getFormat method and restore via setFormat.
Does it help?

Hunter August 31, 2017

Yes that’s it!
Tank you.

Please login or Register to Submit Answer