On Open trigger action

Anonymous — Mon, 29 Oct 2012 13:47:17 GMT

I want my report to open with defult week set as this week.

I have a load statement like:

Load

Week(ActualStartTimeUTC) as AactualWeek

;

...

I then did:

document settings --> Triggers-->Document Event Triggers --> OnOpen action.

Please find below a screendump of my settings.

I assumed that when I now saved and then opened my document Week( the red circle) would be set.

But as you can imagine, I did not get the result needed.

Any advise?

Dan

Re: On Open trigger action

MayilVahanan — Mon, 29 Oct 2012 13:51:10 GMT

Try like that

SearchString

=Week(Today())

Anonymous — Mon, 29 Oct 2012 13:54:26 GMT

Brilliant.

Thanks a lot.

Dan