K
KLP
I have 2 tables - Loan info and Collateral. In a report, I need to compute
and display the total loan amount, total collateral value, and compute a
loan-to-value ratio for each loan. One loan can have multiple pieces of
collateral. So I got the totals and the LTV using queries. In the report,
Collateral is a sub-report of Loan Info, and I inserted the LTV report as a
sub-repot of Collateral. The totals and LTV display correctly, however,
they are shown for each loan. In the LTV report it shows each loan and the
totals for balance, value and LTV. How do I get it to show only once?
and display the total loan amount, total collateral value, and compute a
loan-to-value ratio for each loan. One loan can have multiple pieces of
collateral. So I got the totals and the LTV using queries. In the report,
Collateral is a sub-report of Loan Info, and I inserted the LTV report as a
sub-repot of Collateral. The totals and LTV display correctly, however,
they are shown for each loan. In the LTV report it shows each loan and the
totals for balance, value and LTV. How do I get it to show only once?