Showing Child records instead of Report Link
This might be a long shot. Is there a way to show the actual child records in a report instead of a report link? I have a detailed report I need to create but need to have all the related "Grant contr...
Forum Discussion
I've tried a few different times that way but no luck. I'm able to get a few important fields rolled into the report (- field), but is there a way to have that field linked to the Related Contracts shown?
Bethany Hudson
Program Administrator
Mobile Bay National Estuary Program
118 North Royal Street, Suite 601
Mobile, AL 36602
(o) 251-459-8870
(c) 251-367-1368
MarkShnier__You
Qrew Legend
Qrew LegendAre you asking if you can make that appear as a hyperlink to the children?
------------------------------
Mark Shnier (YQC)
[email protected]
------------------------------
------------------------------
Mark Shnier (YQC)
[email protected]
------------------------------
- Yes.--Bethany HudsonProgram AdministratorMobile Bay National Estuary Program118 North Royal Street, Suite 601Mobile, AL 36602(o) 251-459-8870(c) 251-367-1368
- MarkShnier__Youyes you can make a hyperlink.
Make a report of children where its an <ask the user> for Related Parent, says its qid of 99. (report #99)
var text Words = [That - field on the report which has the rolled up details];
var text URL = URLRoot() & "db/" & [_DBID_CHILD_RECORD (ie the table alias of the child table)] & "?a=q&qid=99&nv=1&v0=" & [Record ID#];
// replace the 99 with your qid
// this last part is always the same for any hyperlink
"<a href=" & $URL & ">" & $Words & "</a>"
------------------------------
Mark Shnier (YQC)
[email protected]
------------------------------- This is what I'm getting:Then this if I click the link:--Bethany HudsonProgram AdministratorMobile Bay National Estuary Program118 North Royal Street, Suite 601Mobile, AL 36602(o) 251-459-8870(c) 251-367-1368