The following articles were written by developers like you and contain cutting-edge tips and techniques for using Information Builders' products. Let us know if you have an idea for an article. Also, be sure to check out the infamous McGuyver Technique that can solve myriad reporting problems with a DEFINE-based JOIN, and some additional DEFINEs.

What Is WebFOCUS? Grzegorz Swietlik, a freelance IT consultant and software developer, answers this question from a developer's perspective.

Generating Data/Accessing Data

• NEW From GUI to Hand Coding 101 Wondering how JavaScript can be integrated with WebFOCUS products? Alan Bell, formally an IBIer and currently a free-lance consultant and trainer for Information Builders product set, presents an introduction on switching from the GUI tools and hand coding your web forms via JavaScripts and HTML.
• Dense Data or No Data: Tony Alsford, an IT Consultant in the UK market, explains how to produce a report using WebFOCUS that shows all possible data values within a grouping, irrespective of whether they exist.
• NEW Search WITHIN for the answer: Mickey Grackin, IT Specialist from NIST, shows the technique using WITHIN on percentage calculations, instead of using a multiple-verb request and therefore, accomplish the result with less code.
• NEW Using user.htm files from basedir: Jim Zimmerman from U-Haul explains a way to report on the contents of the user.htm file in basedir.
• NEW One Access File, Multiple Databases: Geert Van Hecke, functional analyst from SECUREX Belgium, shows how to enable user’s access to different databases without change or duplicate access file. User can also choose the database he/she wants to access.
• NEW Using IOEXIT to access MF Data: Hideki Kirihara from EXA Corporation of Japan represents a solution to produce a report from a large sequential, compressed dataset on MVS. The advantage is that, decompression and code-conversion are done at the same time without any work files, and therefore less network time, less code conversion cost.
• NEW Creating Keys for JOIN:  Steve Simon, Senior Officer from State Street Corporation, gives us a technique that works on joining two files and creates a key.
• "Right Click Export to Excel" Builds WebQueries: A very special and exploitable relationship exists between an html page and Excel XP. The Finance Group in the Millburn, NJ, warehouse of fashion design firm Elie Tahari, Ltd. exploits this feature, and discovered a way to save 12 man-hours every day.
• Zulu Time: Susannah Jones from Elie Tahari, Ltd. tells you how to read the ReportCaster schedule file.
• Using Reg.exe to Offset Time Zones From a Windows-Based System: Information Builders' John Gray updates "Zulu Time" by showing how to automate switching time zones from EST to EDT when reading the botsched file.
• Conditional JOINs: Mohammed Zafrullah, an Information Builders contractor, explores the option of using WebFOCUS code, instead of SQL passthru, to join tables that have more than one equality condition.

Generating Data/Launching the Report

• NEW Triggering WebFOCUS Reporting: Darin Lee, Senior Systems Analyst from Workers Compensation Fund (Utah), explains the technique of using ReportCaster and APIs to generate reports and sent the output to any desired printer.
• NEW Dynamic Forms: Sometimes data need to be updated periodically but manual updates can be inefficient. Harry Cleveland, Assistant Director of MIS in Temple University, presents the technique of creating dynamic forms for different datasets, allowing users to choose cycles and be notified when the batch job is submitted.
• How to Automatically Delay ReportCaster Jobs: Sometimes data loads take longer than planned. Jodye Yates explains how to delay report distribution in 10-minute increments.
• UltraEdit: Kelly Snodgrass shares his tip regarding how to execute FOCEXECs from within UltraEdit.

Formatting Reports

• How to Draw a Box Around a Column of Data in a PDF Report: Jodye Yates from Air Canada explains how to dynamically draw boxes on a PDF.
• Inserting Images Into WebFOCUS Graphs: Information Builders' John Gray shows you how to give your graphs some style with graphics in several formats.
• WebFOCUS HTML and PDF Report Design PartI and Part II: Mickey Grackin explains many of the formatting options available for designing WebFOCUS reports using the HTML and PDF output formats – and discusses the differences between them.
• Creating Excel Macros: Information Builders' John Gray explains how to create Excel macros in versions of WebFOCUS prior to 7.1.
• Rotating Column Text Title: Dennis Van der Vieren from Qwest Communications explains the technique on rotating column header text to reduce horizontal space on HTML reports with ACROSS columns.
• How to Remove the Blank Line Between Title and Data in PDF Reports: Kasi Krishnan explains this simple yet tricky process.
• Excel Colorname Key – What Is "Indian Red," Anyway?: Susannah Jones from Elie Tahari, Ltd. provides a key sheet for all of the WebFOCUS color names deriving their hex value, their RGB value, and a block of the color itself.
• GRAPHTYPE: Dressing them up, changing their colors, controlling their width, and even stacking them. Susannah Jones from Elie Tahari, Ltd. tells you how.
• Pictogram Technique: Dan Grady, a strategic engineering product leader from Information Builders, shows you how to spice up your report by using pictures, rather than simple bars, to represent your data.
• Add Pop-Up Information to WebFOCUS Reports: Dan Grady, a strategic engineering product leader from Information Builders, shows you how to reveal additional information in a report by moving the mouse over a specific record.