Forum Discussion

EnderTaylor's avatar
EnderTaylor
Qrew Cadet
11 hours ago

Formula Rich Text Button: Report Link

Hey!
Mainly for aesthetic reasons, I am attempting to create a Formula Rich Text Button that just points to the Report Link (Built through a relationship). 
"<table style='width:100%;border: 0px Solid White'>" &
    "<tbody>" &
        "<tr>" &
            "<td style='vertical-align:top;text-align:Left;'>" &
                "<div " & $stylebtn & ">" &
                    "<a href='" & [Report Link] & "' style='color: inherit; text-decoration: none;'>Tittle</a>" &
                "</div>" &
            "</td>" &
        "</tr>" &
    "</tbody>" &
"</table>"

The Formula returns no errors, but when pressed it just returns back to the Original record. I am trying to get it to open a report of the Child Records using the Embedded for Report. 

If I can't do it that way (which seems simplest), I think I would have to do a whole query within a URL. Writting a query isn't the problem so much as I am not sure how to direct a URL to use a Particular report with a Report ID. 

Any suggestions on either how to modify the formula to get it to actually use the Report Link, or on how to generate a Formula URL that goes to the Report but filters using the Query?

formula query
  • DonLarson's avatar
    DonLarson
    Qrew Elite
    7 hours ago

    Here is a formula I use all the time

    // Report Link

    var text Report = URLRoot() & "db/" & [_DBID_Target_Table] & "?a=q&qid=XX&nv=1&v0=";

    Set the DBID for your application

    Change XX to the correct report in your Target Table

    This assumes that you are passing a one value to the query.  Delete if not appropriate.

    Then put the $Report variable in place of your HREF in the HTML table that you built