Skip to main content
Question

I need to create a drilldown report that filters for the user that is clicked on and display their records

  • September 9, 2021
  • 0 replies
  • 25 views
The [Name] field (id 56) needs to be the user that filters the report that is drilldown to in this link but I don't know the URL syntax to filter the report dynamically via a URL.

"<div><a class='OpenAsPopup' data-height='700' data-width='1400' title='Click to View Historical Data' href='" & URLRoot()& "/db/brqaqhw2i?a=q&qid=5&ifv=0" & "'><b>" & [Name] & "</b></a></div>"

------------------------------
Greg Garcia
------------------------------
This topic has been closed for replies.

  • AhuvaBrown
  • Registered
  • September 10, 2021
Have you attempted to use the "ask the user" option in your report filters? If not, you would need to add a filter to the report where the name field is equal to <ask the user>.

As for the url, it would look something like this:
URLRoot()& "/db/brqaqhw2i?a=q&qid=5&nv=1&v0=" & [username field]


------------------------------
Ahuva Brown
------------------------------
Terms & ConditionsAccessibility statement