How can I repeat printing a subreport by a value
Hi,
I am uing D6 SP2 + RB6.03. My customer want to print a strange report. The
report have two tables: SalesOrder & StockItem
SalesOrder has follow fields: SeqNo(PK), StockCode, Qty
StockItem has follow fields: StockCode(PK), Description, Price
So the SalesOrder is my master table, and the StockItem is the detail table.
And the report detail band will print the SalesOrder table, a Subreport will
print the StockItem.
What the customer want is: they want to reprint the subreport for many time
depend on the SalesOrder.Qty value. That means, if the master table Qty =
3, the subreport should print 3 times, if Qty = 0, don't print the
subreport. This is not a standard Master-Detail report, and I can not find
a way to do this. Can anyone give me some suggestion please?
Thanks!
Tao
I am uing D6 SP2 + RB6.03. My customer want to print a strange report. The
report have two tables: SalesOrder & StockItem
SalesOrder has follow fields: SeqNo(PK), StockCode, Qty
StockItem has follow fields: StockCode(PK), Description, Price
So the SalesOrder is my master table, and the StockItem is the detail table.
And the report detail band will print the SalesOrder table, a Subreport will
print the StockItem.
What the customer want is: they want to reprint the subreport for many time
depend on the SalesOrder.Qty value. That means, if the master table Qty =
3, the subreport should print 3 times, if Qty = 0, don't print the
subreport. This is not a standard Master-Detail report, and I can not find
a way to do this. Can anyone give me some suggestion please?
Thanks!
Tao
This discussion has been closed.
Comments
easily using the BandsPerRecord property. Here is an example which does
what you are describing:
http://www.digital-metaphors.com/tips/PrintCopiesOfDetailSubreportByMasterQt
y.zip
Cheers,
Jim Bennett
Digital Metaphors
http://www.digital-metaphors.com
info@digital-metaphors.com