Focal Point
[SOLVED]Task to refresh a subreport from a chart

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/1217041286

May 02, 2016, 08:34 AM
rajje
[SOLVED]Task to refresh a subreport from a chart
I have a chart (with multiple series) and a report on a HTML page. Using the GUI in AppStudio, I am trying to figure out a way to add a "task" so that when a user clicks on one of the chart series, the report is updated based on the series data passed from the chart. Essentially, I am trying to do the following, but using the GUI without having to write any code.

TYPE=DATA,
COLUMN=N2,
TARGET='chart2',
FOCEXEC=tek_portal_ops_sub_oa_details_table.fex( \
REGCD = '®CD' \
-* OPUCD = PAR_OFF_NUM \
),
$

This message has been edited. Last edited by: rajje,


WebFOCUS 8.x, Windows, HTML/PDF
May 03, 2016, 09:46 AM
GavinL
quote:
TYPE=DATA,
COLUMN=N2,
TARGET='chart2',
FOCEXEC=tek_portal_ops_sub_oa_details_table.fex( \
REGCD = '®CD' \
-* OPUCD = PAR_OFF_NUM \
),
$



Try this instead as it reloads what ever params are already being passed:
TYPE=DATA,
COLUMN=N2,
TARGET='chart2',
JAVASCRIPT=location.reload(),
$




- FOCUS Man, just FOCUS!
-----------------------------
Product: WebFOCUS
Version: 8.1.04
Server: Windows 2008 Server
May 04, 2016, 09:18 AM
rajje
Thanks for the code. I still need to figure out how to do this using the GUI - we are trying to use the GUI more and most of our old content doesn't open in AppStudio.


WebFOCUS 8.x, Windows, HTML/PDF
May 04, 2016, 03:42 PM
GavinL
I don't know.. It didn't take me long to figure out the UI didn't cover all that I needed. It's a basic template. I suggest learning the code. Makes life a lot easier.



- FOCUS Man, just FOCUS!
-----------------------------
Product: WebFOCUS
Version: 8.1.04
Server: Windows 2008 Server