Re: [Hardhats-members] FileMan in Cache
Thanks, Greg. I appreciate you taking the time to explain this. - Original Message - From: Greg Kreis To: hardhats-members@lists.sourceforge.net Sent: Monday, January 31, 2005 12:21 AM Subject: Re: [Hardhats-members] FileMan in Cache The effect you are seeing is because you are printing multiples. The main record's field doesn't repeat so you understand that the multiple fields that print on each line are part of that record. If it repeated, you wouldn't be sure if you had several records, with the same value, and one multiple entry per record or one record with several records in the multiple. Does that make sense?Bob Beckley wrote: Chris, you're right about the validity. I just made up the example on-the-fly. The real problem is that under the Cache/VMS environment, my FileMan report automatically suppresses consecutive duplicate values, which is very weird, since there is a FileMan print qualifier (;N) used to suppress them. I want to "un-suppress" them somehow. Please see my reply to Greg. Thanks. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Chris Richardson Sent: Sunday, January 30, 2005 7:26 PM To: hardhats-members@lists.sourceforge.net Subject: Re: [Hardhats-members] FileMan in Cache Nancy; The global listed does not look like a valid Fileman Global structure, (but it is a fine MUMPS global just the same). If you are trying to access this with fileman, it may not be evaluating it the way you think. I'm kind of surprised that the global list utility does not yield the difference in the subsequent nodes. - Original Message - From: "Nancy E. Anthracite" [EMAIL PROTECTED] To: hardhats-members@lists.sourceforge.net Sent: Sunday, January 30, 2005 12:43 PM Subject: Re: [Hardhats-members] FileMan in Cache Bob Witkop from Intersystems hangs his hat here at times, so he will see this. On Sunday 30 January 2005 02:25 pm, 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 --- 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)
[Hardhats-members] FileMan in Cache
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
Re: [Hardhats-members] FileMan in Cache
Bob Witkop from Intersystems hangs his hat here at times, so he will see this. On Sunday 30 January 2005 02:25 pm, 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 -- Nancy Anthracite --- 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
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
Re: [Hardhats-members] FileMan in Cache
Nancy; The global listed does not look like a valid Fileman Global structure, (but it is a fine MUMPS global just the same). If you are trying to access this with fileman, it may not be evaluating it the way you think. I'm kind of surprised that the global list utility does not yield the difference in the subsequent nodes. - Original Message - From: Nancy E. Anthracite [EMAIL PROTECTED] To: hardhats-members@lists.sourceforge.net Sent: Sunday, January 30, 2005 12:43 PM Subject: Re: [Hardhats-members] FileMan in Cache Bob Witkop from Intersystems hangs his hat here at times, so he will see this. On Sunday 30 January 2005 02:25 pm, 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
RE: [Hardhats-members] FileMan in Cache
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 TA Check Replace TA Check STORE PRINT LOGIC IN TEMPLATE: ZZBBPRINT1 Are you adding 'ZZBBPRINT1' as a new PRINT TEMPLATE? No// Y (Yes) printout: TA Check JAN 29,2005 21:41PAGE 1 PAY PERIOD EMPLOYEE APP. SUPERVISORTIMEKEEPER POSTING 04-06 ,OSCAR L JR These are null matches, which we want. xxx,ALVIN Cxx,SANDRA Mxx,SANDRA M xx,SANDRA M xx,SANDRA M xx,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] 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
Chris, you're right about the validity. I just made up the example on-the-fly. The real problem is that under the Cache/VMS environment, my FileMan report automatically suppresses consecutive duplicate values, which is very weird, since there is a FileMan print qualifier (;N) used to suppress them. I want to un-suppress them somehow. Please see my reply to Greg. Thanks. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Chris Richardson Sent: Sunday, January 30, 2005 7:26 PM To: hardhats-members@lists.sourceforge.net Subject: Re: [Hardhats-members] FileMan in Cache Nancy; The global listed does not look like a valid Fileman Global structure, (but it is a fine MUMPS global just the same). If you are trying to access this with fileman, it may not be evaluating it the way you think. I'm kind of surprised that the global list utility does not yield the difference in the subsequent nodes. - Original Message - From: Nancy E. Anthracite [EMAIL PROTECTED] To: hardhats-members@lists.sourceforge.net Sent: Sunday, January 30, 2005 12:43 PM Subject: Re: [Hardhats-members] FileMan in Cache Bob Witkop from Intersystems hangs his hat here at times, so he will see this. On Sunday 30 January 2005 02:25 pm, 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 --- 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
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 TA Check Replace TA Check STORE PRINT LOGIC IN TEMPLATE: ZZBBPRINT1 Are you adding 'ZZBBPRINT1' as a new PRINT TEMPLATE? No// Y (Yes) printout: TA Check JAN 29,2005 21:41 PAGE 1 PAY PERIOD EMPLOYEE APP. SUPERVISOR TIMEKEEPER POSTING 04-06 ,OSCAR L JR These are null matches, which we want. xxx,ALVIN C xx,SANDRA M xx,SANDRA M xx,SANDRA M xx,SANDRA M xx,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: Intell
RE: [Hardhats-members] FileMan in Cache
It is not undocumented (you can always associate a label with a field) and it has nothing to do with Cache. Printing in Fileman is unrelated to the global lister. --- Bob Beckley [EMAIL PROTECTED] wrote: Thank you, Marianne. That did the trick. Is this an undocumented feature of FileMan? I'm looking for it in the manuals, but so far no luck. I'll have to make a special note of it in the margin. Thanks again. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Marianne Susaanti Follingstad Sent: Sunday, January 30, 2005 8:29 PM To: hardhats-members@lists.sourceforge.net Subject: Re: [Hardhats-members] FileMan in Cache 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 TA Check Replace TA Check STORE PRINT LOGIC IN TEMPLATE: ZZBBPRINT1 Are you adding 'ZZBBPRINT1' as a new PRINT TEMPLATE? No// Y (Yes) printout: TA Check JAN 29,2005 21:41 PAGE 1 PAY PERIOD EMPLOYEE APP. SUPERVISOR TIMEKEEPER POSTING 04-06 ,OSCAR L JR These are null matches, which we want. xxx,ALVIN Cxx,SANDRA M xx,SANDRA M xx,SANDRA M xx,SANDRA M xx,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] 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
Re: [Hardhats-members] FileMan in Cache
The effect you are seeing is because you are printing multiples. The main record's field doesn't repeat so you understand that the multiple fields that print on each line are part of that record. If it repeated, you wouldn't be sure if you had several records, with the same value, and one multiple entry per record or one record with several records in the multiple. Does that make sense? Bob Beckley wrote: Chris, you're right about the validity. I just made up the example on-the-fly. The real problem is that under the Cache/VMS environment, my FileMan report automatically suppresses consecutive duplicate values, which is very weird, since there is a FileMan print qualifier (;N) used to suppress them. I want to "un-suppress" them somehow. Please see my reply to Greg. Thanks. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Chris Richardson Sent: Sunday, January 30, 2005 7:26 PM To: hardhats-members@lists.sourceforge.net Subject: Re: [Hardhats-members] FileMan in Cache Nancy; The global listed does not look like a valid Fileman Global structure, (but it is a fine MUMPS global just the same). If you are trying to access this with fileman, it may not be evaluating it the way you think. I'm kind of surprised that the global list utility does not yield the difference in the subsequent nodes. - Original Message - From: "Nancy E. Anthracite" [EMAIL PROTECTED] To: hardhats-members@lists.sourceforge.net Sent: Sunday, January 30, 2005 12:43 PM Subject: Re: [Hardhats-members] FileMan in Cache Bob Witkop from Intersystems hangs his hat here at times, so he will see this. On Sunday 30 January 2005 02:25 pm, 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 --- 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)