Hello,

I have a fex which generates the report both in HTML & Excel formats.. The report accepts input parameters through the HTML launch page and passes them to the fex upon clicking "Run Report" button on the launch page..

Some of my parameters are optional, just 1 input value is required to run the report.. I defaulted the optional variables to FOC_NONE (except the mandatory input parameter), but when I try to run the report in HTML or Excel format, the optional parameters show up with FOC_NONE written in the text box (in the fex) ...

How do I get the report to run without these optional parameters popping up on the fex?

Thanks!

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

Have you tried _FOC_NULL instead of FOC_NONE?

Tried _FOC_NULL too.. doesn't help... it still prompts for that optional variable...

Any other thoughts/ideas? Thanks!

Did you default with -DEFAULT or -DEFAULTH? -DEFAULTH will hide the prompt where -DEFAULT will still prompt the user but the the defaulted value pre-loaded.

Babak,

_FOC_NULL and FOC_NONE are the same thing. FOC_NONE is just the older version of _FOC_NULL. There are settings in the configuration to define what the ignore character is.

Nova,

You fex is probably in the "Managed Reporting" area (which is in WF7 version if your signature is good), isn't it ?

Right-click on your fex, Properties, then uncheck "Prompt for Parameters".

Using DEFAULTH worked.. Thanks Eric...

Hi Nova,

If your problems get solved, Please edit your title [SOLVED] or [CLOSED].

The problem I have with DEFAULTH is that the HTML composer with loose the fact the report even cares about them and will not pass them in. WF8008

  
-* File focnull.fex
-DEFAULTH &COUNTRY=FOC_NONE
-*DEFAULTH &COUNTRY=_FOC_NULL
TABLE FILE CAR
SUM SALES
BY COUNTRY
BY SEATS
WHERE COUNTRY EQ '&COUNTRY' AND SEATS GT 2;
END