Need URL formula link that displays a report from Table #1 while viewing records in Table #2
Is this possible?
Forum Discussion
If you want to launch a report off a record and want it to be filtered on some criteria that the record knows, you can do that easily.
1. Make your perfect report, and have an <ask the user> for any criteria. Let's say there is just 1 criteria for this example.
2. Run the report and answer the question manually.
3. Observe the URL. That is what we need to replicate in the URL
Make the Formula URL field.
Urlroot() & "db/" & [_DBID of target table from its advanced properties] & "?a=q&qid=99&nv=1&v0=" & ULREncode([field from the record you are launching form]
replace the 99 with the qid of your report.
1. Make your perfect report, and have an <ask the user> for any criteria. Let's say there is just 1 criteria for this example.
2. Run the report and answer the question manually.
3. Observe the URL. That is what we need to replicate in the URL
Make the Formula URL field.
Urlroot() & "db/" & [_DBID of target table from its advanced properties] & "?a=q&qid=99&nv=1&v0=" & ULREncode([field from the record you are launching form]
replace the 99 with the qid of your report.