× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.




Another thing to check is maybe you have already purchased a solution. Do you have a copy of Infoprint Server by IBM, 5722IP1?

I am pretty sure we do not, but how would I check?  We are on V5R1.
Historically we have loaded from OS/400 the same stuff that we had from earlier releases, because from time to time there has been a disk space crunch. For that reason we do not have a lot of the standard IBM help loaded.

Thanks for the great suggestions

I am already doing this on a bunch of reports, mainly query/400.
In some cases not going to print but to data file, such as most recent shipping history, aimed at particular customers. There was the Green Bar friendly version, then I got output that was Xcel-friendly, or whatever the end goal format was to be. This is working fine for simple lists that fit sideways in under 75 print positions.

However, I do have some Green Bar friendly reports in which the end recipients extremely like the original format, and do not want a dumbed down version that moves context to Excel-friendly columns, so I was looking into alternatives to how I had been trying to deliver the more complex reports or associated data.

There is one particular Green Bar report (we call it our production schedule) which eats 198 print positions sideways and has different formatted lines on each item, in which the number of lines is unlimited but for most items is 5-15. It currently has a number of needs for improved distribution, in which I still need to check whether all recipients need all the specialized line formats.

Some of the links suggested by other people in this thread ... I am revisiting those sites for this current interest. I had seen some of them before when looking into other co-worker special interests such as digitally signing delivery of purchase orders.

I am familiar with XML from the Blogsphere & the Evansville Indiana AS/400 user group plans to do a presentation on XML/400 3rd Wed in February.

Since you are already modifying the programs to get the desired output,
why not have a two pass system?  The first pass writes the data to an
output file.  The second pass can download, or print, the output file.

Rob Berendt
--
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





Al Mac <macwheel99@xxxxxxxxxxx>
Subject
AS/400 print to PC for almost free

I have altered AS/400 reports to make them "Excel friendly" by removing
sub-totals and control breaks, and making them simple lists, where the
Excel user reinstates the breaks.

I have shown several co-workers how to get such reports into Excel or
standard text with proportional print, but I have not been impressed with
our overall results, that I have seen.  They work, but look horrendously
amateurish, not appropriate to send outside the company.

I also have reports in which it is a big deal for me to do that because
the
reports in question involve a bunch of lines on each item, where the
number
of lines is unpredictable and different format, using 198 print positions
on green bar.  I can put that report in e-mail to someone who has PC but
no
AS/400 and the result for them is unreadable.

What I want is to get it into a format that is user-friendly for a PC user

with zero AS/400 know-how, not connected to the 400, (and also ideally not

need much PC know-how like what it is you do to printer setup to get
landscape print on selected reports then put it back the way it was), to
search report for some customer name or item # or whatever, zoom in on
that
section of the report so it is readable, reprint just a few pages of the
total report, and have it legible on their PC, without having to mess with

Printer Setup to get landscape and other alterations just for that report.

I plan to look into Adobe Acrobat PDF onto my home PC to create the AS/400

reports, or perhaps get some equivalent results shareware onto my home
PC.  My home PC is Windows 98 which now talks to the work 400 via VPN over

what is laughingly called "high speed" Internet connection.

The recipients of this would include our sales reps who deal with
customers, and are more often away from the office than in the city of our

company, co-workers who need to send AS/400 to a variety of customers,
vendors, and other trading partners.  If I perfect a method after spending

a few hundred bucks of my own money on adding stuff to my home PC, I think

some (very few) co-workers might want to follow suit if I swear the hassle

factor has been dramatically reduced, and the nature of the product
involved is such that they can have like a 30+ day free trial to see if I
am correct about the workability of the solution..

My management is utterly opposed to spending any money to get anything we
not already have on our AS/400 model 170 V5R1, but at same time we want to

maximize value from what we have.  We own the AS/400 outright, and dropped

software support years ago.  We do have tech support contracts but they
are
100% if we not call the tech support place, we do not pay a dime, not even

an annual fee.

At present, I am willing to spend a small amount of $ to install something

on my home PC, if it will not further degrade my home PC security, which
now
  uses a D-Link Router, various Norton products, a couple anti-spyware,
and
I still have security problems   At one time I was willing to spend a
small
amount of my $ to buy shareware to install on company computer, but at the

moment I am not so inclined.  By small amount of $ I mean around $50-200
bucks budget.

-
Al Macintyre  http://www.ryze.com/go/Al9Mac
BPCS/400 Computer Janitor ... see
http://radio.weblogs.com/0107846/stories/2002/11/08/bpcsDocSources.html
--
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.


--
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.

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.