Data report from iSeries to a CSV format need page breaks and colors

50 pts.
Tags:
CSV
CSV file format
iSeries
Hi, I have to send report to our clients in CSV format using data from iSeries. In iSeries I used a text file having one field of 1000 char and used commas as field separators. Is there any way I can send a code for page break once required? Can I do some thing to color or high light the totals and headings? Please help!! Thanks Raza

Answer Wiki

Thanks. We'll let you know when a new response is added.

One more thing, all reports are automated and send via e-mail from iSeries.
*
Notes by Charlie Browne
Yes you can do this.
I went to the RPG & DB2 summit last fall and saw a presentation by Scott Klement on how to do this. This is the best education currently available for AS400 developers.
Truly an investment for you and your company.
The link for the conference is http://www.systemideveloper.com/index.html
You can get to Scott’s presentations by going to http://www.scottklement.com/presentations/#RPGHSSF

Discuss This Question: 7  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • carlosdl
    "Can I do some thing to color or high light the totals and headings?" The CSV format is plain text. To add colors you would have to generate some other type of file (xls, for example).
    68,430 pointsBadges:
    report
  • Raza110
    Thanks Carlos, It means, from the CL I have to use .xls instead of .CSV? If correct, then what codes should I use to send a page break and for colors? Sorry I am doing this first time so my questions may confuse you. thanks - Raza
    50 pointsBadges:
    report
  • Raza110
    Thanks for the reply and links. I started reading and will let you know the results soon. Thanks again - Raza
    50 pointsBadges:
    report
  • WoodEngineer
    It will be quite a challenge to generate a valid .XLS file from your RPG program. Probably more work than it is worth. While you could change the extension from CSV to XLS the file would only work properly in Excel if that is the only change. Would your users be happy with a PDF copy of the report?
    6,305 pointsBadges:
    report
  • WoodEngineer
    Sorry . . . got interrupted and hit enter too soon. That should be, " While you could change the extension from CSV to XLS the file would not work properly in Excel if that is the only change. "
    6,305 pointsBadges:
    report
  • Raza110
    Correct WoodEngineer, PDF will be lot easier for reports. That is what I am trying to negotiate with them right now. Thanks again
    50 pointsBadges:
    report
  • PGMBOB
    Scott's presentation does do colors and bolding. The result is a HTML representation of an EXCEL spreadsheet. Client access file transfer can produce a spreadsheets but the editing you need needs to be added later. There is a product that creates a spreadsheet from spool printer file. You provide a data "map" where conditional formats and colors are applied. Spoolflex
    970 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following