Skip to Content
0
Former Member
Jun 30, 2011 at 11:47 AM

I need to filter specificly to one field/formula

13 Views

Guys and Gals,

I have searched a fair bit on the internet and checked some books but I cant find a solution for this fairly simple issue. I hope you can shed some light on this for me.

I need to apply a filter specifically within just one formula to get a specific record out of the system for that one 'cell'.

First Formula:

"whileprintingrecords

({DATATABLE1.RECORD1}) = 1

now print me the data from here ({DATATABLE1.RECORD2})"

Second Formula:

"whileprintingrecords

({DATATABLE1.RECORD1}) = 2

now print me the data from here ({DATATABLE1.RECORD2})"

When I use filters to exclude the third and final option (using 'does not equal') from DATATABLE1.RECORD1 it outputs the info I need but it also doubles every line of output.