Subreports and SkipWhenNoRecords

rbuser

I have a master-detail-detail relationship. Invoices, line items, and
additional line item descriptions.

There may be 0..n additional descriptions for a given line item. If
there are 0, I do not want that subreport to take up any space in the
detail band. However, I cannot skip the line item with
SkipWhenNoRecords.

How can this be done in ReportBuilder?

++++
Bill Sorensen, Programmer/Analyst, ASI/EDI Inc.
(opinions are mine alone)
bsorensen@asicentral.com
www.asiedi.com

nardmoseley

That can be controlled via the ChildReport.NoDataBehaviors property.
Check the RBuilder.hlp file for details.

rbuser

Thank you, but I'm unclear as to how to do this. The property does
not appear to be public/published.

What I have:

[detail band for line item subreport]
[line item fields]
[subreport for additional line items; detail to line item's master]]
[some other subreports]

On Thu, 2 Aug 2001 12:48:58 -0500 , "Nard Moseley (Digital Metaphors)"

rbuser

I think I've figured it out. Based on a comment in the source, I
created a group in the line item subreport using the line item key (so
it wouldn't ever break). Then I set that group's footer to dynamic
height, and moved all the subreports to the group footer. This
appears to work. If it's "wrong," please let me know.

Incidentally, it's a real pain to draw a line between line items using
this method. I had to set up another non-breaking group below that
one, put a line on it, then set its static height to one pixel in
code.

On Thu, 2 Aug 2001 16:12:02 -0500 , William Sorensen

nardmoseley

NoDataBehaviors is a pulished property of TppReport and TppChildReport.
It can be set via the object inspector. For a subreport, you need to
select the tab at the bottom of the designer to access the childreport's
workspace. The childreport will then become the selected component in
the object inspector. (From the workspace of any report/childreport you
click on the small square button that appears in the upper left corner -
where the rulers meet - to select the report/childreport in the object
inspector.

rbuser

Found it, thank you.

This information does not appear to be relevant, however. I checked
it; my subreport child reports are set to [ndBlankPage]. According to
the help:


The described subreport behavior does not appear to be the actual
behavior in 6.01.

On Fri, 3 Aug 2001 08:40:03 -0500 , "Nard Moseley (Digital Metaphors)"