PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 11/03/2016 10:41 AM by  Joan Herzfeldt
POAGMTPART
 1 Replies
Sort:
You are not authorized to post a reply.
Author Messages
NatalieD
Analyst, Report Writer
ProMedica
Advanced Member
(81 points)
Advanced Member
Posts:41


Send Message:

--
11/03/2016 9:36 AM
    Hello - I'm trying to build a crystal report that will show the contracted price for an item based on the IC12 location company. We have instances where we have more than one vendor agreement based on one for a specific participant company. When I pull the contract tables in (POVAGRMTHD, POVAGRMTLN and POAGMTPART) they report duplicates the item for every possible contract. I'm trying to narrow down to have it only show the vendor agreement based on the location company using the agreement participant and priorities. Does anyone had this issue with duplicate lines in a vendor agreement report?
    Joan Herzfeldt
    System Analyst
    Genesis Health System
    Veteran Member
    (134 points)
    Veteran Member
    Posts:50


    Send Message:

    --
    11/03/2016 10:41 AM
    Hi Natalie - I don't know about vendor agreement reports specifically, but usually when I get multiple records it has to do with the linking of the tables. How are you linking the tables? I reviewed the table definitions and I would link the header table to the line table and the line table to the Agmt part table. I'm guessing you are using the header table to link to agmt part table, but I didn't test my theory. I've attached a document that shows a little more detail then I wrote. Hope this helps.
    Attachments
    You are not authorized to post a reply.