Re: [Hardhats-members] FileMan in Cache

Marianne Susaanti Follingstad Sun, 30 Jan 2005 17:37:14 -0800

FM only prints the higher level entry once when printing subfile info. If you want the higher level info printed on each line, you need to specify it to print within the multiple. So in your case, you would hold off on specifying the employee, supervisor info until within the day subfile. For your example (FM might ask some questions which I'm not showing, just to be sure it knows what you want):

FIRST PRINT FIELD: PAY PERIOD
THEN PRINT FIELD: EMPLOYEE
THEN PRINT EMPLOYEE SUB-FIELD: DAY #
   THEN PRINT DAY # SUB-FIELD: EMPLOYEE;C12;L18
   THEN PRINT DAY # SUB-FIELD: APP. SUPERVISOR;C35;L18
   THEN PRINT DAY # SUB-FIELD: TIMEKEEPER POSTING;C58;L18
    THEN PRINT DAY # SUB-FIELD:
THEN PRINT EMPLOYEE SUB-FIELD:
THEN PRINT FIELD:

Bob Beckley wrote:

Greg, we're running Cache/VMS and have no choice (as far as I can figure)
regarding consecutive duplicate value suppression. Our global listings
automatically (it seems) employ it, and now I've noticed it in a print menu
option I just created. I just want to "un-suppress" them. Here's an
example:
print template:
FIRST PRINT FIELD: PAY PERIOD
THEN PRINT FIELD: EMPLOYEE
THEN PRINT EMPLOYEE SUB-FIELD: EMPLOYEE;C12;L18
THEN PRINT EMPLOYEE SUB-FIELD: APP. SUPERVISOR;C35;L18
THEN PRINT EMPLOYEE SUB-FIELD: DAY #
    THEN PRINT DAY # SUB-FIELD: TIMEKEEPER POSTING;C58;L18
    THEN PRINT DAY # SUB-FIELD:
THEN PRINT EMPLOYEE SUB-FIELD:
THEN PRINT FIELD:
Heading: TIME & ATTENDANCE RECORDS LIST Replace ... With T&A Check
Replace
   T&A Check
STORE PRINT LOGIC IN TEMPLATE: ZZBBPRINT1
Are you adding 'ZZBBPRINT1' as a new PRINT TEMPLATE? No// Y (Yes)
printout:
T&A Check                                      JAN 29,2005 21:41    PAGE 1
PAY
PERIOD     EMPLOYEE               APP. SUPERVISOR        TIMEKEEPER POSTING
----------------------------------------------------------------------------
----
04-06      xxxx,OSCAR L JR
                                  These are null matches, which we want.
           xxxxxxx,ALVIN C        xxxxxx,SANDRA M        xxxxxx,SANDRA M
                                                         xxxxxx,SANDRA M
                                                         xxxxxx,SANDRA M
                                                         xxxxxx,SANDRA M
No suppression employed via the print template. Where's it coming from,
then? Weird, huh? Thanks for your time.
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Greg
Kreis
Sent: Sunday, January 30, 2005 7:27 PM
To: hardhats-members@lists.sourceforge.net
Subject: Re: [Hardhats-members] FileMan in Cache
The Cache display of globals that suppresses the subscripts is just a
formatting choice. It is just how they chose to present them. It
doesn't influence how globals work or how FM works.
FM can be made to suppress repeating values in a column through the use
of a suffix of ";N" for a field specification in the print template.
Look at the print template of the report that you showed here. The
fields normally repeat. You have to work to suppress them.
Bob Beckley wrote:
>If you look at a global listing in the Cache/VMS environment, you'll notice
>that the global array to the left of the "=" sign is listed only once.
>Subsequent entries with the same global array are blank to the left of the
>"=" sign, with "new" data to the right, like so:
>
>^ABC(1,"ID")=123^124
>            =321^421
>            =534^543
>            ...
>
>This apparently carries over into FileMan reports, like so:
>
>Jones, John     12344     Yes     Vet
>                43214     No      Vet
>
>Both entries are for John Jones, but his name is listed only once.
>
>Does anyone know how to make, in this example, "John Jones" appear on each
>and every line instead of a blank? I don't know of any print qualifiers
>that cover this. (Perhaps I should take it up with Intersystems?) Thanks
>in advance.
>
>
>
>
>-------------------------------------------------------
>This SF.Net email is sponsored by: IntelliVIEW -- Interactive Reporting
>Tool for open source databases. Create drag-&-drop reports. Save time
>by over 75%! Publish reports on the web. Export to DOC, XLS, RTF, etc.
>Download a FREE copy at http://www.intelliview.com/go/osdn_nl
>_______________________________________________
>Hardhats-members mailing list
>Hardhats-members@lists.sourceforge.net
>https://lists.sourceforge.net/lists/listinfo/hardhats-members
>
>
>
--
Greg Kreis      http://www.PioneerDataSys.com
"You are today where your thoughts have brought you, you will
   be tomorrow where your thoughts take you." (James Lane Allen)
-------------------------------------------------------
This SF.Net email is sponsored by: IntelliVIEW -- Interactive Reporting
Tool for open source databases. Create drag-&-drop reports. Save time
by over 75%! Publish reports on the web. Export to DOC, XLS, RTF, etc.
Download a FREE copy at http://www.intelliview.com/go/osdn_nl
_______________________________________________
Hardhats-members mailing list
Hardhats-members@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/hardhats-members
-------------------------------------------------------
This SF.Net email is sponsored by: IntelliVIEW -- Interactive Reporting
Tool for open source databases. Create drag-&-drop reports. Save time
by over 75%! Publish reports on the web. Export to DOC, XLS, RTF, etc.
Download a FREE copy at http://www.intelliview.com/go/osdn_nl
_______________________________________________
Hardhats-members mailing list
Hardhats-members@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/hardhats-members

Re: [Hardhats-members] FileMan in Cache

Reply via email to