Lookahead variable
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
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
This discussion has been closed.
Comments
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
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Thankx,
Chantal
On Thu, 13 Dec 2007 08:56:19 -0700, "Nico Cizik \(Digital Metaphors\)"