Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Active Dashboard: Default dropdown-list value for coordinated reports

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Active Dashboard: Default dropdown-list value for coordinated reports
 Login/Join
 
Silver Member
posted
Hello,

I have an Active HTML Dashboard comprised of many separate AHTML reports that are coordinated together and bound by a common BY field that appears at the top of the dashboard in the form of a dropdown list.

My question is: Where do I specify the default value for this list? I'm assuming that

-DEFAULT &FIELDNAME = 'All';


is my solution, but I don't know whether to use that statement in the Active Dashboard fex or if I have to insert that statement into each component report that's on the dashboard.

Any thoughts as to where to use that statement, or another solution altogether, would be appreciated...thanks!


sleepy




WebFOCUS (DEV and PROD): DevStudio 7.6.10 HF2 Servlet - MRE/Dashboard/Self Service/Report Caster - MS Windows XP SP2 - IIS & Apache - MS SQL 2005
Output: HTML (Internet Explorer 7), Excel 2003, PDF, Active Reports and FLEX
 
Posts: 38 | Location: Detroit, MI | Registered: September 23, 2008Report This Post
Expert
posted Hide Post
Sleepy,

It depends upon how those components are actioned. If they are includes then one occurnece in the parent fex would satisfy. However, if they are called individually within an HTML page using javascript to change the SRC attribute of an IFRAME or something of that ilk, then your need is to place it within each fex individually.

T



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
 
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004Report This Post
Silver Member
posted Hide Post
Tony,

Thanks for the reply! I agree that since each report is referenced by the parent (Active Dashboard) fex with an '-INCLUDE' line, I should be able to just use one -DEFAULT statement in the parent fex. Unfortunately, I have to say that this approach as well as using that statement in each component report did not work.

Instead of specifying the value in the dropdown list on the Active Dashboard, it brought up the built-in IB parameter page (with 'All' as the parameter value) before displaying the dashboard. Once I clicked the Run button, the dashboard loaded but the outcome was the same as before...the dropdown list still defaulted to the first value instead of 'All'.

Here is a screenshot showing the outcome of adding the -DEFAULT &ACTIVITYDESC = 'All'; line to the parent fex:



and here is the code to the parent fex:

-* File oprevactivedashboard
-* Default Mode: ResourceLayout
SET HTMLARCHIVE=ON
COMPOUND LAYOUT PCHOLD FORMAT AHTML
UNITS=IN, $
SECTION=section1, LAYOUT=ON, METADATA='0.5^0.5^0.5^0.5', MERGE=AUTO, ORIENTATION=LANDSCAPE, PAGESIZE=A3,  $
PAGELAYOUT=1, NAME='Summary', text='Summary', TOC-LEVEL=1, BOTTOMMARGIN=0.5, TOPMARGIN=0.5, METADATA='BOTTOMMARGIN=0.5,TOPMARGIN=0.5,LEFTMARGIN=0,RIGHTMARGIN=0,', $
COMPONENT='report1', TEXT='report1', TOC-LEVEL=2, POSITION=(0.259 0.677), DIMENSION=(5.240 3.824), METADATA='Z-INDEX: 100; LEFT: 0.259in; OVERFLOW: auto; WIDTH: 5.24in; POSITION: absolute; TOP: 0.677in; HEIGHT: 3.824in', $
COMPONENT='report2', TEXT='report2', TOC-LEVEL=2, POSITION=(5.722 0.677), DIMENSION=(5.240 3.824), METADATA='Z-INDEX: 101; LEFT: 5.722in; OVERFLOW: auto; WIDTH: 5.24in; POSITION: absolute; TOP: 0.677in; HEIGHT: 3.824in', $
COMPONENT='report3', TEXT='report3', TOC-LEVEL=2, POSITION=(11.115 0.656), DIMENSION=(5.091 3.838), METADATA='Z-INDEX: 100; LEFT: 11.115in; OVERFLOW: auto; WIDTH: 5.091in; POSITION: absolute; TOP: 0.656in; HEIGHT: 3.838in', $
COMPONENT='report4', TEXT='report4', TOC-LEVEL=2, POSITION=(0.238 4.604), DIMENSION=(15.968 3.957), METADATA='Z-INDEX: 100; LEFT: 0.238in; OVERFLOW: auto; WIDTH: 15.968in; POSITION: absolute; TOP: 4.604in; HEIGHT: 3.957in', $
PAGELAYOUT=2, NAME='HelpDesk', text='HelpDesk', TOC-LEVEL=1, BOTTOMMARGIN=0.5, TOPMARGIN=0.5, METADATA='BOTTOMMARGIN=0.5,TOPMARGIN=0.5,LEFTMARGIN=0,RIGHTMARGIN=0,', $
COMPONENT='report8', TEXT='report8', TOC-LEVEL=2, POSITION=(0.445 2.989), DIMENSION=(3.114 1.514), METADATA='Z-INDEX: 100; LEFT: 0.445in; OVERFLOW: auto; WIDTH: 3.114in; POSITION: absolute; TOP: 2.989in; HEIGHT: 1.514in', $
COMPONENT='report7', TEXT='report7', TOC-LEVEL=2, POSITION=(0.459 1.284), DIMENSION=(3.114 1.514), METADATA='Z-INDEX: 100; LEFT: 0.459in; OVERFLOW: auto; WIDTH: 3.114in; POSITION: absolute; TOP: 1.284in; HEIGHT: 1.514in', $
COMPONENT='report10', TEXT='report10', TOC-LEVEL=2, POSITION=(4.427 1.260), DIMENSION=(5.370 1.563), METADATA='Z-INDEX: 100; LEFT: 4.427in; OVERFLOW: auto; WIDTH: 5.37in; POSITION: absolute; TOP: 1.26in; HEIGHT: 1.563in', $
COMPONENT='report11', TEXT='report11', TOC-LEVEL=2, POSITION=(4.427 2.958), DIMENSION=(5.385 3.438), METADATA='Z-INDEX: 100; LEFT: 4.427in; OVERFLOW: auto; WIDTH: 5.385in; POSITION: absolute; TOP: 2.958in; HEIGHT: 3.438in', $
COMPONENT='report12', TEXT='report12', TOC-LEVEL=2, POSITION=(9.938 1.240), DIMENSION=(6.295 5.177), METADATA='Z-INDEX: 100; LEFT: 9.938in; OVERFLOW: auto; WIDTH: 6.295in; POSITION: absolute; TOP: 1.24in; HEIGHT: 5.177in', $
OBJECT=STRING, NAME='text1', TEXT='All HelpDesk Calls:', POSITION=(8.510 0.667), MARKUP=OFF, WRAP=ON, DIMENSION=(2.313 0.292),  color=RGB(0 0 0), style=bold, size=18, METADATA='', $
OBJECT=STRING, NAME='text4', TEXT='Last 30 Days:', POSITION=(0.917 0.677), MARKUP=OFF, WRAP=ON, DIMENSION=(1.938 0.354),  color=RGB(0 0 0), style=bold, size=18, METADATA='', $
OBJECT=BOX, NAME='line2', POSITION=(3.969 0.281), DIMENSION=(0.094 7.031), BACKCOLOR=BLACK, BORDER-COLOR=BLACK, METADATA='FONT-SIZE: 1pt; Z-INDEX: 100; LEFT: 3.969in; WIDTH: 0.094in; POSITION: absolute; TOP: 0.281in; HEIGHT: 7.031in; BACKGROUND-COLOR: black', $
PAGELAYOUT=3, NAME='Time Mgt', text='Time Mgt', TOC-LEVEL=1, BOTTOMMARGIN=0.5, TOPMARGIN=0.5, METADATA='BOTTOMMARGIN=0.5,TOPMARGIN=0.5,LEFTMARGIN=0,RIGHTMARGIN=0,', $
COMPONENT='report9', TEXT='report7', TOC-LEVEL=2, POSITION=(0.302 2.646), DIMENSION=(3.874 4.171), METADATA='Z-INDEX: 103; LEFT: 0.302in; OVERFLOW: auto; WIDTH: 3.874in; POSITION: absolute; TOP: 2.646in; HEIGHT: 4.171in', $
COMPONENT='report13', TEXT='report13', TOC-LEVEL=2, POSITION=(0.281 0.740), DIMENSION=(3.885 1.445), METADATA='Z-INDEX: 100; LEFT: 0.281in; OVERFLOW: auto; WIDTH: 3.885in; POSITION: absolute; TOP: 0.74in; HEIGHT: 1.445in', $
COMPONENT='report14', TEXT='report14', TOC-LEVEL=2, POSITION=(4.729 0.740), DIMENSION=(4.913 4.061), METADATA='Z-INDEX: 100; LEFT: 4.729in; OVERFLOW: auto; WIDTH: 4.913in; POSITION: absolute; TOP: 0.74in; HEIGHT: 4.061in', $
END
SET COMPONENT='report1'
-*component_type report
-INCLUDE projects-hrstodatevsestgraph.fex
SET COMPONENT='report2'
-*component_type report
-INCLUDE timemgt-hoursbycat-piegraph.fex
SET COMPONENT='report3'
-*component_type report
-INCLUDE timemgt-hoursbytype-piegraph.fex
SET COMPONENT='report4'
-*component_type report
-INCLUDE helpdesk-totalcalltrend.fex
SET COMPONENT='report8'
-*component_type report
-INCLUDE helpdesk-totalcallscreated-last30days.fex
SET COMPONENT='report7'
-*component_type report
-INCLUDE helpdesk-totalcallsclosed-last30days.fex
SET COMPONENT='report10'
-*component_type report
-INCLUDE helpdesk-allactivecalls.fex
SET COMPONENT='report11'
-*component_type report
-INCLUDE helpdesk-totalcalls-bycaller-sql.fex
SET COMPONENT='report12'
-*component_type report
-INCLUDE helpdesk-allactivecalls-byapp.fex
SET COMPONENT='report9'
-*component_type report
-INCLUDE timemgt-hoursbyapplication.fex
SET COMPONENT='report13'
-*component_type report
-INCLUDE timemgt-totalhoursbyfunction.fex
SET COMPONENT='report14'
-*component_type report
-INCLUDE timemgt-emptimebyfunction.fex
COMPOUND END



sleepy




WebFOCUS (DEV and PROD): DevStudio 7.6.10 HF2 Servlet - MRE/Dashboard/Self Service/Report Caster - MS Windows XP SP2 - IIS & Apache - MS SQL 2005
Output: HTML (Internet Explorer 7), Excel 2003, PDF, Active Reports and FLEX
 
Posts: 38 | Location: Detroit, MI | Registered: September 23, 2008Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Active Dashboard: Default dropdown-list value for coordinated reports

Copyright © 1996-2020 Information Builders