detaching an object from another object in a sheet

[#1]

hi

i have created a sheet in my report and in that sheet i have used multiboxes,pivot tables etc. i have used a pivot table to create a calender. multibox has been used as a selection box for the user to select various parameters of the reports. now whenever a user selects a parameter from the multibox the calender automatically gets activeted and only active values are shown in the calender.

i want it to remain in its original size and shape even after a selection is made. how can i achieve that???

[adhudson]

Hi,

     Try to uncheck the Size to Data option in the properties of that object.

     Hope this helps.

Regards

Andrew Hudson

[#3]

Hi Andrew

thnx for your help....if i uncheck the size to data its not solving my problem..it maintains the actual size of the object but the excluded values gets disappeared....