Re: Pictures in a report?

Better solution than all of that. Don't use the AS/400 as a report writer.
If you have SQL Server, just create a report in SQL Server Report Writer
pulling the data from the AS/400 (I use stored procedures written in RPG to
pull the data).

RPG is such a waste to write reports. I especially like Sql Server Report
Writer for writing reports because almost all shops have it and the result
is web document that you can link to and you get a nice look GUI report with
minimal effort.

If you don't have the report writer it worth it to just buy a standard
edition of SQL Server (A few hundred dollars) just for the report writer.

The only reports I write on the AS/400 are like auditing or something and I
just write records to a file and use the STRQM to write the report.

On Tue, Aug 3, 2010 at 5:39 PM, Booth Martin<booth@xxxxxxxxxxxx> wrote:

Would a Third Way be of interest?

For all of the energy you have in it already you could have published
the report to an intranet site, where they could view it at their
leisure. Then, if they happened to want it printed out, they could
print from the browser. That way, they get color too.

I have also used the same solution, except writing the report.html to an
ifs directory instead of a web server, and them mapping that directory
to the user's PC.

Just a thought. (By the way, when I used those solution it resolved a
whole lot of intramural political problems too. It was a big win all
the way around.)



On 8/3/2010 7:01 PM, James H. H. Lampert wrote:

I've just gone partway through the AFP Utilities Tutorial on our V6 box.

I now have an overlay, and a spool file of that overlay, but no apparent
way to see what it looks like.

Tried sending it to myself as a PDF, using MMAIL. Ended up with an error
message out of MMAIL, and a malformed PDF that was undisplayable.

I also looked at the customer's box. They don't have a QAFP library.

Definitely weird.

--
JHHL

--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.