Urgent. Printing one label with two TppDBText linking to two different tables.
Hello.
I try to print labels like this, with the two fields from separate
tables:
125
30,00
The first number is the itemnumber and below is the price.
To avoid confusion, the price is in bold font and the itemnumber in
regular font.
I use the detailband in the report.
The report prints correctly for pipeline1 that is common for the report
itself and TppDBTextItemnumber and connected to the itemnumber table,
but TppDBTextPrice, that is connected to the price table through
pipeline2, is just repeating the first record and do not traverse the
price table.
When TppDBTextItemnumber is empty and stops printing, TppDBTextPrice
continues printing the first record of the price table until the whole
sheet is full.
What am I doing wrong here?
Thanks for all help, in advance.
Kai Inge
PS. The reason why I do not have the two fields in the same table:
I use Firebird and discovered a limit of columns at 28 fields VarChar 8,
when I tried to have all in one table matrix: 125 30,00 125 30,00 and
so on.
The sheet with glued labels do have 17 labels in one row and has 36 rows
and with this method I need 17 * 2 = 34 columns to fill a row with
itemnumber and price,
which was not possible because of the columns limit in Firebird.
I try to print labels like this, with the two fields from separate
tables:
125
30,00
The first number is the itemnumber and below is the price.
To avoid confusion, the price is in bold font and the itemnumber in
regular font.
I use the detailband in the report.
The report prints correctly for pipeline1 that is common for the report
itself and TppDBTextItemnumber and connected to the itemnumber table,
but TppDBTextPrice, that is connected to the price table through
pipeline2, is just repeating the first record and do not traverse the
price table.
When TppDBTextItemnumber is empty and stops printing, TppDBTextPrice
continues printing the first record of the price table until the whole
sheet is full.
What am I doing wrong here?
Thanks for all help, in advance.
Kai Inge
PS. The reason why I do not have the two fields in the same table:
I use Firebird and discovered a limit of columns at 28 fields VarChar 8,
when I tried to have all in one table matrix: 125 30,00 125 30,00 and
so on.
The sheet with glued labels do have 17 labels in one row and has 36 rows
and with this method I need 17 * 2 = 34 columns to fill a row with
itemnumber and price,
which was not possible because of the columns limit in Firebird.
This discussion has been closed.