First let me say I am new to jet reporting and I'm hoping this is an easy fix. I have created a report using Jet Essentials Table builder in Excel 2010. Each time I submit the report I loose my excel formatting. How do I retain my formatting in Excel?
Thanks in advance for your assistance!
Teri
Date
Votes
5 comments
-
Jet Reports Historic Posts Hi Teri,
The Table builder generates an Excel table. If you refresh the report, you will lose any formatting you do on that table. However, if you create a Pivot table / Pivot chart (Excel tab Insert) on the table and do your formatting there, this won't happen. The formatting in the Pivot table is kept.
Does that help? -
Jet Reports Historic Posts Yes, Thank you!
-
Lars Hammersholt Petersen Is there still no solution to this other than using a pivottable?
-
Harry Lewis Hello Lars -
Each time that the report is run a new Excel table is created. So
If you feel that having the ability to define and retain formatting using the Table Builder would be beneficial to the Jet community, I would encourage you to submit that feature idea using the Give Feedback button on the right of this screen.
-
Lars Hammersholt Petersen Hi Harry
Thank you for your answer. I have a client that would like the feature, so I will submit the idea
Please sign in to leave a comment.