Reply to comment
If you place a view link field on your Exact Forms MS Word template this turns into a table with no grouping or subtotals. If you want grouping and subtotals you can use the following method:
~=qdb.GetURL("targetdbid", "API_GenResultsTable^query={'12'.EX.'"+ field["Source Field"]+"'}^options=nvw.ned.phd.nfg.sortorder-A.groupby-V^slist=15");~
You'll need to replace
targetdbid
with the database identifier of the table (details table) from which the embedded view will come from.
You'll have to replace the
12
with the field identifier of the target field (most often this is a reference field) in the details table.
You'll have to replace
Source Field
with the label of the source field (most often this is the key field) in the master table.
You'll have to replace
15
with the field identifier in the details table that you want to do the grouping on for the purpose of generating subtotals.
To learn about field identifiers and table database identifiers please read the following FAQs respectively:
- 35192 reads
