TechTips / Database


 
User Rating: / 8
PoorBest 
 
TechTip: Know the Drill! PDF Print E-mail
Tips & Techniques - Database
Written by Gene Cobb   
Thursday, 13 December 2007 18:00

Enhance your DB2 Web Query reports by using drill-down capabilities.

By Gene Cobb

 

Hopefully, by now you've had a chance to install and use the new DB2 Web Query for System i tool. Hailed as the successor to the popular Query/400 product as the strategic System i query and reporting tool, DB2 Web Query can do things that Query/400 could only dream of. One of these advanced features is drill-down: the ability to select a column in a high-level (summary) report and click through (drill down) to show the next level of detail in another report.

 

Two types of drill-down capabilities can be implemented with DB2 Web Query:

 

·        Programmatic drill down—This requires developing at least two reports: a high-level summary report (also called the parent) and a detail report to link to (the child). The parent report contains the information necessary to link to the child report. The child report could in turn drill down to another linked report to reveal the next level of detail. Each new level of drill-down requires the creation or existence of another linked report. Add a comment
Last Updated on Friday, 12 February 2010 10:03
Read more...
 
User Rating: / 10
PoorBest 
       
User Rating: / 1
PoorBest 
 
<< Start < Prev 1 2 3 4 5 6 7 8 9 10 Next > End >>

Page 8 of 13

WEBCAST

MC Webcast CenterFEATURED WEBCAST

See What i Can Do With Modern RPG Development

Your applications deserve more than just a new look! Change the perception of the IBM i as “old” with modern development tips from IBM and Profound Logic Software.
Watch as Barbara Morris, Brian May and Alex Roytman dive beneath the GUI surface to show the benefits of:

 

  • Working with free-format RPG in IBM i TR7
  • Breaking free from “The Cycle” of traditional RPG development
  • Going beyond the 10 character limit in display and database files
  • And more!

You'll also see a live demonstration of these techniques as the presenters create a modern web application before your eyes! 

 

Watch the Webinar Now!

 

TRIAL SOFTWARE

MS Office Connector for Query/400

NGS' Qport Office enables Windows users to run IBM Query/400 queries to: 

 - Create and update Excel spreadsheets and Access databases

 - Create Word documents

 - Send to Windows screen and PC printers

No query conversion is required. Works with i5/OS V5R1 & above. Installs in minutes!

If you don’t have a budget to replace IBM Query/400, but want your users to have one click enhanced output of their queries.… Request the online license agreement and product download instructions today!

Offer good through December 31, 2013.


   MC-STORE.COM