|
Thanks Tim,
I'll use that method,
Michael
On 27-Nov-17 13:33, Tim Rude wrote:
If you want your report to include all items, even those with zero
sold, do the count in the subreport using a report variable rather
than the 'Number of Records in Report' function. Just before
starting the subreport, initialize the RV to zero. Then in the
body of the subreport, add 1 to the RV on each iteration. After
the subreport, print your RV value.
If you want to skip items with zero sold, leave your report as is
but move the printing of the item description into the subreport's
Final Footer. Since the subreport's Final Footer only runs if the
subreport processed some records, items with zero sold will just
be skipped entirely.
Tim Rude
On November 27, 2017 6:03:22 AM CST,
Michael Iannantuoni <[email protected]> wrote:
I am running a simple report to show the number sold of each item in my
database.
In the main report, I have the item description and then a subreport.
The subreport is empty other than for a 'Number of Records in Report' in
its Final Footer.
The report mostly works fine showing Item & number sold on the same line
which is what I want:
Item1 34
Item2 46
Item3 102
etc
The problem arises when there have been no sales of an item. Instead of
showing Item & zero, I get no number but the next Item on the same line:
Item4 67
Item5Item6 43
Item7 23
etc
Any ideas please?
Michael
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/cgi-bin/mailman/listinfo/dataperf
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/cgi-bin/mailman/listinfo/dataperf
|
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/cgi-bin/mailman/listinfo/dataperf
