Creating Reports in JDE

I have been assigned the administration of our JDE system as our previous analyst left the company suddenly. I have no prior experience so needless to say its been a bit tough to follow through with user's requests.

I have been asked to create a report of every employee that received a paycheck from jan 08 to present. The fields that are needed are in the Address Book, just first name, middle name, last name.

How would I go about doing this? Create a world writer?

THanks in advance,
elans

Hello Elans
You don't give any idea of your experience level or if you have other tools available.
I'd use query, however WW is just as good if you are comfortable with it.

regards
Mike

WWriter is the fastest way. You must pick up the right fields. Perhaps you must need to join with another file to know about=C2=A0 the paycheck.=0Agoo d luck=0Aluis=0Aa73.cum15-argentina=0A=0A=0A

Elans,

Yes a World Writer would be a quick and easy report to create. You do
not need the Address Book file (World Writer will bring in the employee
name fields). I think you need to use the file F06146. Look for YNCTRY
=3D 20, YNDTEY =3D 08, YNPDBA =3D 1. This should give you employees that have
received a paycheck in this century and year.
You can also look on menu: G0715, there are some reports there.

Jim Rubino

Re: RE: Creating Reports in JDE

Alright so this helped. I found a previous report and modified it. Now if I run it and the job runs successfully, where do I check the report...or...where does the report output to? It doesn't sepcify a printer.

RE: RE: Creating Reports in JDE

It would go to your default printer. From a JDE menu type 43 and press
enter. You should see the report in the Work with All Spooled Files.

Jim

RE: RE: Creating Reports in JDE

Look in the JDE user profile for your JDE default output queue.

John Dickey
Financial Systems Administrator
White-Rodgers, division of Emerson Electric
8100 West Florissant Avenue
P.O. Box 36922
St. Louis, MO 63136-9022
314-553-3067
[email protected]

Re: RE: Creating Reports in JDE

L also have a report that needs some fields added and some removed. Would I do that by editing the file (R550618) which is the output or the program? (p550618)? It is an RPG program.

RE: RE: Creating Reports in JDE

You will need to modify both the printer file and the program. Remove
fields you do not want and add field you do want on the printer file and
then change the RPG program to remove the fields from program and then
add calcs to load data to your new fields on the printer file.

Jim

Re: RE: RE: Creating Reports in JDE

So just to be solid...

The R file is the printer file
and
The P file is the program file

What's the best way to look at the code? Once I get in I can modify but I can't remember how to view the code.

Thanks again for all your help.

RE: RE: RE: Creating Reports in JDE

Yes the R's and S's are printer files and P's, X's are programs. J's
are CL programs. D's are display file or videos as JDE calls them.

Using SVR, place a 1 next to them to browse the source. Or in SVR copy
the source to a development library and then use option 10 on the
printer file to see what the layout looks like.
You should always make your changes to any JDE programs, files, etc. in
a development environment first and test what you changed before letting
a user look at it for their approval. Then once they approve you can
then move over to the production environment.

Jim

Re: RE: RE: RE: Creating Reports in JDE

Ok so here's what I've got.

A few fields need to be deleted. The Source Code for 'P' is laid out in a manner that I have never seen before. The subroutines are labeled though, so that makes it a bit easier.

In the 'R' source code, also labeled the Report Design Aid, I've go the text headings and the "RR" feilds that I assume correspond with the 'P' source code. Correct me if I am wrong but do I need to add the RR statements (e.g. RRSSN for social security number) to the program and then add the text statements (VTX001 etc.) to the Report Design, and add the RRSSN to the report design?

I'm not too familiar with RPG but making changes is ok by me. I also created a dev copy as you suggested.

Thanks again.

RE: RE: RE: RE: Creating Reports in JDE

Well I have to first say that if the source code for the P type is not
in a manner that you have seen before then you may have been use to old
RPG type coding. The way JDE does it is what I consider more
streamlined. Their subr are pretty much the same throughout all of JDE
programs (they maybe a very few exceptions). As you modify the code be
sure to maintain this structure, it will be easier for other JDE
programmers to follow.

You do not have to add the fields into the RPG program first. Typically
I make all of the changes in the Printer File first and then into the
RPG program. I then compile the printer file and if successful on that
compile, I then submit the RPG to compile and if successful then I test
it all.

I would see if your company will pay to send you to Oracle for a
technical class. It would be a big benefit. What version and level are
you on with JDE (A7.3 C10, 14, etc?) We are on A9.1.
Jim

Re: RE: RE: RE: RE: Creating Reports in JDE

I will definitely suggest some classes. Although I don't believe I'll be doing this for long. My experience with JDe and AS400 started about, oh, one month ago. We are on 7.3 cum 10, about to move to Enterprise One. The current OS is OS400 5.1. A little behind in the times...

I'll try out the changes and let you know ho it goes.

THanks again for all your help!!

Re: RE: RE: Creating Reports in JDE

You need to use the SVR or the WRKMBRPDM command

you probably want just make no visible the fields you do not want to be displayed instead of delete them (its easier just set them as no display on the Rfile)

to add new ones on the RDA you could put them with an * the press enter and add the name of the data dictionary item you whant to add to the report

as well you could edit the existing ones putting the * on the begining of the field

and you could switch to other fields with PG up and PG dwn

Re: RE: RE: Creating Reports in JDE

Ok so I ran into a bit of a hangup. I'm not sure exactly where I need to add some of the new fields.

If I upload the sources can anyone help me out? Thanks in advance.

Re: RE: RE: Creating Reports in JDE

Thanks for the reply. If I upload some source code could you help me out with possibly explaining what was done? I know that is a big task but it would be much appreciated!

Thanks for all your help!

Re: RE: RE: Creating Reports in JDE

yeh will try [email protected]

Re: RE: RE: Creating Reports in JDE

I'll post the source in the thread so anyone can take a stab at it.

Thanks again!!!!

Re: RE: RE: Creating Reports in JDE

Was anyone able to take a stab at the code? I attached it in the previous post.

Thanks!