No problem. First, set up a list of your target procedures in /PROC. One way is in a macro associated with AL START. Then set up the following variable on page two using the macro below.
xx.select
DAT=YN
LEN=1
VAL=%BAR.BCH.zcus.program.name.M.select(txn.account)
Macro:
*------
@SETUP,
@LOOP.THROUGH.BAR.PAT.CHARGES,
SELECT;
SETUP
""^SELECT,
A^txn.account
--------------------------------------------------
LOOP.THROUGH.BAR.PAT.CHARGES
"C"^BAR.PAT.txn.class,
""^BAR.PAT.txn.urn,
DO{@NEXT.TXN IF{/PROC[@BAR.PAT.txn.procedure]+0=0;
"Y"^SELECT}}
NEXT.TXN
@Next(BAR.PAT.txn.urn)
Hope this helps,
Jerry Beals
Holyoke Medical Center
Holyoke, MA
>>> <slmed...@comcast.net> 4/11/2008 4:08:16 PM >>>
Happy Friday,
I am DESPERATE for help right now, ready to bang my head against a wall! I am trying to come up with a report for our financial department that will capture charges, receipts, and adjustments for accounts ONLY if they have specific procedures. If the account has at least one of the specified procedures, I would need to show the above mentioned data. I can't put it directly into a select since the report would then only pull the procedures I am selecting. I am in Magic 5.5 SR2. The report is written out of BAR.BCH, Detail Segment bar.batch.txn.items, Index File bar.batch.index, selecting off of batch date.
I am thinking I may need to use a DO Loop in a macro to run through the procedures for the account to determine if it should be selected for the report. I have been tinkering with fragments and such, but I do not have much exposure to DO Loops, which I think is my best bet. I have seen them already created and saw them work, but never created one to this point. I have searched the L Archives, Meditech KB articles, and anything else I can find, but have found no help. Not to mention that Meditech already has me on a 25-30 day wait for assistance on a different report!
If anyone can throw me some tips on this, I would be forever greatful! Even if it would mean recreating the report out of a different DPM, as long as I had some direction on pulling the qualifying accounts. I would love to put this request to bed, especially considering the pressure coming at me to get this report done ASAP!
Thanks everyone,
--
Shawn Losanowych
BluePrint Healthcare IT
slmed...@comcast.net
CONFIDENTIALITY NOTICE: This email communication and any attachments may contain confidential and privileged information for the use of the designated recipients named above. If you are not the intended recipient, you are hereby notified that you have received this communication in error and that any review, disclosure, dissemination, distribution or copying of it or its contents is prohibited. If you have received this communication in error, please reply to the sender immediately or by telephone at (413)534-2500 and destroy all copies of this communication and any attachments. For further information regarding Holyoke Medical Center's privacy policy, Please visit our Internet web site at http://www.holyokehealth.com
<<<<GWAVAsig>>>>