Home Subreports
New Blog Posts: Merging Reports - Part 1 and Part 2

Lookahead variable

edited December 2007 in Subreports
Hi,

Ik have a report with one main table (main report) en 1 subtable
(subreport). They are attached toogether with a LEFT OUTER JOIN so
everything from the main table get displayed, and I only get subreport
where there are values.

My problem is that the "periode date" that I must show in the title
(or header) of the report comes from the subreports.

Report:
Vacation between date A and date B

Department ...
- Vacation info -the periode dates A and B are here


If the first department has vacation records I can use the dates, but
otherwise not...

How can I show it in the begining of the report when it only get
evaluated later?

I have no problem showing it in the footer.

I thoug initializing the variable after pass one or before pass two
would show it correctly but I don't think the title and header are
redisplayed in between?

Is there a way to do this?

Thankx

Chantal

Comments

  • edited December 2007
    Hi Chantal,

    If you are just trying to display a date range rather than a calculation
    (grand total, etc.), you might try using a TppLabel rather than a
    TppVariable. You should be able to simply update the Label.Caption at the
    end of the first pass or start of the second.

    Another option would be to pre-process your data and find the date range
    before the report prints.

    --
    Regards,

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

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited December 2007
    Just what I needed, Using TppLabel works perfect!


    Thankx,

    Chantal

    On Thu, 13 Dec 2007 08:56:19 -0700, "Nico Cizik \(Digital Metaphors\)"
This discussion has been closed.