Table
ID IDQUOTE STATE DATE
1 55 4 1/15/2006
2 55 5 2/15/2006
3 55 6 3/15/2006
4 56 5 12/15/2007
5 57 5 12/15/2007
I WANT TO PRESENT IN THE REPORT IDQUOTE AND DATE ONLY WHERE THE STATE IS 5.
I CREATED A FORMULA FOR THE DATE COLUMN THAT IS NAMED @DATE5 AND THE FORMULA IS: IF STATE = 5 THEN DATE.
WHAT IS PRESENTED IN THE REPORT IS
IDQUOTE DATE
55
55
55 3/15/2006
56 12/15/2007
57 12/15/2007
THIS IS WHAT IS PRESENTED IN THE REPORT. I DONT WANT THE TWO ROWS WITH THE 55 IDQUOTE TO APPEAR. HOW CAN I DO THAT?