Blogs. (YABAOAE) Yet Another Blog About Oracle Application Express. Denes Kubicek ApEx BLOG. Roels Blog. Replacing Anychart 3 with Anychart 4 Charts. With the current APEX version you can create nice looking Charts using Anycharts 3. The charts you create with Interactive Reports use Anycharts 4. These charts look better than the regular ones, and we - my colleague Rutger and I - started to investigate the options for enhancing the regular charts. Of course we could wait for APEX 4.0 or go for Anycharts 5, using the Anychart Integration Kit, but we love a quick and more cost neutral (as in 'free') solution... So let's go:Create a simple chart using the "SELECT NULL LINK, ENAME LABEL, SAL VALUE FROM EMP ORDER BY ENAME" query. To and twice - once in the Now replace the standard Chart XML with the very minimal setting of: <anychart><settings><animation enabled="True"/></settings><charts><chart use_anychart3_data_model="true" >#DATA#</chart></charts></anychart> Especially the use_anychart3_data_model="true" is important - as APEX generates Anychart 3 type XML.
Update (20/5): The #1085 Error was caused by a wrong "FlashVars" parameter. Blogger Status. Installation. Der Oracle APEX Experten Blog. Group Headings in an Interactive Report (APEX) Did you ever wanted a group heading above your column headings in an Interactive Report in APEX? I wondered why that wasn't already included in APEX, as all components are there to get it to work. Let's create a little example to show what I mean. Create an Interactive Report on the emp table (for ex. select * from emp). In your Interactive Report details there's a section Column Groups where you can define groups.But it also says: "Column Groups are used to group columns together on the single row view. " Next we need to edit the group to say which columns belong to which group.In my example I specified that the columns Empno and Ename belong to Group 1. If you run the page you'll see this IR (without group headings) But when you select the single row view (the Edit icon in front of the row) you'll see this: So you can see the groups nicely in the single row view but it's not there in the normal report...
Feel free to try it in your own environment and give some feedback.