Past Due & Pending Action Buttons

[mparker123]

Hello,

I am trying to create two action buttons. One that will show me "Past Due" and one that will show me "Pending". The formula I am using for "Past Due" is =If([Due Date]<Today(),[Due Date])...... The formula i am using for "Pending" is =If([Due Date]>=Today()and [Due Date]<= today()+7,[Due Date]). Both these Formulas work and show me what i want to see within a straight table. However, i am now trying to create Action Buttons that when you click on the "past due" button or "pending" button it will show you only those values.

[Anil_Babu_Samineni]

I would always recommend you to go these approaches for this

1) May be Adhoc reports

2) Could be possible with Hide and show option for 2 straight tables

[neelamsaroha157]

Hi Matt,

You can create a variable for Hide/Show and in your table use that for showing one of the expression at one time.

Use the button to change value of the variable.

[johnw]

Seems to me you could do this with a new field and a list box instead of buttons.

if([Due Date]<today(),'Past Due',if([Due Date]<=today()+7,'Pending','Other') as Status,