Discussions

 View Only
Expand all | Collapse all

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

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

    Posted 09-09-2021 15:29
    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
    ------------------------------


  • 2.  RE: I need to create a drilldown report that filters for the user that is clicked on and display their records

    Posted 09-10-2021 11:07
    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
    ------------------------------