|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
| Jason Weathersby
Registered: July 2009
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
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
> 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 ;)
Powered by FUDForum
. Page generated in 0.24407 seconds