OnClick event for a table?

[#1]

We have a requirement to provide onclick event for every row on a table.. The table has summary information for all clients. When a user clicks on a particular client, it should navigate to a different tab which has all charts/pivots for a single client. I was thinking of writing a macro for OnSelect at a field level and then check if the event originated from the first tab... and then just navigate to other tab.. but is there a better way to handle such cases?

Appreciate your help..

[jedgson]

If I have understood your requirements correctly then you should be able to do this using the 'Show Sheet' 'Conditional' of the 'General' tabl of the sheet properties.

On the sheet that has the summary information you would use a condition like count( Distinct Client) > 1, then when you select an individual client the sheet will be hidden.

Now on the other sheets that hold the individual clilent reports you could have a condition like Client = 'ClientName', then when 'ClientName' is selected that sheet will show.

Repeat this step on all other individual client sheets.

Jay

[nagaiank]

See if you can take some clues from the attached example of header-detail display with the logic that the detail table is displayed only when one row is selected in the header table.

The header table can be a listbox with expressions or a tablebox. The detail table can be a group of charts giving the details of the header row selected. The detail charts can be on the same sheet or other sheets.

Hope this helps.

[#4]

thank you both for your replies...

Since there are too many client related charts, we thought of dedicating a seperate tab for it and then navigate there when a single client is selected from the summary table..