robert fuschetto Posted September 14, 2021 Share Posted September 14, 2021 We have a dashboard with an option to export to Powerpoint. We just added a smal FML report to the dashboard without issue. When trying to add tot the Power Point fex, I am getting the error belowany ideas Link to comment Share on other sites More sharing options...
Manoj Chaurasia Posted September 14, 2021 Share Posted September 14, 2021 Do you have the command SET PANEL = somenumber in your code because that is what it is complaining about. Link to comment Share on other sites More sharing options...
robert fuschetto Posted September 14, 2021 Author Share Posted September 14, 2021 the word PANEL does not appear anywhere in the fex. The report renders fine on the HTML page itself, I just can not add to the HTML PPTX document. Link to comment Share on other sites More sharing options...
Manoj Chaurasia Posted September 14, 2021 Share Posted September 14, 2021 I saw a post in Focal Point where John Edwards had the same issue but was not resolved. I searched on FOC3395 to find it. You may need to open a case with techsupport. Link to comment Share on other sites More sharing options...
robert fuschetto Posted September 14, 2021 Author Share Posted September 14, 2021 Hey Chuck, do you have a link to that I can not find anything here for FOC3395. Link to comment Share on other sites More sharing options...
robert fuschetto Posted September 14, 2021 Author Share Posted September 14, 2021 robertf: FOC3395 waitperhaps you meant the old forumlet me look Link to comment Share on other sites More sharing options...
robert fuschetto Posted September 14, 2021 Author Share Posted September 14, 2021 well I found this: http://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/6867066496r=4677096496#4677096496 But we are not trying to do a compound report. Sound like we need to open another case Link to comment Share on other sites More sharing options...
Manoj Chaurasia Posted September 14, 2021 Share Posted September 14, 2021 I did http://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/6867066496r=4677096496#4677096496 It is so nice to have it back! Link to comment Share on other sites More sharing options...
robert fuschetto Posted September 14, 2021 Author Share Posted September 14, 2021 that is what I foundbut not helpfull so far Link to comment Share on other sites More sharing options...
SATHEESH B Posted September 14, 2021 Share Posted September 14, 2021 Have you enabled the alignment grid for the Header or footer sometimes if the header exceeded or go beyond the the page size you may get the error. try to increase the page width or try to remove the alignment grid and test it Link to comment Share on other sites More sharing options...
robert fuschetto Posted September 14, 2021 Author Share Posted September 14, 2021 no grid enabling. Will try a few other things Link to comment Share on other sites More sharing options...
robert fuschetto Posted September 14, 2021 Author Share Posted September 14, 2021 Some things we have noticed. We got it to run by deleting 7 of the 11 columns. when it does run I can see that if I had a few more columns it would indeed spill off the pagebut why We have other WF reports with 11 columns and somehow it sizes itself to fit. THIS REPORT IS AN FML REPORT! I suspect somehow that is playing into this. I am no FML expert but I sit next to one. However we are not what to do to size things down in FMLanyway any ideas Link to comment Share on other sites More sharing options...
robert fuschetto Posted September 14, 2021 Author Share Posted September 14, 2021 So, bottom linesomething odd happens when you use the PP feature with FML. There is no autosizing for one; at least that I can see. I did go into my FML fex and shrunk some stuff down and deleted some columns and I got it to fitbut it looks horriblesomehow the Font chosen in FML is lost and everything presents in Times Roman. Again the HTML page is great but something is going on with PPTX. I can open a case if o one lese has any ideas Link to comment Share on other sites More sharing options...
robert fuschetto Posted September 14, 2021 Author Share Posted September 14, 2021 here is the report as presented in HTML: and this is what I get in PP: image.png874195 3.03 KB I cant have the latter processed into PP looking like thatyet they need that report. Anyone have any thoughts Link to comment Share on other sites More sharing options...
robert fuschetto Posted September 16, 2021 Author Share Posted September 16, 2021 before I open a case, amyone have any ideas why I loose my font formattinf for the FML HTML report when it gets loaded to PP by WF image.png879436 42.7 KB Link to comment Share on other sites More sharing options...
SATHEESH B Posted September 17, 2021 Share Posted September 17, 2021 Seems like the sum of total column widths exceeds page width. Auto Fit column may work with HTML but PDF and Powerpoint may be different. one of the customer had same issue with PDF. Try to change the report orientation to landscape and try 11x17 size also reduce margin . once the report rendered with out issue you may try the fixed column width by adjusting the column. ruler may help to check the width. Link to comment Share on other sites More sharing options...
robert fuschetto Posted September 24, 2021 Author Share Posted September 24, 2021 Thanks. My resolution was delete all the formatting from beginning to end in the code and then reform in FML and all of sudden font issue were gone. I was also able to get it to fit better by shrinking some columns. So there was something in there that messed up the fontsno idea what. Sadly that seems to be the norm with WF as you upgrade doing things from scratch. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now