All messages should be posted in plain text. HTML will be converted to
attachments. The meditech-l web site is MTUsers.com
======================================
Marc,
Your mixing up several techniques, and you loop is not quite right.
1) If you build an MV array on your picture like this
D xx.mv.field
D xx.mv.field
with an MV=D attribute on the first of these two detail lines.
You need to build a structure like this /MV["D",SORTVAL,FIELD#] = data
to print on field
So your loop thru /R.FRAG.VAL could be done like this:
DO{+/R.FRAG.VAL[LINE]^LINE /R.FRAG.VAL[LINE]USER^/MV["D",LINE,FIELD]
where FIELD = the field number of xx.mv.field in the field list after
translation.
If you want to wrap and ECB / ECE do loop around a line of your report
to print the /R.FRAG.VAL data,
Then set up report like this
D xx.just.one.field
DAT=FREE
LEN=whatever
VAL=/R.FRAG.VAL[LINE,"USER"]
and wrap a do loop around the line
D ECB=DO{+/R.FRAG.VAL[LINE]^LINE .,
D ECE=.},
Not sure why you stuck the string "USER" on the end of your /R.FRAG.VAL
structure. If /R.FRAG.VAL is returning you several lists of values, it
is easier to set
up the structure like this:
/R.FRAG.VAL["USER",LINE]
/R.FRAG.VAL["SOME OTHER THING",LINE]
Joe Cocuzzo
Vice President
NPR Services
Iatric Systems, Inc.
Phone/Fax: (978) 805-4115
Email: [EMAIL PROTECTED]
Web: www.iatric.com
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Benoy, Marc
Sent: Tuesday, May 23, 2006 11:35 AM
To: [email protected]
Subject: [MEDITECH-L] NPR - Multiple Values in a Fragment Report
All messages should be posted in plain text. HTML will be converted to
attachments. The meditech-l web site is MTUsers.com
======================================
Hello all,
I am trying to pull data from a fragment into a main report as in: one
to many.
I am able to pull in the data if I hard code the sequence but I am not
able to create a loop through the MV.
I created in the main report two computed fields with identical
attributes:
xx.users.1 and xx.users.2:
VAL=/R.FRAG.VAL[LINE,"USER"]
These queries are vertically aligned on two detail lines on the picture
and on the first field (xx.users.1) I have this line attribute:
ECB=DO{+/R.FRAG.VAL[LINE[MBenoy] ,"USER"]^LINE .,
ECE=.},
[EMAIL PROTECTED]/MENU,%Z.rw.fragment("MIS.USER.zcus.menu.users.frag.R"),""
LC=1^LINE
On the second field I have no line attribute.
I do not have other detail lines, i.e. the first computed field is on
the first detail line.
The fragment report's detail line attribute is
[EMAIL PROTECTED]/R.FRAG.VAL[CNT+1^CNT,"USER"],""
I used Meditech's sample:
http://www.meditech.com/MIXMAGTactical/NPRReportWriter/0103NprRw.htm
How do I loop through the values I am receiving from the fragment?
Thanks,
Marc
Marc Benoy RN, MS, MBA
Clinical IT Project Leader RN
301.552.8876 (Phone)
301.552.8181 (Fax)
[EMAIL PROTECTED]
Doctors Community Hospital
8118 Good Luck Road
Lanham, MD 20706
Magic 5.4
CONFIDENTIALITY STATEMENT: This communication, including attachments,
is for the exclusive use of addressee and may contain proprietary,
confidential or privileged information. If you are not the intended
recipient, you are hereby notified that any disclosure, use, copying,
dissemination, distribution or taking of any action in reliance on the
content of this information is strictly prohibited. If you are not the
intended recipient, please notify the sender immediately by return email
and delete this communication and destroy all copies. Thank you.
_______________________________________________
meditech-l mailing list
[email protected]
http://mtusers.com/mailman/listinfo/meditech-l
_______________________________________________
meditech-l mailing list
[email protected]
http://mtusers.com/mailman/listinfo/meditech-l
