Forum Discussion

MikeMike3's avatar
MikeMike3
Qrew Trainee
9 years ago

GenResultsTable in exact form formatting

I have a GenResultsTable embedded in an exact form I dont want to display the TOT totals line at the bottom.  How can I do this
This is the current code
~=qdb.GetURL("TableID", "API_GenResultsTable^query={'10'.EX.'"+ field["Record ID#"]+"'}^clist=18.29.46.47.^options=nvw.ned.phd.nfg.sortorder-A^slist=25");~

2 Replies

Sort By
  • Eric_J_Hansen's avatar
    Eric_J_Hansen
    Qrew Cadet
    9 years ago
    This probably isn't the answer you are looking for, but you could turn off the totals in the field properties for those fields that are totaling on your document. Otherwise, you might mess around with these: options=nvw.ned.phd.nfg to see if removing one of them does the trick. Let me know if you find a resolution. =]
  • MikeMike3's avatar
    MikeMike3
    Qrew Trainee
    9 years ago
    Actually I found that removing totals in the field worked yesterday after I posted here.  It worked like a charm.  I had to convert some of my numeric fields to formula text fields in the report but it works.