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