How to generate a dynamic bar graph on a form by dynamically applying filter on a column through a click on the report

np,

Make a perfect Report that you want to run in table 2, but have an make it an <ask the user> filter. 

Run the report, answer the question and observe the URL.

Now, make a URL formula field in table 1  to mimic that URL


URLRoot() & "db/" & [_DBID of table 2 from Advanced properties] & "?a=q&qid=xx&nv=1&v0=" & urlencode(field from table 1 record to use as a filter)