You can instruct Managed Reporting to not process single lines or blocks of code using the -MRNOEDIT tag.
To instruct Managed Reporting to not process code, use the following:
For a single line of code:
For multiple lines of code:
-MRNOEDIT BEGINfocexec_code -MRNOEDIT END
Note: Both lowercase and uppercase syntax are supported for the -MRNOEDIT tag. The focexec_code must fit on the same line.
The syntax above is not part of the FOCUS language. It is used only by Managed Reporting.
Managed Reporting will not process the lines when evaluating the Managed Reporting procedure prior to sending it to the Reporting Server. The lines of code will be passed without the -MRNOEDIT tags to the Reporting Server.
By design, amper variables specified within the -MRNOEDIT tags are resolved by Managed Reporting. You should uncheck the procedure property, Prompt for Parameters, if you do not want to be prompted for parameter values when:
Both lowercase and uppercase syntax are supported for the -MRNOEDIT tag.
-MRNOEDIT -INCLUDE salesrptstyle.sty
Managed Reporting ignores the -INCLUDE salesrptstyle.sty command. Without the -MRNOEDIT tag, this would result in retrieval of the FOCEXEC from the WebFOCUS Repository. In this case, the -INCLUDE is resolved on the Reporting Server. Therefore, salesrptstyle.sty should reside on the path of the Reporting Server.
TABLE FILE GGSALES "Regional Inventory and Profit Report" SUM BUDUNITS UNITS INVENTORY AS 'Inventory' BUDDOLLARS DOLLARS PROFIT AS 'Profit' BY REGION BY CATEGORY -MRNOEDIT -INCLUDE salesrptstyle.sty END