Frank, you can do this in three ways that I know of - R:Azzak probably
has 102 more ways.
1. Base the report on the detail table only, and use report variables to
get the header information from the header table.
2. Create a view that links the detail table to the header table on BLNO.
3. Create a temporary table with exactly the columns you need in the
report, populate it with the detail table data and update the temporary
table with the header table information. This is the method I use
whenever the report may be selecting a lot of rows from a large table
set. This way I insert only the rows that I need for the report, meaning
that the report generator only sees the rows it needs.
Albert
On 30/03/2011 9:17 AM, Frank Taylor wrote:
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.
