Issue 78077 - RPT: need a possibility to refer parameter values in the report
Summary: RPT: need a possibility to refer parameter values in the report
Status: CLOSED FIXED
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: recent-trunk
Hardware: All All
: P3 Trivial with 1 vote (vote)
Target Milestone: OOo 2.3
Assignee: marc.neumann
QA Contact: issues@dba
URL:
Keywords: new_implementation
Depends on:
Blocks:
 
Reported: 2007-06-04 12:00 UTC by Frank Schönheit
Modified: 2007-08-19 04:02 UTC (History)
1 user (show)

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


Attachments

Note You need to log in before you can comment on or make changes to this issue.
Description Frank Schönheit 2007-06-04 12:00:52 UTC
Imagine you want to have a report which contains, say, the sales volume of your
company per month. You design this report, and execute it once per month - which
will get you one document per month. You usually do this with a parametrized query.

Unfortunately, in the resulting document, you cannot see *which* month this
report is for: When you executed the report, you filled in the query's parameter
which denotes the month (or the start and end day), but you have no change to
refer those parameter values in the report.

As a consequence, you must modify either your query, or the design of your
report, every time you run it.

Competitive products allow to refer to parameter values as if they were column
names, e.g. [start_date].
Comment 1 Frank Schönheit 2007-06-04 12:01:18 UTC
This is a new implementation in CWS oj14. Adding keyword "new_implementation".
Comment 2 Frank Schönheit 2007-06-04 12:34:34 UTC
The Report Designer iTeam decided that this issue is a "should fix" for the
first release of the report designer. Targeting to 2.x, thus.
Comment 3 Frank Schönheit 2007-06-06 20:07:34 UTC
fixed in CWS oj14

find more information about this CWS, like when it is available in the master
builds, in EIS, the Environment Information System:
http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=SRC680%2Foj14
Comment 4 Frank Schönheit 2007-06-12 14:54:15 UTC
re-opening - does not work in 0.4.0 build.
Comment 5 Frank Schönheit 2007-06-18 09:57:21 UTC
fixed again in CWS oj14. Somebody superseded the file which contained my fix
with another one in another location, without re-adding my fix.
Comment 6 Frank Schönheit 2007-06-18 10:01:15 UTC
targeting to 2.3, since the fix is part of a CWS aiming for this release
Comment 7 Frank Schönheit 2007-06-27 13:44:26 UTC
fs-> msc: please verify in CWS oj14
Comment 8 marc.neumann 2007-07-03 13:49:24 UTC
verified in CWS oj14 version 0.5.0
Comment 9 drewjensen.inbox 2007-08-19 04:02:47 UTC
Tested w/ 2.3m_1 and Sun Report Builder 1.0

The parameter names are passed into the add fields box.
Numeric and Text parameters are passed in correctly.
Date and Time parameters are displayed as numerics, but I believe that is
already open as a different issue so closing this issue.