display one data value in text box based on a lookup

[chrismtb]

Hi all,

I have an issue which I could do with some help on.

I have a data set (simplified below) that i have loaded into my application:

ID	Area	Manager	Status
1	Northwest	Jenny	Active
2	Northeast	Steve	Closed
3	Southwest	Mike	Active
4	Southeast	Carol	Closed

I want to create a set of text boxes for a report that pull this data out individually i.e.  a text box that will display the Area for the ID 1 and another when the ID is 2, so in effect using a lookup type function.

i thought of using an if statement... if(ID=1, Area, ' ') however this only works for me if just the one data line is filtered in the application.

Can anyone help me with this?

Thanks

Chris

[MarcoWedel · Accepted solution]

=Only({$<ID={1}>} Area)

hope this helps

Marco