Patrick Huebgen

@robert fuschetto did you tried to test with WHERE REORDLIMIT EQ 1000 just to see if the volume of data is causing a problem - I need to check but the limitation of number of BY fields is higher then 20 could be an issues with volume of data

Check Event.log for ERRORS and Share what you see. if you have auto drill enabled -lease disable and retry.

@James Zucker did you looked into the markup feature - please check Page 765 of the manual - this is quite useful to format elements in PDF https://docs.tibco.com/pub/wf-wf/9.2.4/doc/pdf/IBI_wf-wf_9.2.4_cr_language.pdf Fort the width - make sure to build a TABLE that spans the full page (can be sone if you enable borders to see the TABLE and then make the columns wise enough) as the heading width will use this for it's with as well - additionally using a alignment grid in heading is useful for positioning.

Check page 851 https://docs.tibco.com/pub/wf-wf/9.3.1/doc/pdf/IBI_wf-wf_9.3.1_cr_language.pdf?id=13

9.1 wont do the trick - it's a 9.3 feature

@Garth Colasurdo - which PDF viewer are you using ? Sometimes I saw rendering issues with the PDF engine built into Chrome or Edge but not in Adobe Reader?

@David Briars as far as I recall this is something that was added in 9.30 for XLSX. From the release notes - https://docs.tibco.com/pub/wf-wi/9.3.1/IBI_wf-wi_9.3.1_relnotes.pdf "Positioning Components in Excel Documents You can now position Components in an Excel Compound document. You can position items on multiple worksheets or a single worksheet, and items can be positioned in a fixed location by cell, or relative to each other. For more information, see the ibi™ WebFOCUS® Creating Reports With ibi™ WebFOCUS® Language guide."

Take a look at my latest WebFOCUS - Tips & Tricks tutorial session- Searching for Data in Active Reports This video demonstrates how to use the filtering and highlighting features in active reports. The video shows how to filter data by selecting criteria within column headings. It also demonstrates how to highlight specific values within a column to make them easier to locate. The presenter explains that these features can be used in combination to create complex search criteria, and that they are useful for working with large datasets. Overall, the video provides a clear and concise overview of how to use the filtering and highlighting features in active reports. The presenter's explanations are easy to follow, and the demonstrations are helpful in illustrating the concepts.

@Erin Trotter I created a video on MODIFY a while back - sorry one of the few German Videos - but autogenerated subtitles might help even if some of the translations are "funny" I did something with multicell update as well in the past but seems to have lost it. It was something that created a dynamic HTML form with many fields. I create my form via repeat and !IBI.AMP.XXXX; technique and create dynamic MODIFY based on this form - attached two videos to start with MODIFY and IBI.AMP Here's the modify Here's the IBI.AMP video

Take a look at my latest WebFOCUS - Tips & Tricks tutorial session- Adding icons to navigation in WebFOCUS Portal

Just created a new tutorial video - Calling a WebFOCUS report from repository via direct URL Hope you like it

@Bajr Prakash Singh That is what I'm using here as well and what is recommended to do - great to see you that you were able to fix it.

For the .jar file customization you can check - but again not recommended

@Bajr Prakash Singh ibi_html is now a .jar file not a folder anymore. You can extract the .war add the file and repackage it but for any custom file I would rather recommend to use a folder mapped in Tomcat. The jar file trick is not recommended and would require you to repeat this step after any update. You can create your own folder mapping in in Tomcat and continue to use this or you can put the file into WebFOCUS repository and create a link for this file. The URL depends on the solution you choose .

@Bajr Prakash Singh I'm not sure which file you are referring to via 'ibi_html/publish/text/filename.htm". Is filename.htm a custom file that you are creating? There's was a change in recent version with ibi_html - the way this folder is stored/provided. Regards Patrick