Link to Report on Form

Question

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
------------------------------

MarkShnierYou · Answer

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
------------------------------

Sign up

Login to the community