I having difficulty creating a simple line chart for related data in a tab panel.

 

Currently, I have a "grid" of related fields (spreadsheet style, rows/columns) in multiple tab panels.

 

Each tab panel shows a single record.

 

This is done by displaying the related fields in a portal on each tab panel, with each portal set to show only 1 row (row1 = record1, etc).  Thus, tabbing through will show one related record at a time.

 

All of this works fine until I want to use a line chart to display the same data.

 

I believe the issue is here:  The chart will allow me to display a). the current record, . the current found set, or c). related records.  In this case, the chart is inside a portal which should only be displaying a single row (record) of related data, but apparently, there's no way to tell the chart that.

 

Without creating a separate relationship for every possible related record, is there any way to have the chart display only the single record which the portal displays?

 

Thanks in advance.

sounds like you will have to build the chart separately. Use a script that is tied to an OnRecordLoad trigger.  put the X and Y data into two separate $$Variables.

then chart the table using 'Current Record (Delimited Data)'

 

Jerry

Thanks, Jerry.  Can you be more specific with this suggestion?  I don't think OnRecordLoad would work in this tab environment.  Are you suggesting I build a bunch of separate layouts to handle this?  I was trying to do it within the tabs.