tag:blogger.com,1999:blog-2473156384972050726.post3880032820374305477..comments2024-03-15T00:37:18.503-07:00Comments on Vishal's blog: Ways to create Matrix report in Oracle APEXVishal Pathakhttp://www.blogger.com/profile/01850811202460421677noreply@blogger.comBlogger11125tag:blogger.com,1999:blog-2473156384972050726.post-17120553932266032912022-03-30T15:55:46.729-07:002022-03-30T15:55:46.729-07:00Hi,
How can I add the double header, as in the fi...Hi,<br /><br />How can I add the double header, as in the first image, so that it appears: "Color {Yellow, Red, Blue}, Size {Small, Medium, Large}" as an example<br /><br />Regards<br />Luis SánchezAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-2473156384972050726.post-81680820206013709202019-11-13T20:53:36.224-08:002019-11-13T20:53:36.224-08:00Hi Vishal,
PIVOT in the Apex provides MAX of thre...Hi Vishal,<br /><br />PIVOT in the Apex provides MAX of three PIVOT Columns or ROW columns or FUNCTIONS. we can not add more.<br />I have a requirement to add more than 3 PIVOT Columns, ROW columns, and FUNCTIONS. Could you please let me know if you know any custom approach.<br /><br />Thanks in Advance.<br />awaiting your response. Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2473156384972050726.post-29432649897984994602018-02-11T05:53:24.837-08:002018-02-11T05:53:24.837-08:00Check my post on reformsCheck my post on reformsVishal Pathakhttps://www.blogger.com/profile/01850811202460421677noreply@blogger.comtag:blogger.com,1999:blog-2473156384972050726.post-71092414284677877512018-02-05T07:00:38.551-08:002018-02-05T07:00:38.551-08:00Hi Vishal,
Is it possible to have a Dynamic matrix...Hi Vishal,<br />Is it possible to have a Dynamic matrix report with editable fields?<br /><br />Kindly advise.<br /><br />Thanks,<br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2473156384972050726.post-58964428431188957252014-12-11T22:49:25.194-08:002014-12-11T22:49:25.194-08:00Hi Tony,
When did you move to Virgina?
It will ...Hi Tony,<br /><br />When did you move to Virgina? <br /><br />It will help if you can create an example in apex.oracle.com. I haven't worked on APEX in the last few months. I was working on OBIEE but will definitely check it out if you can create an example.<br /><br />Regards,<br />VishalVishal Pathakhttps://www.blogger.com/profile/16879954344929617672noreply@blogger.comtag:blogger.com,1999:blog-2473156384972050726.post-5842641678042580882014-12-09T13:20:53.939-08:002014-12-09T13:20:53.939-08:00Quick question, how do you make this work for an i...Quick question, how do you make this work for an interactive report?<br /><br />Sample code will remove all the pivot built columns at development time since the substitution variable is empty..APEX Developer In the USAhttps://www.blogger.com/profile/06746962787261032815noreply@blogger.comtag:blogger.com,1999:blog-2473156384972050726.post-11653878902897471882014-12-09T08:51:39.307-08:002014-12-09T08:51:39.307-08:00Never Mind.. Had a dangling where in the select th...Never Mind.. Had a dangling where in the select that was causing an issue, now able to get multiple sums in the pivot. Looking at the final issue of the page item to hold the in list item..<br /><br />Thank you,<br /><br />Tony Miller<br />LuvMuffin Software<br />Ruckersville, VAAPEX Developer In the USAhttps://www.blogger.com/profile/06746962787261032815noreply@blogger.comtag:blogger.com,1999:blog-2473156384972050726.post-3926444381886312952014-12-08T19:05:00.765-08:002014-12-08T19:05:00.765-08:00Okay, adding a new question here.. If we wanted to...Okay, adding a new question here.. If we wanted to add a sum to the mix:<br /><br />begin<br />return 'with pivot_data as (<br /> SELECT department_id, <br /> job_id, <br /> salary,<br /> comm<br /> FROM oehr_employees<br /> )<br />SELECT *<br />FROM pivot_data<br />PIVOT (<br />SUM(salary),<br />SUM(comm)<br />FOR department_id<br />IN ('||v('P5_DEPT_LIST')||')<br />)';<br />end;<br /><br />How exactly can we get the second set of columns for each department level total of commissions?<br /><br />Thank you,<br /><br />Tony Miller<br />LuvMuffin Software<br />Ruckersville, VAAPEX Developer In the USAhttps://www.blogger.com/profile/06746962787261032815noreply@blogger.comtag:blogger.com,1999:blog-2473156384972050726.post-65034274526715894662014-06-20T10:05:43.697-07:002014-06-20T10:05:43.697-07:00I had the same error as the Texan. I found that I ...I had the same error as the Texan. I found that I had to alter the query that produced the column list in the page item, so each value was surrounded by single quotes, eg:<br /><br /><i>select ''''||listagg(department_id,''',''') WITHIN GROUP<br />(ORDER BY department_id) ||'''' from (select distinct department_id from oehr_employees);</i><br /><br />Note that I then had to strip these back out in the PL/SQL for Column Attributes.<br /><br />Oracle 11.2.0.3, Apex 4.2.2John Cantaluponoreply@blogger.comtag:blogger.com,1999:blog-2473156384972050726.post-90734032836207477232014-05-02T06:12:03.713-07:002014-05-02T06:12:03.713-07:00Hi Tony,
The code and example is there on apex.or...Hi Tony,<br /><br />The code and example is there on apex.oracle.com<br /><br />https://apex.oracle.com/pls/apex/f?p=81782:5:0:::::<br /><br />The version of the underlying db of apex.oracle.com is: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0Vishal Pathakhttps://www.blogger.com/profile/16879954344929617672noreply@blogger.comtag:blogger.com,1999:blog-2473156384972050726.post-8371641194566941572014-05-01T11:53:28.286-07:002014-05-01T11:53:28.286-07:00Trying you code to get a pivot with a page item re...Trying you code to get a pivot with a page item returns the following error:<br /><br />failed to parse SQL query:<br />ORA-56901: non-constant expression is not allowed for pivot|unpivot values<br /><br />Can you explain what version of Oracle 11g you are on?APEX Developer In the USAhttps://www.blogger.com/profile/06746962787261032815noreply@blogger.com