You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How can I configure "All" prompts in BI Publisher



Summary:


Content (please ensure you mask any confidential information):

I have a report with some parameters, I would like them to come with the default value "All" and, if necessary, this search to be refined.

My SQL code is as follows for the parameters:

-- PARAMETROS
AND (:P_LIVRO IS NULL OR GL.NAME IN :P_LIVRO)
AND (:P_CONTA IS NULL OR GCC.SEGMENT6 IN :P_CONTA)
AND (:P_FILIAL IS NULL OR GCC.SEGMENT2 IN :P_FILIAL)
AND (:P_DIVISAO IS NULL OR GCC.SEGMENT3 IN :P_DIVISAO)
AND (:P_NEGOCIO IS NULL OR GCC.SEGMENT4 IN :P_NEGOCIO)

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!