Discover How To Create AS/400 Reports In A Flash

 

Discover how you can start creating professional AS/400, iSeries and IBM i reports in a flash. As quick as 3-2-1, even if you are a total beginner.
 
Let me tell you, after several years in the IT industry I have spent a good number of hours writing reports. And if you work on an AS/400, iSeries or IBM i like me you can expect to write a number of reports.
 
This is true if you are in the IT department or not and need access to any kind of data from the system. The "canned" reports on don't really get at the data the way you WANT or NEED it.
 
My tool of choice for cranking out reports fast is Query/400 and Query for iSeries. Yet in spite of its power many people are frightened of using Query. Some folks assume it takes IT techno-guru-magic powers to create good looking reports. But...
 
That Is Not True
 
If you need reports done fast and I mean really fast... Query/400 or Query for iSeries is your one way ticket. It works so well because it is tightly integrated to the AS/400, iSeries and IBM i operating system. It takes full advantage of features like batch processing and spool files unlike other third party reporting tools.
 
And Query is SIMPLE to write reports with... once you learn how.
 
But then the question is how do you learn query? You can try to wade through all 302 pages of IBMs Query/400 technical reference manual. But that will probably take you several days or even weeks to read. And the manual is hard to understand technical jargon. Who has time for that?
 
Or you can try to learn query the hard way. By opening up the program, stumbling around and trying different things until you get something to work. That's how I started but I wasted alot of time to get query to do exactly what I wanted. But hey, a blind squirrel can find a nut sometimes.
 
There simply has to be a better way than thick technical reference manuals or trial and error. So what if I could shave the Query learning curve to a fraction of the time it takes to read a book. Would you be interested to find out more?
 
Query In A Flash
 

 

My "Query In A Flash" home study course is more effective way to learn Query/400. It's time to ditch the technical manuals. Because the course is made from easy to follow screen capture video you WILL go from total Query/400 newbie to seasoned expert in a few quick lessons.

 

This will save you hours of time and frustration going it alone and trying to figure it out. Not only is the course easy to follow, all the complicated pieces you will never use are taken out. Like creating reports using un-matched records. I have never used that "feature" of query. But if you followed the regular user manuals you wouldn't know that.

 

This is a meaty course, delivered on data CD. It will cover your report writing needs. You will learn exactly the steps to get up and running fast.

 

Follow Along Step-By-Step

 

And here is the best part. The entire Query In A Flash course is a series of step by step screen capture videos. Simply point and click. No more boring audio programs trying to figure out what to do. I take you by the hand and show you precisely what to do and eliminate ALL the guesswork. Goodbye to magic smoke and mirrors.

 

Anyone can learn to write reports with Query/400 using my course.

 

This reduces the time to master query because it's point and click. You don't have to guess what to do next.

 

Each section is broken up by specific topics. You simply locate a topic, like how to add subtotals to your report and press the play button. How easy is that?

 

Put It Together

 

So what will you get when you order Query In A Flash? Good question. The entire course comes on a data CD-ROM with 20+ step by step screen capture videos.

 

More than 3 hours of instruction.

 

Here are some of the techniques you will discover:

·      Introduce the IBM i object file system for non-techno folks.

·      Creating, managing and running query definitions.

·      How to save, copy and use a query later.

·      How to setup the database file you want to query.

·      Simple methods for choosing the right set of data for your query.

·      Grouping together data sets.

·      Adding report totals and sub-totals.

·      Save paper and your sanity by only printing the report totals instead of the details.

·      Polishing up your reports so they shine with headings and formatting.

 

Even if you are a total Query/400 beginner you will have created your first report, from start to finish in less than one hour. Pretty simple, huh?

 

Packed In More Query Topics

 

Once you have the report building basics, I am going to show you advanced Query/400 techniques that some query "pros" don't like:

 

·      How join together records from different data files

·      The correct join techniques to use and why they matter

·      Tricks for joining data files by different data types

·      Create your own custom and calculated fields

·      How to run queries in the background using batches

·      Convert character fields to numeric

·      Convert numeric fields to alphanumeric

·      Change Julian dates to regular dates

·      Create a Yes/No Cross Reference File

·      Using dates for calculations and sum number of days between dates

·      Formatting column sizes and column headings

·      Concatenate character fields

·      Substring character fields together

·      Select Records using Lists

·      Select Records using Ranges

·      Select Records using Like comparisons

·      Output query results to a database file or for downloading to Excel

·      Create report page breaks

·      Querying files with multiple database members

 

All of the material is shipped directly to you on CD-ROM. To get started pop the CD in your computer and press play. Query In A Flash is like having me as your own 1-on-1 coach standing over your shoulder showing you exactly what to do.

 

My Personal Money Back Guarantee

 

I want you to be totally happy with my course. If at any time you feel you did not get at least ten times your investment simply ask for a full refund including shipping costs.

 

You read that right, I will refund ALL of your money including the cost of shipping. You really have no risk in at least trying Query In A Flash.

 

So let's recap. When you order today you will receive the entire "Query In A Flash" home study course. You get all of the instructional screen capture videos. You are also covered by my better than money back guarantee.

 

Go ahead and visit the order link below right away to claim your copy.

 
Warm Regards,
-John Andersen