Adding a button to one report that references a report from another table filtered by Record ID#

Yes

well, maybe describe in more detail.

Im trying to add a calculated column to a summary report that links to table report from another table. I have a summary report in my JOBSITES table that I want a clickable link or button in that report that takes me to a table report in my INSPECTIONS table.  The first problem is I cant seem to get it to add a calculated column to the summary report no matter what.  Not sure if its permissions or if I just cant put a calculated column in a summary report. Sorry Im a newbie.

You should be able to create a calculated column by selecting <calculated column> for what field to Summarize or to group by.

If you want to have a link to go to other that the default drill down behavior,  you can make a hyperlink field  to where you want to link to and have that as a row or column grouping.

here is an example of a hyperlink - formula text field with html enabled.

var text URL = URLRoot() & "db/" & [_DBID_PATIENTS] & "?a=dr&rid=" & [Related Patient];

var text Words = [Patient Name];

"<a href=" & $URL & ">" & $Words & "</a>