Lookahead value in master detail
Hello,
I am trying to do a look ahead value but can't seem to get it working
properly. I have a master-detail relationship and need to show the sum of a
qty field in the detail in the group header. If possible, I would like to
not even show the details. I have followed the instructions in the
RBuilder.pdf for making a look ahead, but it doesn't happen. If I put a
DBCalc in the footer, it sums the column properly, but the DBCalc (set to
sum(qty); lookahead=true) in the header band still reads "1" (no matter how
many items with qty are in the detail). In comparing the properties, the
only difference (besides layout properties) is lookahead.
Any help would be greatly appreciated.
Frank
I am trying to do a look ahead value but can't seem to get it working
properly. I have a master-detail relationship and need to show the sum of a
qty field in the detail in the group header. If possible, I would like to
not even show the details. I have followed the instructions in the
RBuilder.pdf for making a look ahead, but it doesn't happen. If I put a
DBCalc in the footer, it sums the column properly, but the DBCalc (set to
sum(qty); lookahead=true) in the header band still reads "1" (no matter how
many items with qty are in the detail). In comparing the properties, the
only difference (besides layout properties) is lookahead.
Any help would be greatly appreciated.
Frank
This discussion has been closed.
Comments
Where is the DBCalc located? Inside the subreport or in the main report?
Note that if you need to show the sum value of the subreport inside the main
report, you will need to manually calculate the sum in the OnCalc event of a
TppVariable. For instance... inside the subreport place an invisible
TppVariable set to calculate on Traversal. Inside its OnCalc event, update
the value of another TppVariable in the main report with LookAhead set to
True.
--
Regards,
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com