Why not calculated fields
___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.
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.
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
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.
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?
Yes that’s it!