Default Selections while loading the document

[Anonymous]

Hi All,

     I have requirement to display default selections when I am loading the document. I have a business date column when I load the document  i want to be srtart date and end dates are populated below values so sales will be filtered on these filters.

     Start Date: 08/01/2012

     End Date:  08/30/2012.

     Attached the QVW file..

Thanks

Dasu.G

[#2]

Hi,

Pl find attched application..

[Anonymous]

Thanks for the response..

It is quite useful when we have these dates static.  I forgot to mention one that that below mentioned dates are just example.

Start Date: 08/01/2012

End Date:  08/30/2012.

These fields are fiscal year start date and end date hence these values can change dynamically  this solution won't work..

[Gysbert_Wassenaar · Accepted solution]

You can use the OnOpen trigger also to add Select in Field actions. You can add variables to your document that calculate the fiscal dates. You can use these variables in the Search String.