New reports

[romzina]

Hello,

I tried to look around but I haven't find an answer to my question , so I decide to give a trty and post my own !!

I'm new at AS 400 and my client ask me to creat some new reports. Is it any way to creat your own reports from scratch or copy and modify a old report to give me the info I need.


Please help !!!

Thank you very much

Cris

[itp]

Re: New reports

How are reports generated now? RPG program, Query/400, SQL, other tool?

Depending on how you generate reports, copying a existing report that produces similar output and making required changes is a good strategy, especially for beginner.

[romzina]

Re: New reports

Thank you itp !!

The reports are generated as Query/400.

[jamief]

Re: New reports

to find the query you could do this

WRKOBJ OBJ(*ALL/*ALL) OBJTYPE(*QRYDFN)

there are other commands like WRKQRY & STRQRY
which will let you edit or create new queries

then RUNQRY to run or run from withing one of the above commands

jamie

[romzina]

Re: New reports

Thank you and I'll try it !!

[jamief]

Re: New reports

great..
heres a small example of changing a query

http://www.code400.com/query400.php

jamie