F
forcefield via AccessMonster.com
My subreport and main report are linked via master and child relationship.
The subreport has a running sum and I have placed it in the main report item
footer. How do you prevent the subreport from not displaying that item if it
has a zero running sum?
The structure of the main report whose record source is a query is as follows:
Report header consists of title of the report
Page header consists of headings for the detail section
Item header consists of Item
NameofSupplier Header consists of supplier names
Detail consists of Inv Date, Inv No, Unit price etc
Item Footer (where the subreport is located)
Page Footer consists of Page No
The subreport is pulled from a query has a structure
Page Header
Item Header
Detail Section (whose visible is set to NO) consists of PurchaseDate, Item
PurchaseQty, OutQty
Item Footer (visible Yes) consists of RunSum
whose record source is DSum(" Nz([PurchaseQty])-Nz([OutQty]) ",
"tblSubProduct","(QtyID<=" & Nz([QtyID],0) & ") And ([Item] = '" & Replace
([Item],"'","''") & "')") as appeared in the query.
The subreport is dragged into the item footer of the main report. When I ran
it, the report displays all the items including those with running sum zero.
What I would to do is only display those items in the main report and its
running sum in the subreport if the running sum in the subreport is not zero.
Can someone please help?
The subreport has a running sum and I have placed it in the main report item
footer. How do you prevent the subreport from not displaying that item if it
has a zero running sum?
The structure of the main report whose record source is a query is as follows:
Report header consists of title of the report
Page header consists of headings for the detail section
Item header consists of Item
NameofSupplier Header consists of supplier names
Detail consists of Inv Date, Inv No, Unit price etc
Item Footer (where the subreport is located)
Page Footer consists of Page No
The subreport is pulled from a query has a structure
Page Header
Item Header
Detail Section (whose visible is set to NO) consists of PurchaseDate, Item
PurchaseQty, OutQty
Item Footer (visible Yes) consists of RunSum
whose record source is DSum(" Nz([PurchaseQty])-Nz([OutQty]) ",
"tblSubProduct","(QtyID<=" & Nz([QtyID],0) & ") And ([Item] = '" & Replace
([Item],"'","''") & "')") as appeared in the query.
The subreport is dragged into the item footer of the main report. When I ran
it, the report displays all the items including those with running sum zero.
What I would to do is only display those items in the main report and its
running sum in the subreport if the running sum in the subreport is not zero.
Can someone please help?