Re-generate report in AS/400

How do I re-generate a report in AS/400? What are the steps? Please advise.

kekuchi20 pointsBadges:

How to add separator sheet in AS/400 report printouts

Hi, I have a question regarding the separator sheet. We used to print AS/400 reports from an RICOH printer, and recently we have migrated to a Xerox D110 printer. The old printer used to print a separator sheet which contained the job name, user name, job number, date and time. we found the device...

SreeArun15 pointsBadges:

iSeries Report printing to network printer – font too small

We have an AS/400 print file which is defined with: 10 CPI, 6 Lines per Inch, Width of 132, Length 66, Font Identifier is *CPI. We were using an AS400 print emulation session to print the report but want to get rid of this and use a device/outq on the as400. The report prints to a networked HP4050...

Lehanb30 pointsBadges:

Extract start date and end date from a file field

I have a requirement like this. I need to generate a report which has 2 fields start date and maturity date. I have FileA which has a date field and has some values say 12/31/2012, 01/05/2013, 10/01/2013,25/01/2013 and so on. I need to generate a report which has a field start date and maturity...

RamvishakRamesh2,505 pointsBadges:

Report size (spooled file size)

How do I determine a report size from a spool file in CL(using a CL command)? Thanks!

pwopen12245 pointsBadges:

Create AS/400 report that shows what changes were made by a user

We have an ID SYSITO1, and we want to create a report to show what changes were made by that user. How can I do that?

chuckalugk25 pointsBadges:

Disappearing reports

I have a client that claims that his reports disappear over night. He runs his reports converts them to PDF and then the next morning when I check them they are in a FIN status. He claims that they are not being printed off. I can find no history of anything being done to them. I am totally stumped

jmurfitt45 pointsBadges:

AS/400 transfer to iSeries

How can I transfer a report from AS/400 to iSeries?

Jan061925 pointsBadges:

AS/400 Trace Report

Hi, I ran the command TRCCNN in AS/400 to trace the connection between our AS400 and Tandem. I was able to generate a report but I don't know how to read if there's a lost connection or unnecessary event with the network. Can you help me what are the key or code when searching at the tracing report...

iSeries40060 pointsBadges:

Compare 2 reports

How can I compare 2 spool files? I have tried QShell command CATSPLF, and it showed the report interactively. But am not able to proceed further. Please share your thoughts on this

RamvishakRamesh2,505 pointsBadges:

How can i search spool files fast?

my user have so many spool files that are not been deleted. i was wondering if there is a way to search for a specific file or a different way for me to search? i only use the page up and down to see everything.

joverparas380 pointsBadges:

How to call a report from another report in JDE?

Hi All, Is it possible to call a AS400 report(RLU) from JD Worldsoft report(RDA)?    

VJayashree185 pointsBadges:

AS400 report issue

Hi, RPG36 programs which generates reports wherein I can some blank lines printed , but the program as such does not print the blank line separately through the program. Am not getting any clue why this blank line is printed , verified the Printer where other similar reports are printed without any...

Barathr1145 pointsBadges:

Email AS/400 report

User is executing a world writer, and I need to automaticlly email the report to someone else. How can this be archived ?

Patelk5 pointsBadges:

AS/400 query

Is there a way to create a query that gives you a report with an average price, but does not include the zero prices in the count of the average? Those "zero price records" must be included in the report for other info.  

Hf30 pointsBadges:

How can I list users whose status is disabled on AS/400 ?

Hello everybody ! I have to make a cl program in order to list users whose status is disabled. I wanted to know if someone had  tips for me. Thanks

Kilizan15 pointsBadges:

AS/400 Scratched System Report

How may I get a report that the AS/400 system was scratched for the Auditors.

Leftnyc4940 pointsBadges:

Using Query on 4 different files

Hi i have four different files each containing a Customer name ,number and sales amounts ,each file is for a different quarter of the year ,i would like to join the four files so that i can produce a report which lists across the page by quarter the sales for each customer,however not all the...

ZETA5 pointsBadges:

Trying to get select all in a dropdown from the AS400 to SSRS(Urgent)

I am have troble trying to get a select all fuction using AS/400 data on Mircosoft reporting services. Normally I know you just go into the parameter and click multivalued but that is not working. I have create a Stored procedure to use the calender feature for date I don't know if there is a way...

AMcAuley3105 pointsBadges:

getting source from object on AS400

I have a customer who has no source for a program but has a object and is at 4.5 of the os. Is there a tool or way that I can get the source back on the cle or rpg program?

deputy825 pointsBadges: