How to remove selections which "clear all" button cannot?

[#1]

Hi All,

I have set OnOpen trigger in a report to select today's date. It works fine when i open it but as soon as i clear the selections my report selects "1-jun-2011".

I checked document properties and sheet properties. I dont have any OnOpen trigger which reset dates to "1-jun-2011".

Please help me to remove this selection.

Pragya,

BI Consultant

[#2]

You need to lock the date selection I susepct the clear is picking up the earliest date it has for your report

so in your trigger after setting the date you need to add an action Lock field then lock the date field so it does not clear