Button to Open Report from Other Table.

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • In Progress
I have been looking thru the postings, but cant seem to get anything to work. I have two tables. In Table 1 I would like to create a button that opens a report for table 2 in a popup window. Can someone show me how to code that?
Photo of Todd Griffith

Todd Griffith

  • 220 Points 100 badge 2x thumb

Posted 2 years ago

  • 0
  • 1
just run the report and copy the URL onto your clipboard.

Then make a URL formula field and set it to open in a new Window (there is a checkbox in field properties for that)

put it in quotes

Actually, I reread your question and I answered it too quickly thinking the other tablecwas in a different app.

A better answer is this

Formula url field

URLRoot() & "db/" & [_DBID_MY TABLE NAME] & "?a=q&qid=99"

Lookup the table name from the Advanced properties of the table with the report and 99 needs to be replaced by the report ID#.