This content has been marked as final. Show 4 replies
Here's an example: http://apex.oracle.com/pls/apex/f?p=41871:3 Dever Ima9Dever
It uses the selection List variable (:P3_SL_SYS_NIC_NM) in a chart series label (EMPNO || '-' || :P3_SL_SYS_NIC_NM) -
So you can see the A, B, C or D in the label on the "X" axis toward the bottom of the chart.
SELECT NULL LINK, EMPNO || '-' || :P3_SL_SYS_NIC_NM LABEL, SAL "Employee Salary" FROM EMP
But there is a "wrinkle" you may not want. There is a Dynamic Action, so when the Select List changes, the page is submitted and the chart updates with the new label values. There's no usefulness here, I was just trying to show what could be done.
Please look again. The username and password are there.
Also, but what about my query that generates the already made report? Won't I have to make changes to that query?
If your report already references the Select List variable, I'd think it ought to be working. But I have seen -- in my own code -- where the Select List variable was there on the screen staring me in the face but it was "NULL" to the session and to my code that was checking for it. Or it was the value from last time around. Make sure that your "Source" definition for the Select List variable has Source Used:"Always, replacing any existing value in session state," and Source Type: "Static assignment" and make the "Source value expression" is "&<select-list-variable-name>." (period!) This worked for me.
And I'm not familiar with the syntax --> ||'-'||. Isn't that used to concatenate two items/columns?That's just PL/SQL string concatentation. I'm putting a dash between the employee number and the letter selected.
It seems to me that you are almost there if you have a select list in your region already then you would just need to update the where clause of your report query.
lets assume that your select list has the item name :P3_CAT
you would just change your query to something like
when you submit the change to the select list the page will update with the new where clause.
select col1, col2, col3 from sometable where col3 = :P3_CAT
Edited by: Roadling on Jan 16, 2013 9:44 PM