We have a dashboard with an option to export to Powerpoint. ...

[robert fuschetto]

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

[Manoj Chaurasia]

Do you have the command SET PANEL = somenumber in your code because that is what it is complaining about.

[robert fuschetto]

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.

[Manoj Chaurasia]

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.

[robert fuschetto]

Hey Chuck, do you have a link to that I can not find anything here for FOC3395.

[robert fuschetto]

robertf:

 

FOC3395

 

 

waitperhaps you meant the old forumlet me look

[robert fuschetto]

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

[Manoj Chaurasia]

I did http://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/6867066496r=4677096496#4677096496 It is so nice to have it back!

[robert fuschetto]

that is what I foundbut not helpfull so far

[SATHEESH B]

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

[robert fuschetto]

no grid enabling. Will try a few other things

[robert fuschetto]

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

[robert fuschetto]

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

[robert fuschetto]

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

[robert fuschetto]

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

[SATHEESH B]

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.

[robert fuschetto]

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.