Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
=Only({$<ID={1}>} Area)
hope this helps
Marco