I am not sure if this ability is available or I am not doing it right. I have a 2 Table structure (one to many) where table one is header data (unique) and the second is detail (many) linked by one column (BLNO). I created a report to show me the totals per BLNO for a given day. In my report I have the 2 tables included, and then I do a break on the header table by BLNO. My report has 2 bands that are used, Break footer 0 and Page Footer. In the Break footer 0, I placed the BLNO, and then I wanted to do a DBCALC SUM on the detail table on 2 different Columns with the reset break on BLNO . Then the Page Footer would have a DBCALC SUM on the same columns with no reset break.
When I run this report it will not sum multiple line details on the DBCALC in either report band. What shows up is just the column information for the first line in the detail only, all other multiple lines are ignored. Am I thinking of something that is not really a feature of the two table ability in reports ? I know they are used mostly for sub report abilities, but not sure if 2 tables can be used on the same band in the master report / table. Thanks.. Frank Taylor - Information Technology Administrator F.J. O'Hara & Sons, Inc - Araho Transfer Inc. Boston, MA - Rockland, ME - Miami, FL Direct Dial - 617-790-3093 email: [email protected]<http://mail.whitewolftechnologies.com/cgi-bin/compose.exe?id=01ef7f9322f8a76400dacb6a1fe342bb5a7&new=&xsl=compose.xsl&[email protected]>
