|
Re: How to write an expression which uses items from multiple data sets? [message #890062 is a reply to message #889891] |
Wed, 20 June 2012 21:33 |
|
Paul,
I am not 100% on the example but generally expressions can only access
one dataset, but they can access global variables. So you could put ds2
values in a global array variable and then reference this from the
highlight.
Jason
On 6/20/2012 3:39 AM, Paul Ramsden wrote:
> I have a report which displays staff roles at an exhibition over a
> number of days. The main dataset (DS1) contains roles on day1, day2,
> ..., day10 for each staff member. From a second dataset (DS2), I added
> the actual dates to the column headers. This dataset contains the
> start/end of the whole period (including preparation/tidy-up), the
> start/end of the actual exhibition and the actual date of day1 - dayN.
> It has just one row.
>
> The result looks like this:
>
>
> Name 19 20 21 22 23 24
> ----------------------------------
> Adam S S
> Brian V S V
> Charlie . . S S S .
>
>
> In the example above, 19, 20 and 24 are preparation/tidy-up days and
> 21-23 are the actual exhibition days. I now want to add a highlight
> which adds a left/right border to indicate the start / end of the
> exhibition.
>
> It seems to me that the highlight expression needed on each cell should
> be something like:
>
> if(cell_date == exhib_start) style = 'left_border';
>
> So how do I write an expression in the context of DS1 (i.e. in the
> Details row of the table) which fetches data from DS2?
>
> Hope someone understands what I'm trying to say ;)
>
> Paul
|
|
|
Powered by
FUDForum. Page generated in 0.03262 seconds