Forum: AS400 REPORTS

Hi All, We have a serious problem with printing. AS400 print spool file generating a file with page number as 9999. Becuase of this printer is printing the same document repeatedly. This page number (9999) is also not decreasing. Still it shows as page as 9999. Can any one give your valuable...

I have labels (no bar codes) printed the as400 to a normal printer, I want to continue using the program in RPG, but now for printing to a zebra. This program is important because the rules impression are complex . It is possible to draw on the RLU as400 labels to be printed in the zebra? thanks...

Is there any way to convert this type of report to a pDF for emailing? I would appreciate any help! Thanks!

Hi all, We need to build PDFs via PSF but in many differents character sets for languages such as polish, greek, ... Data to print are stored into UCS2 fields in a DB file. Our system is in V5R4 and options 8 (AFP Font Collection (5648-B45) ) and 43 (Additional Fonts) for product 5722SS1 are...

Hi all, We have HP 9050 dn that apparently has the MICR font on it. If I print out the HP PCL5e Permanant Soft Fonts from the printer's menu, it lists the font. The printer itself is setup as AFP *NO and Host Transform Print *NO. In trying to create the MICR, I have been using a prtf and...

What will I ever do NOW?:crying-2:

Hi to all! is it possible to find out wich Query (WrkQry Object) use which table? Would be great! Thanks in advance Jürgen

Is there a basic way to monitor a subsystem and print PDF jobs that meet a certain criteria? Or can it be done by a USERID? Thanks for any assistance.

We need to start printing barcodes from our Iseries to a Zebra printer. Does anyone have any sample code(either internally defined printer file or externally) that I can use to print Bar codes on a Zebra printer..thanks

hi anybody knows how to select distinct records in wrkqry.also group by functions....

Hi I have uploaded a new Overlay document using AFP printer and then copied it from PC 2 as400 via FTP using command prompt of windows 2 my DEV server from here i created a savfile and FTP the same overlay (ZZZ.OVL) object to my test server and know i am trying to test the new overlay...

I am trying to email two wide reports (300 columns), in a single PDF file. I got one of the reports to completely fit into a PDF file utilizing the WSCST(*PDF) parameter on the OVRPRTF command, but I can not put two reports together in the same PDF. I download the CVT2PDF program from this site. It...

hi I'm searching a software to link AS/400 Spool file . I need the software can design the format of spool file and prefer the software can link some tables of JDE via ODBC. :confused::confused::confused:

Hello All, We're getting ready to upgrade from V5R3 to V6R1 soon and I'm curious about Web Query and I haven't found a whole lot of information out there. Does anyone out there use it much? What's your opnions of it? I haven't been able to track down a cost yet, (still waiting on phone calls to...

Hi Everyone I need some help regarding Service Program Will you please tell me abt the source type and object type for service program and how to create it by F6 key and what we will give there in source type for creating service program because if i prefer the Service program which are...

Hi everyone Is there any simulator for as/400 so that i can also work at home for just practice purpose

I have a spool file question: I'm trying to print duplex on a new xerox printer here in our main office. The printer is setup on IPDSServe and using a program from QSAMPLER that was provided by the vendor I was able to successfully print a duplex document to the printer. My problem is that...

Hello All, I want to find a solution for Reporting, Data Analysis, Dashboarding & Scorecards on one solution. Last few months I have Played with WebQuery but not much success. And heard & little Read about Cognos BI but haven’t tried it. Before move to any of those, I would like to know...

Dear All, I will take a query in AS400(WRKQRY), & after that I need to update the count in the excel sheet. It is a repetative task, please let me know how to automate it in excel. Thanks Hsp

Need some help converting Julian date (2009001) to MMDDYY using QUERY/400....Seems no one has done this :duh. Can not find a solution. Really not wanting to write a CL to do it:D

Hi All, Can any one tell me what is the default settings to print the reports in A4 size paper. Thanks.

Hello, I'm really new at this. I work with an AS/400 system and I am trying to get a spreadsheet going that has all of our account's Fax numbers and Email addresses. Basically the information in Cmnd CM50. Is there a report that I can run that will provide all of that information? And if so.....

Not sure if this is in the right place but I have a question for anyone out there. I have been trying with no avail to access our AS400 database and retrieve information such as inventory. When I ODBC into the database all I get is useless information in the tables. The company that setup the...

Hi, We are considering moving from Gauss Spyview to IBM Content Mgr On Demand. One of the first things we would need to do is to figure out how to get our documents with the indexes out of Spyview. I guess on order to do this, we would need to know what DB files contain the indexes and how they...

Hi, While I am trying to edit a report, the fields are shifted towards right. I have to add Text, which should be printed on every output, its a company FT no on DC's. I tried adding in Header and Footer, but in both cases I am facing problem, fields shifting. Also tried in Detail part but...