Re: Do people still use STRRLU for AS/400 Formatted Reporting or StrQM ? -- MIDRANGE-L

Well, not a question of better. PRTFs and QMQRYs are completelydifferent animals. PRTFs give you more control over what you see in areport. QMQRYs by themselves give you a default layout in columns. Ifyou want formatting, you need to couple a QMQRY with a QMFORM. QMQRYsand QMFORMs together give you what QRYDFNs do by themselves - get thedata and present it on screen or in a report.

You cannot use a QMQRY as you would a PRTF in RPG - it is not a filethat can be named in an F-spec. It is executed using the STRQMQRYcommand, where you can optionally name the QMFORM used forpresentation. And this is a CL command, so it is not intended for usein RPG - yes, you CAN use QCMDEXC, but that's not what it's for, forthe most part.

As I posted, source record length is irrelevant - long constants andcaptions, etc., get wrapped properly in the keywords columns.

There has never been a point to VARCHARs in PRTFs. You handle them byreading the physical file with the varchar in RPG, then writing outto the PRTF after moving the data to a report field. You know this, I think.

As to header/detail reports, it might be possible with QMQRYs - I'venever done it, and I use these things all the time. And promote themall the time. Consider first that a QMQRY is a single SELECTstatement - essentially a single file in RPG terms. you'd need to usea JOIN to get header and detail information together. No such thingas reading the header file, then getting matching detail records. I'dsay regular RPG file processing is probably more efficient thatjoining in a SELECT statement. Can't prove that, however.

Now it is possible to use level breaks in a QMFORM. And you can havebreak level text. You can have a header for each break, specify thatit does not start on a new page, and that column headings are notrepeated. You can put field references into this header. You can alsohave footers, which is typically where subtotals go. And you can putfield references there, as well. So you could probably get aheader/detail report - might be very nice, in fact. There are somelimitations - e.g., the header/footer text in QMFORMs must all be inpieces <= 55 long. But you can have LEFT, CENTER, & RIGHT on the samelines, so this isn't so bad.

If you use QMQRY/QMFORM you would not need the RPG at all, probably.QMQRYs can have substitutions variables, so you can use a CMD frontend to a CL to get the values you want to put into the SELECT, thenstart the QMQRY, and ba-da-bing, you're done.


HTH - I know I might try this a little more myself.
Vern

At 02:40 PM 3/5/2006, you wrote:

Which is more better for reporting in RPG, STRRLU or STRQM?

I have noticed that STRRLU PRTF File does not support :-

1. Source File > 92
2. Varchar Field

Any suggestions please?

Can I create a formatted report in STRQM, say, a Master/Detail Report.

for example:-

Master Record
==========

Name   :   Luqman                  Address: Room No. 27, Cantt Road,Karachi
Tel       : 1234567                   E-Mail : myemail@xxxxxxxxx

Detail Record
==========
Order Details of Luqman
Item No.    Quantity    Rate    Amount
1                23             1         23.00
2                20             2         40.00
                 ---                         ------
   Total:      43                         63.00
                 ---                         ------

Best Regards,

Luqman




--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.