Issue 78502 - RPT: bound field in page heading improperly generated in final report
Summary: RPT: bound field in page heading improperly generated in final report
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: recent-trunk
Hardware: All All
: P3 Trivial (vote)
Target Milestone: OOo 2.4
Assignee: marc.neumann
QA Contact: issues@dba
Keywords: new_implementation
: 78828 (view as issue list)
Depends on:
Reported: 2007-06-14 21:22 UTC by Frank Schönheit
Modified: 2012-03-01 22:32 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

document to reproduce the bug case (12.53 KB, application/vnd.sun.xml.base)
2007-06-14 21:24 UTC, Frank Schönheit
no flags Details
File created with a m235 (8.98 KB, application/vnd.oasis.opendocument.text)
2007-12-14 07:49 UTC, ocke.janssen
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description Frank Schönheit 2007-06-14 21:22:45 UTC
- open the attached database document
- open the report "lost page heading field" for editing
- note the two formatted fields, one in the page header, one in the detail
  section. Both have exactly the same settings
- execute the report
=> in the detail section, the field is properly field (with the current date)
   The field in the page header, though, is empty in the generated report

(note: The field contains a date field, which does not work unless you have a
build where issue 77039 is fixed. However, you can enter *any* report formula in
the field: In the detail section, it will be properly shown, in the page
header/footer, it won't.)
Comment 1 Frank Schönheit 2007-06-14 21:23:52 UTC
Effectively, it means you're unable to place a date or time field in the page
header. One might think this makes those fields somewhat useless ...
Comment 2 Frank Schönheit 2007-06-14 21:24:22 UTC
This is a new implementation in CWS oj14. Adding keyword "new_implementation".
Comment 3 Frank Schönheit 2007-06-14 21:24:44 UTC
Created attachment 45947 [details]
document to reproduce the bug case
Comment 4 tmorgner 2007-06-14 23:22:07 UTC
This bug is connected to (or may even be caused by the same flaw as) the bug
#77039 (Date-Time fields dont work). The generated report contains the correct
'get-variable' commands in the header, so this is a matter of formatting the
thing correctly.
Comment 5 Frank Schönheit 2007-06-24 20:49:02 UTC
*** Issue 78828 has been marked as a duplicate of this issue. ***
Comment 6 Frank Schönheit 2007-07-02 10:04:45 UTC
The Report Designer iTeam decided that this issue is a show stopper for the
release of the report designer. Targeting to 2.3, thus.
Comment 7 tmorgner 2007-07-24 18:29:19 UTC
Fixed; the code searched for the wrong element, and therefore was never able to
apply the correct style. Now the fields in the page-heading will be formatted

(The data itself was never 'lost' - but as soon as an invalid data-format is
applied, the value will not be printed.)
Comment 8 ocke.janssen 2007-08-01 07:44:53 UTC
The date field in the page header is not formatted correctly.
Comment 9 ocke.janssen 2007-08-01 07:45:33 UTC
This seems to be a writer issue. Please take care for this one. Thanks.
Comment 10 ocke.janssen 2007-08-01 07:46:12 UTC
Change target.
Comment 11 andreas.martens 2007-12-13 11:03:23 UTC
Could you provide a (small) Writer document which shows the problem to me?
Or is this issue already solved?
Comment 12 ocke.janssen 2007-12-14 07:49:57 UTC
Created attachment 50307 [details]
File created with a m235
Comment 13 ocke.janssen 2007-12-14 07:50:56 UTC
I added a report.
Comment 14 andreas.martens 2007-12-14 14:25:38 UTC
ama->oj: The content of the header table cell should look like this:

  <text:variable-get text:name="auto_report_1" office:value-type="date"

It is not enough to set office:value-type to "date", you have to choose the
right  style:data-style-name for the wished date format, too.
Comment 15 ocke.janssen 2008-01-07 12:24:59 UTC
Could you please take care for this also. Thanks.
Comment 16 ocke.janssen 2008-01-21 09:45:49 UTC
Fixed in cws pentaho2.

Now the date in the page header is correctly shown.
Comment 17 ocke.janssen 2008-01-21 09:46:23 UTC
Set to fixed.
Comment 18 marc.neumann 2008-01-22 10:20:47 UTC
verified in CWS pentaho2

find more information about this CWS, like when it is available in the master
builds, in EIS, the Environment Information System:
Comment 19 drewjensen.inbox 2008-03-15 02:56:28 UTC
Tested w/OOo 2.4 m_11, Kubuntu 7.1 64bit, SRB 1.0.2