| Computed Column on Linked Table? [message #54542] |
Wed, 06 July 2005 20:44  |
Eclipse User |
|
|
|
Originally posted by: none.none.none
I have a report similar to the example in the documentation titled "Building
a report with parallel subreports". I need to create a 'computed field' in
the subreport that utilizes values from its parent report/table (they are
linked by a parameter). How do I do this? The documenation says that
computed fields are for computing values withing the same data set.
However, since I essentially have the two datasets linked, there must be a
way to get a handle on the other dataset's values to perform a calculation
with values from both datasets.
Please help.
Thanks!
|
|
|
| Re: Computed Column on Linked Table? [message #54564 is a reply to message #54542] |
Wed, 06 July 2005 22:02  |
| Eclipse User |
|
|
|
Originally posted by: none.none.none
Ok, I've figured out a solution (or is it a workaround?). For those who are
interested....
a) I added some code in the "onrow" event of my List element (the one that
contains both datasets), assigning the value of interest to a variable.
var master_report_value = row["a_master_report_column"];
b) Added a Data element to my subreport and created an expression using
that variable.
"Cost Per Unit: " + (row["cost"] / master_report_value);
This seems to work, but if someone knows a better way, please let us know.
"chris" <none@none.none> wrote in message
news:dahfri$hi3$1@news.eclipse.org...
>I have a report similar to the example in the documentation titled
>"Building a report with parallel subreports". I need to create a 'computed
>field' in the subreport that utilizes values from its parent report/table
>(they are linked by a parameter). How do I do this? The documenation says
>that computed fields are for computing values withing the same data set.
>However, since I essentially have the two datasets linked, there must be a
>way to get a handle on the other dataset's values to perform a calculation
>with values from both datasets.
> Please help.
>
> Thanks!
>
|
|
|
Powered by
FUDForum. Page generated in 0.02812 seconds
] 
Search
Help
Register
Login
Home
