Focal Point
[CLOSED] ReportCaster and dynamic includes

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

January 29, 2014, 04:09 PM
Martin vK
[CLOSED] ReportCaster and dynamic includes
In several procedures we use dynamic includes which are created during execution, e.g.

FILEDEF dynamic_defines DISK dynamic_defines.ftm
-RUN
TABLE FILE XYZ
..
ON TABLE HOLD AS dynamic_defines FORMAT DFIX DELIMITER ' ' HEADER NO
END
-RUN

DEFINE FILE &FCT_TABLE ADD
-INCLUDE dynamic_defines
END

Works like magic for several purposes, but when using this procedure in ReportCaster and using the Advanced button to provide Parameter values I get the error "WebFOCUS Reporting Server procedure cannot be found".
This is probably because ReportCaster parses the procedure plus all includes for Parameters (amper variables) and can not open the includes that are dynamically created, because they are ony there during execution.

I know there is a workaround to temporarily comment out the include, or I should maybe create empty procedures for all those dynamic ones somewhere in the path.

I am however wondering if there is somewhere a setting to tell ReportCaster to ignore (not to parse) includes that are not present.

I also have the strange situation that I do get this error message in our Development system, but not in our Production system. I our production system I can schedule these procedures and enter Parameter values through the Advanced button without this error. So I wonder if there is some setting. I checked several places but could not find.
Or might it be due to different versions. In our Production system we use ReportCaster version 7703 (gen 182), and in the Development system 7705 (gen 55).

This message has been edited. Last edited by: <Kathryn Henning>,


WebFocus 8206M, iWay DataMigrator, Windows, DB2 Windows V10.5, MS SQL Server, Azure SQL, Hyperstage, ReportCaster
January 29, 2014, 05:02 PM
j.gross
If the issue is as you suspect, a work-around would be to encapsulate the -INCLUDE ...
-SET &include= '-INCLUDE dynamic_defines' ;

DEFINE FILE &FCT_TABLE ADD
&include.EVAL
END

...so it acts as a -INCLUDE at run time, but does not look like one to the parser.


- Jack Gross
WF through 8.1.05
January 30, 2014, 10:52 AM
Doug
Have you checked to ensure that the properties of these procedures are the same (especially the Prompt For Parameters) in both test and production? If they're not then adjust accordingly.
January 31, 2014, 05:01 AM
Martin vK
Jack,
Thanks for you suggested work-around.
quote:
-SET &include= '-INCLUDE dynamic_defines' ;


I like it because it not only helps with this specific problem but helps me also to prevent to get too many parameters in ReportCaster. Now I get a long list with many amper variables used somewhere in some include and the user needs to find the correct parameters to set.
What I will do is make a kind of pre-processing procedure with -DEFAULT for only those parameters that I want to be visible in ReportCaster for the user to set, and then &include the original procedure.

Doug,
Thanks for the suggestion. I did check but the Parameter Prompting setting in the Admin Console (ibif_wfdescribe) is OFF in both development and production system.
I checked several other settings (visually) and they also appear to be the same.
Do you (or someone else) have other settings I might need to check?

Martin.


WebFocus 8206M, iWay DataMigrator, Windows, DB2 Windows V10.5, MS SQL Server, Azure SQL, Hyperstage, ReportCaster
January 31, 2014, 10:52 AM
njsden
quote:
Now I get a long list with many amper variables used somewhere in some include and the user needs to find the correct parameters to set.


Have you tried default them with -DEFAULTH instead? That "H" means those variables are "hidden" from client tools so no parameters are prompted for them. This is valid when building HTML Composer launch pages and I assume a similar behaviour when setting parameters in ReportCaster but haven't tested it myself.



Prod/Dev: WF Server 8008/Win 2008 - WF Client 8008/Win 2008 - Dev. Studio: 8008/Windows 7 - DBMS: Oracle 11g Rel 2
Test: Dev. Studio 8008 /Windows 7 (Local) Output:HTML, EXL2K.