Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Passing values to drill down report from chart

gkthomasMar 26 2019 — edited Mar 27 2019

There are wonderful personalities here helping us and I am very thankful to each one of them. I am creating a pie chart region which is based on a value selection from a select list. Basically the chart is

status of the workload and its counts for each assigned users. The assigned users will selected from the select list. For each users selected the chart will display the statuses and its count such failed 2 , completed 10, open 5 etc.

This part works fine. Now I have to drill down the Chart Status to a detail report . For that purpose I have to pass the Label( in this case status) and the select list value which is selected .

On the chart link section i used one parameter as #label and the 2nd parameter &P13_ASSIGNED_USER. to drill down page. But with drill down page I get strange results .

P17_STATUS --- #label

P17_ASSINGED_USER -- &P13_ASSIGEND_USER. The page 17 is the drill down report page where I have to use values as parameters to the correct results. But when I click the link , in the drill down page, in P17_STATUS field i get the half of the user name instead of label

any idea why is it happening ? can someone please help

See the images , The status supposed to be Failed . but it shows user name. My database version is racle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production. Oracle apex 4.2.6

apex_img1.pngapex_img2.pngapex_img3.png

Comments
Post Details
Added on Mar 26 2019
1 comment
950 views