Discussions

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 13 days ago
    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 12 days ago
    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
    ------------------------------