Forum Discussion

HowardFu's avatar
HowardFu
Qrew Cadet
5 years ago

Link to Report on Form

I have an report of a child table that is embedded in the parent record form. The report can have a lot of records and it already has a lot of columns so it's difficult to look at the information. Is there a way to add a link that will display the report in it's own window? 

In the form settings, "Display just a link to the related items" will only show the default report. How do I show a different report that I've created?

------------------------------
Howard Fu
------------------------------
Forms
reports and charts

1 Reply

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew Champion
    5 years ago
    You can make your perfect target report with an <ask the user> for related parent.  Run the report, answer the question and observe the URL

    Then make a URL formula button to mimic the URL

    URLRoot() & "db/" & [_DBID_CHILD_TABLE] & "?a=q&qid=99&nv=1&v0=" & [Record ID#]

    replace 99 with the qid of the report.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------