Discussions

 View Only
  • 1.  How to make this report URL point back only to the related report details

    Posted 09-01-2015 12:43

    I am making a new hire checklist.  Each checklist has several related reports to the checklist questions table.  Each report has a "completed" button.  What I noticed while testing is that sometimes I might hit the completed button by mistake, which then removes the record from the report.  My easy answer to this was to have a link under the report that takes you back to the report, so you can easily un-tick the complete box.  

    I am using a Formula-URL field so that I can "hard code" the proper link back to the report (so that the link is always correct and there for the next new hire checklist).  Here is where my question comes in.

    This formula does bring me back to the proper report...

    ToText(URLRoot() & "db/" & "bjftfrx2p" & "?a=q&qid=25")

    However, it shows all the items in that report, not just the related report items.  I only want the related report items.  How can I change that formula to just show me the related report items?

    Thanks!



  • 2.  RE: How to make this report URL point back only to the related report details

    Posted 09-01-2015 19:53
    You will need to relocate the effect of a Report Link field which has the concept of filtering only record for the related parent.

    To do that make a report with an <ask the user> for related parent.  Run he report, answer the question of. With the record ID if any parent and  and observe the URL.  We need to replicate that URL.

    The formula will be

    URLRoot() & "db/" & [_DBID_of the child table with the ask the user report that you get from the Table's Advanced Properties] & "?a=q&qid=99&nv=1&v0=" & ToText([Related Parent]

    Replace the 99 with the report number you see in hat URL when you ran the report, and for [Related Parent] use the reference field in the Relationship which ties the children back to the Parent.


  • 3.  RE: How to make this report URL point back only to the related report details

    Posted 11-09-2017 21:34
    This was absolutely amazing! THANK YOU!  Solved an annoying report presentation issue that for two years I have just said, "deal with it."  No more. It even gets a nice pretty button now that the report does what I want it to do.


  • 4.  RE: How to make this report URL point back only to the related report details

    Posted 11-09-2017 23:01
    Thx, I see I had some typos, but you got what I was saying.


  • 5.  RE: How to make this report URL point back only to the related report details

    Posted 11-26-2018 04:55
    I'm using your formula and all is well except I would like to be able to have the 99 (the report id) reflect not a specific report but any report. I am using this button on a form and want the user to return to the report from which they selected the record. I don't know if there is a way to set the 99 to instead capture the qid versus hardcode a qid in there. Thanks. 


  • 6.  RE: How to make this report URL point back only to the related report details

    Posted 11-26-2018 12:47
    I suggest that you post this as a new complete question.