QV11.2 - Workaround for Sheet Object Event Triggers

[john_duffy]

Hello All.

We are currently on QV10 SR2 and upgrading to QV11.2 SR3.

A few of our applications have sheets that contain pie charts along with corresponding straight tables.  When a user selects a pie chart, the corresponding straight table is also displayed and visa versa.  If a different pie chart is selected, the original pie chart and straight table are minimized and the new pair is displayed.  I am accomplishing this with Sheet Object Event Triggers.

These triggers have been removed in QV11.2.

Any ideas on how I can automatically minimize and maximze pair of objects in QV11.2?

Note that my users want to see both the pie and straight table displayed on the sheet at the same time.  They do not want to user a fast change icon to toggle between the two objects.

Thanks,

John.

[sudeepkm]

you may use two containers with grid mode and use auto minimize option on both the containers. So that when user double clicks on the minimized container then the other one appears showing the pair of PIE chart and St Table and vice versa.

[Anonymous]

John,

You can cover a pie chart (maybe only its caption) with a transparent text box, and use text box actions.

Does it work for you?

Regards,

Michael

[john_duffy]

Hi Sudeep.

Thanks for the quick response.  I was hoping to find a way to keep the application working as is, however, your suggestion keeps the application's display very similar.

One question - I defined the container object with one column and two rows so that the pie chart displays on top of the straight table.  The staight table has the layout option Size to Data enabled, however, the chart does not size to data inside the Container object.  Is this simply the way the container object works?

Thanks again,

John.

[john_duffy]

Hi Michael.

Thank you for the quick response.

This is a good idea.  The only issue I have is that on each sheet I have 12 pairs of pie chart/straight table combinations.

Therefore, for each pair I would have to create a text box with an action to restore a pie chart, restore a straight table and 22 other actions to minimize all other pie charts and straight tables.  Do you see a way around this?

Thanks again,

John.

[Anonymous · Accepted solution]

I'm thinkning about a different approach.

Create a list box as a logical island with meaningful values corrsponding to your pei/table pairs.  Bring it on the sheet, make one values always selected.  Conditionally show each pie/table according to the selected value in the island.

I think it is rather pinless and relaible, no actions needed.

Regards,

Michael

[john_duffy]

That will work perfect.

I use this technique in several other applications.  Got caught up trying to use the event triggers.

Thanks for your help Michael.