This is a public Forum  publicRSS

Topic

    Scott Heidenreich
    Use a relationship in BI Publisher?
    Topic posted August 14, 2018 by Scott HeidenreichApprentice 
    28 Views
    Title:
    Use a relationship in BI Publisher?
    Content:

    How do I use a relationship in BI Publisher Desktop?

    For example, if certain questions in the narrative entity are related to certain project categories and any given narrative can be used for many project categories, how do I get BI Publisher to list the project categories that are related to the narrative question?

    Here is the relationship text:

    the project categories for the narrative question (PC_for_narrativeQuestion)

    From: the narrative

    to many instances of: the project category

    Reverse Relationship: the narrative question for the project category (narrativeQuestion_for_PC)

    Desired output on the form:

    Narrative Question 1

    The following project categories apply to this question:

    PC1

    PC2

    Narrative Text offered by the user.

     

    Thanks!

    PC3

     

    Version:
    18A