Embedded Report on Exact Form
An embedded table displays with no grouping or subtotals. You can change this by typing the following formula on your exact form:
~=qdb.GetURL("DetailsTableDBID", "API_GenResultsTable^query={'DetailsFieldID'.EX.'"+ field["MasterSourceField"]+"'}^options=nvw.ned.phd.nfg.sortorder-A.groupby-V^slist=DetailsGroupFieldID^ts="+ new Date().getTime());~
...
You'll need to replace the following values in this formula with your own information, as outlined in the table below:
You replace... |
With the... |
---|---|
DetailsTableDBID |
Database identifier of the details table from which the embedded report comes. Note: The Details Table DBID needs to be inside quotation marks. |
My report ID is 20. Now where to I place that info?
Report ID |
Identifier for the table or grid edit report you'd like to use as the embedded details table. When you display the report in Quick Base, the identifier is after qid= in the URL. |
Thanks
------------------------------
Audrey
------------------------------