Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I need the current year to be automatically selected when a user opens the report. I have tried using the Document Properties > Triggers > OnOpen but that didn't work for me. Can anyone give me some pointers on how to do this? Maybe an example?
Thanks.
Right place,
in the actions select add, then "Select in field" and write in the upper box: year (your field name)
in the lower box: =year(today())
let me know
HI ,
Please find the attachment ,
i have enabled both Document level as well as Sheet level
Thank you for your response. For some reason, it does not work. I have attached the image of what it looks like. Can you please check? Thanks.
Hi
There field Should be
Year([Budget Year Description])
searching string is
=max(Year([Budget Year Description]))
Make sure "Year([Budget Year Description])" is your Year Field
Hi, I worked with your example and it did not work either. Attached is the image. Any suggestions?
My data looks like FY13, FY14, FY15. Could it be because the data is not only integers?
Thanks.
hi ,
post your sample file
Intead max overthere
use
maxstring([Budget Year Description])
IN the field write only
[Budget Year Description]
Hi Alessandro and Sasikanth, thanks for your help. I got it working using:
Field: [Budget Year Description]
Search String: =maxstring([Budget Year Description])
It also worked with Budget Year ID.
Thanks again.