Report showing Previous Day

[tchovanec]

I am trying to create a report that will only show the previous days numbers. Here is what I have tried with no success. I created an On open action and set the date to TODAY()-1. I then created the report and I have the report running after the document reload, but the report is not only showing the day before. It is running for every date. Any ideas on how to get this fixed? Thank you,

[whiteline]

Hi.

Have you checked your trigger action expression to work with a button action for example ?

[maxgro]

It seems to me the trigger should work

I try with a sheet trigger (select in field + lock field), see attachment

[#4]

Thomas,

You can try

1) create a variable v1

= '(' & today()-1 & ')'

2) set your select field action

= '$(v1)'

The select field must be populated with '(field1|field2|.....)'  (the quotes belong to the content of the field !!)

Fabrice