Need URL formula link that displays a report from Table #1 while viewing records in Table #2
Is this possible?
Forum Discussion
What if I have 2 <ask the user> questions in the report (Project Number and Fiscal Year) but the user still have to specify the Fiscal Year.
It is work if I set Fiscal Year with a specific value (ex: FY-2020) ...
URLRoot() & "db/" & [_DBID_EXPENDITURES] & "?a=q&qid=7&nv=2&v0=" & URLEncode([Project-ID]) & "&v1=" & URLEncode("FY-2020")
But if Fiscal Year is still an <ask the user> question, what have I to do?
Thanks,
Karen
It is work if I set Fiscal Year with a specific value (ex: FY-2020) ...
URLRoot() & "db/" & [_DBID_EXPENDITURES] & "?a=q&qid=7&nv=2&v0=" & URLEncode([Project-ID]) & "&v1=" & URLEncode("FY-2020")
But if Fiscal Year is still an <ask the user> question, what have I to do?
Thanks,
Karen
There may be solutions with increasing levels of complexity to set up, but how about landing the user on a report with just the project pre-selected by the URL and allowing them to just use a Dynamic Filter to select a fiscal year? basically that is the same effort as having to answer an <ask the user> question, it's just off to the side.
The report description can Remind them tell them to do that. The report can also sort and group by Fiscal year.
The report description can Remind them tell them to do that. The report can also sort and group by Fiscal year.