Formula for the main Report : ‘<A href=”/app/common/search/searchresults.nl?searchtype=Transaction&IT_CUSTITEM_JJ_CATEGORY=’||{item.custitem_jj_category.id}||’&Transaction_LOCATION=’||{location.id}||’&ID_InventoryDetail_STATUS=’||{status.id}||’&ID_InventoryDetail_INVENTORYNUMBER=’||{inventorynumber.id}||’&style=NORMAL&Transaction_SERIALNUMBERtype=STARTSWITH&report=&grid=&searchid=1995″ target=”_blank”>View Transactions</A>’
Formula for the second Report: ‘<a href=”/app/accounting/transactions/transaction.nl?id=’||{internalid}||'” target=”_blank”>View Record</a>’
(Please note it is an example of the linking formulas similarly we can link searches based on the requirement.)