PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 11/17/2015 4:21 PM by  jaherb
Add columns to report csv beyond the print report width limit
 5 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Woozy
Private
Private
Veteran Member
(3478 points)
Veteran Member
Posts:704


Send Message:

--
11/16/2015 1:53 PM

    Hi Everyone,

    I have a 4GL custom program that includes a work file with lots of fields.  I want to create a secondary report for the job based on the work file (so it shows in Print Manager), but there are more columns than will fit on the print report. I really would prefer to include only a couple of rows on the print report, but have all the columns show on the csv version of the report.

    I've tried adding additional fields to the report group $FIELDS section without including them in the $FORMAT section, but that doesn't appear to work.

    Is there a way to do this?  Any suggestions would be appreciated.

     

    Thanks!

    Kelly

    Kelly Meade
    J. R. Simplot Company
    Boise, ID
    jaherb
    Private
    Private
    Veteran Member
    (471 points)
    Veteran Member
    Posts:163


    Send Message:

    --
    11/17/2015 3:50 PM
    Kelly.... If you list the fields in your .rpt, all of the fields will be exported to a csv file when you use the option to export to csv files. We do this a lot and have some reports with over 40 fields on it.
    Woozy
    Private
    Private
    Veteran Member
    (3478 points)
    Veteran Member
    Posts:704


    Send Message:

    --
    11/17/2015 3:58 PM

    Hi Jim,

    What I'm confused about is how do I get all the fields in the .rpt if there are more than fit in the 250 characters allowed?  If I list all the fields in the $FIELD section, but only show the first 3-4 in the $FORMAT section, the compile bombs. Do I have to add all the fields as single-character entries or something?  Or is there a way to enter them as 'hidden' fields as you can in forms?

    Thanks for your help!

    Kelly

    Kelly Meade
    J. R. Simplot Company
    Boise, ID
    jaherb
    Private
    Private
    Veteran Member
    (471 points)
    Veteran Member
    Posts:163


    Send Message:

    --
    11/17/2015 4:01 PM

    Kelly...   You can use multiple lines in your report group...  see below for an example...

     

    Sorry I had to make it so small.. but this should give you the idea.

     

    $FORMAT
    %
     Employee Name                             Status             Status Date   Hire   Rehire/Ann   Term      Birth   Marital Status
     |                                       ; |                ; |           ; |    ; |          ; |       ; |     ; |            ;
    ZZZZZZZZ9 XXXXXXXXXXXXXXXXXXXXXXXXXXXXXX   XX - XX XXXXXXXXXX   ZZ/ZZ/ZZ  ZZ/ZZ/ZZ  ZZ/ZZ/ZZ  ZZ/ZZ/ZZ  ZZ/ZZ/ZZ  X - X  XXXXXXX
    H         I                                J    K  L            M         N         O         P         Q         A   B  R
              XXXXXXXXXXXXXXXXXXXXXXXXXXXXXX   Sub-Status XX - XX   ZZ/ZZ/ZZ  Hce Indicator X  Frequency 9 - X XXXXXXXXX  Sex  X - X
              S                                |        ; T    A8   U         |           ; C  |       ; D   E V          |  ; F   G
              XXXXXXXXXXXXXXXXXXXXXXXXXXXXXX   Cur Action XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX  Status XX ZZ/ZZ/ZZ
              W                                |        ; X          Y          Z           |    ; B1 B2
              XXXXXXXXXXXXXXXXXX XX XXXXXXXXXX Loa Action XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX  Status XX ZZ/ZZ/ZZ 401k Start ZZ/ZZ/ZZ
              A4                 A5 A6         |        ; A1         A2         A3          |    ; B3 B4       |        ; B5
                                               Email Addr XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX Ph XXXXXXXXXXXXXX
                                               |        ; A7                                                           |; B6
    %
    $ENDFMT

    Woozy
    Private
    Private
    Veteran Member
    (3478 points)
    Veteran Member
    Posts:704


    Send Message:

    --
    11/17/2015 4:14 PM
    AHHH!!! That never even occurred to me. Thanks Jim!
    Kelly Meade
    J. R. Simplot Company
    Boise, ID
    jaherb
    Private
    Private
    Veteran Member
    (471 points)
    Veteran Member
    Posts:163


    Send Message:

    --
    11/17/2015 4:21 PM
    Not a problem... let me know if you need another example.... that one was kinda of jumbled up....

    Jim
    You are not authorized to post a reply.