Forum Discussion

MichaelTamoush's avatar
MichaelTamoush
Qrew Captain
5 years ago

Report Link Question

Not sure if there is a way to do this, but I am trying to get a report link to show a child that is is one of multiple related fields. To clarify:

- One project has many daily reports
- A daily report can include up to 3 projects. instead of creating a many to many relationship (which maybe is what I will need to do?) I created 3 relationships from project to daily report.
- On the daily report, you can of course now select up to 3 projects to relate do that single report.

On the projects tab, I could have 3 report links. One for each relationship. Is there a trick to have one report link, and have it show reports where the Record ID is in ANY of the 3 related fields?

------------------------------
Mike Tamoush
------------------------------
reports and charts
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    5 years ago
    Not tested today, but the option for a non exact match on a report link field always confused me.

    Here are my cheat notes.

    Report Link non exact matching means that the field on the "Parent" (left) must be contained within the field on the right "Child".

    SET NON EXACT MATCH!!!

    So you should be able to create a string in the format on the child like

    like

    List(";", totext([related parent 1]),totext([related parent 2]),totext([related parent 3]))

    Let me know if that works. Not sure if you need to have a ToText(field on the Parent for [Record ID#])






    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • MichaelTamoush's avatar
      MichaelTamoush
      Qrew Captain
      5 years ago
      Worked!

      Also, turns out you DO NOT need to to text the record ID on the parent. Worked fine matching the record ID on the parent, with a non exact match to the Related Parent String.

      ------------------------------
      Mike Tamoush
      ------------------------------
      • EugeneVRVO's avatar
        EugeneVRVO
        Qrew Member
        5 years ago
        Hi Mark

        I'm trying to do the same concept but I cant get this to work. This is the second post I have found on this exact topic but I don't get the same positive result.
        I have a list of Asset ID nos in table C. I want to have a report link in table C that uses this list of Asset ID nos to filter a report in Table A (Asset table) so that I can see this report link as an embedded table in the forms in Table C.

        If I have only one Asset ID no in the list in table C then linking the report link is easy. But I cant get the report link to work using the list.
        I have created a dummy field in table C to test your solution above

        List(";", ToText(31284),ToText(32763))


        I then used this field to link to a report link in Table A

        But then when I follow the report link I get an empty result

        Can you see any obvious reason why I cant get it to work?




        ------------------------------
        Eugene van Rheede van Oudtshoorn
        ------------------------------