The search is not working in the drop down menu in Data set BU publisher report
I have this parameter that is related to a list of value that give all the contract number.
the query i am using for the list of value is:
select DISTINCT
TV.CONTRACT_NUMBER AS "Contract_Number"
FROM
PJB_XLA_REV_V TV
when i use the search option in the parameter and type one of the value that are already given in the drop down and then type search it gives me no data found.
and does anyone know how to make the parameter not related to each other, example in this report it is forcing me to fill all the paremeters in order to get data.
Tagged:
0