I have a requirement of adding the drop down filters in the report. I add them using TOC feature of webfocus where it creates a separate drop down list for each required BY field. The drop downs are created succesfully by adding the TOC command in the header code. But I need to remove that View Entire Report & Table Of Contents options which occurs at the end of the drop down list.
I just need the values of the field to be loaded in the drop downs. Can you please let me know If there's an option to do this? The output format is HTML.
Your quick repsonses will be helped.This message has been edited. Last edited by: Ranjana,
7.1.4 Windows XP Excel, HTML, PDF
January 12, 2009, 11:16 AM
dhagen
There doesn't appear to be an option for this request ... at least nothing I can find. You could remove those options from the drop down after report rendering by using the SET JSURL= setting to include your own JS file. This JS would then reduce the length of the combo box by 2. It might be a little tricky, but it should work.
Scratch that.
Step 1: Create a javascript file called /apps/baseapp/js/removeTocOptions.js with the following content:
toctreeNode.defaultArray = new Array();
Step 2: Add the following line to your focexec:
SET JSURL=/approot/baseapp/js/removeTocOptions.js
That should be enough.This message has been edited. Last edited by: dhagen,
"There is no limit to what you can achieve ... if you don’t care who gets the credit." Roger Abbott
January 15, 2009, 04:09 AM
Ranjana
hi Dhagen, I tried creating a .fex file in which I mentioned the below code. <script> toctreeNode.defaultArray = new Array();
In the foc exec, I mentioned the path which is below. SET JSURL=/apps/webfocus/adhoc/ibi/tgtapps/baseapp/removetocoptions.fex
But this didnt work, I still see those options. As the .js files cant be created in the webfocus environment, I thought of this. I can see the files only with .html or .fex format.
Do you think this works only for .js files? Or just the <script> tag in a .fex file will do.
7.1.4 Windows XP Excel, HTML, PDF
January 15, 2009, 11:05 AM
dhagen
quote:
Originally posted by Ranjana: Do you think this works only for .js files?
Yes
"There is no limit to what you can achieve ... if you don’t care who gets the credit." Roger Abbott