Home› RAP
New Blog Posts: Merging Reports - Part 1 and Part 2
ReportBuilder 22.05 now available!

How NOT to print a detail line item...

rbuserrbuser
edited April 2007 in RAP
Hi,
I'm trying to change an accounting invoice report already designed and
working fine, to NOT print a detail line item if the Quantity Shipped = 0
and the Quantity Backordered =0. If they are both = 0 then don't print the
line item. At first thought easy task, i.e. when the detail band before
print event fires just test with an if statement and make the dbtext
components invisible. This hides the whole column and not the row.
Am I explaining so understand?

Tks,
Don

Comments

  • nicociziknicocizik
    edited April 2007
    Hi Don,

    1. If you would like you can set the visibility of the entire band to
    False, or, you can place all your components inside a TppRegion and toggle
    the visibility of that to make the process easier.

    2. Be sure you are setting the visibility back to True if the condition is
    not met. Once the visibility of a report component is set to False, it will
    remain that way unless otherwise defined.

    lbVisible := (Report.DataPipeline['QuantityShipped'] = 0) and
    (Report.DataPipeline['QuantityBackordered'] = 0);

    ppDetailBand1.Visible := lbVisible;

    --
    Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • rbuserrbuser
    edited April 2007
    Nico,
    Thanks, that sounds like that might work. Didn't think of creating a
    region, don't know how to do that, but I'll figure it out. I'm new at using
    RBuilder but love it also. Great reporting system. Basically, all I'm
    attempting to do is if the invoice detail line item has zero backorder and
    zero shipped, then no need to print that line item on the invoice. The
    report has header, detail and footer is all. Fairly simple report. Simple
    IF statement will do it, just figuring the ins and outs to RBuilder.
    I'll work with this and let you know.

    Tks again,
    Don

  • rbuserrbuser
    edited May 2007
    Nico,
    The Region component works perfectly for this design. Just used the
    component to encapsulate the data and then wrote an if statement for the
    print event and if the QtyShipped and QtyBO both equaled 0, then made the
    region invisible and that detail line doesn't show and behavior was skipped.
    Thanks for your help.
    Don
This discussion has been closed.