Hello,
Basically I have a report that as part of it's source sql takes in an element from a select list.
E.G. SELECT * FROM table_name WHERE table_column = : P1_SELECTLIST
This works fine when the user selects an option from the select list however the first time the page runs it always returns data not found.
The options correctly appear in the select list as they should without any nulls although it seems the select list is still initializing as null.
I have been told to try and add a computation before the header on the select list item, although I'm not sure if this would work/how to do this.
Any suggestions?