Press Room

Clover, BCD's iSeries Web Query and Reporting tool, Blooms in New Version 1.5

For Immediate Release

Chicago, IL, September 18, 2006: Today, Business Computer Design Int’l, Inc. (BCD) ( announced a new version of Clover Query that includes several key features and refinements to bolster the development of queries and reports delivered real-time via web browsers. BCD also announces that Clover, a $10,000 value, is 40% off when licensed with WebSmart, BCD’s iSeries web application development solution.

Clover is a powerful and easy-to-use iSeries – System i web query and reporting tool that was first introduced at COMMON one year ago. It allows end-users, power users and programmers to design real-time web reports and queries for deployment in browsers. Clover uses templates and wizards to make it easy to write reports with totals, subtotals, level breaks, drill downs, summaries or details, produce online drill down graphs using the SmartCharts feature, export to Excel, and more. It works with existing iSeries or System i database files, and provides SQL wizards to make easy work of building simple or complex relations between files.

Rebuild Report Option

To recreate a report using a different template with the same basic SQL, Clover’s new ‘Rebuild Report option’ makes it easy by allowing you to rebuild your report with the click of a button. Clover automatically populates all of the wizard screens for you so you don't need to go through the wizard process from the beginning.

Non-Report Segment Splitting

Clover’s new non-report splitting feature makes assimilating the information in reports much easier. This feature allows report HTML segments to be displayed in a vertical view so you can see report elements separated into banner, header information, detail information, and totals. Those segments which are user-controlled are easily split out into their own individual tabs.

New Segment Properties Icon

A novel, simplified control for segment properties has been added to the HTML view of report segments. One click of the new icon brings up the window view of segment properties that enables you to add conditions, change the description, and change the type of segment and what the segment breaks on. Segments can be banners, headers, details and totals.

Convenient SQL Option Controls

An innovative toggle feature has been added to Clover’s Attributes / SQL controls to illuminate the actions you take. This feature gives you the ability to change a report back and forth between being a summary report; select only distinct records, change the date format, and limit the number of records retrieved.

Dynamic SQL Preview User-Input Prompting

Clover allows you to view the data produced by your SQL statement at any time while using the query-generating wizard. Now if you have user-input values, work fields or program fields in the query, you will be prompted for the values to be used in these fields which then get plugged in to the SQL query.

Clover complements BCD’s award winning Web development solution WebSmart to give developers the resources to build elegant , leading edge and integrated web and query applications that can be accessed from any browser. Clover is available as a stand alone solution or as an integrated solution with WebSmart. BCD is discounting Clover by 40% to organizations licensing it with WebSmart.

"In one year Clover has made such an impact by offering advanced real-time web query and reporting capabilities to organizations at such a reasonable cost. Offering unlimited number of users and developers has been well received by Clover users. And, our clients simply love the ease-of-use and the integration to our free SmartCharts tool offering drill-down flash charts, graphs, barrels and gauges with web queries.” says Eric Figura, BCD’s Director of Sales and Marketing. “Users once relied on the IT department for their queries because the process of generating them was difficult for most, or they often settled for basic looking queries.. Now nearly anyone can create elegant queries with advanced graphical drill-down functionality."

To receive a Live Web Demo of Clover, ask questions or evaluate the solution yourself, call a BCD Product Specialist (630) 986-0800, or email Free downloads are available at A stand-alone Clover license accommodates unlimited end-users and developers on one System i partition and runs $10,000. It is discounted to $5,950 when licensed with WebSmart.

Gary Stewart, Director IT - Academic Book Services shared his experience with BCD’s solutions. "I reviewed in detail several leading iSeries web application development tools, and query tools to modernize our iSeries applications. I'm very conservative and detest risks and surprises... I like software that works. I selected WebSmart, Nexus Portal, and Clover from BCD. These integrated products set the standard from which all others should be judged. The software works well and the support is tremendous. The decision to use BCD products is one of the biggest no-brainers a CIO can make."

About BCD

BCD has received 35+ industry awards for its software products and has 30 years of experience in the IBM midrange marketplace. Over 30,000 copies of its software products have been sold to 10,000+ organizations. WebSmart, Clover, Nexus, and Catapult are listed on IBM’s iSeries Developers Roadmap. BCD is a member of IBM’s System I ISV Advisory Council and is an IBM Advanced Business Partner. All of BCD’s key products are IBM ServerProven and several are IBM ValueAdd for eCommerce.