Monday, December 13, 2010

Column Groups in APEX 4.0 Interactive Reports

A long time ago I wrote about adding Column Groups to Interactive Reports (IR) in APEX: http://www.talkapex.com/2009/03/column-groups-in-apex-interactive.html I created a new dynamic action plugin to do column grouping in APEX which can be downloaded here. Please read the help text in the plugin for full instructions on how to use it. Once integrated it should look like:


I also added additional JS debugging information. If you run your application in debug mode and look at the console you'll notice the following log information:


The additional logging is using the console logger wrapper that wrote: http://www.talkapex.com/2010/08/javascript-console-logger.html If you're writing your own plugins I suggest using it to instrument your code. It helped me debug some of my JavaScript issues while developing this plugin.

18 comments:

  1. Martin,

    Great plug-in, keep them coming!

    Regards,
    Dan

    ReplyDelete
  2. Hi Martin,

    One question: Assume a 8 column report. I assign only column 3 and 4 to group A and column 5 and 6 to Group B. So columns 1,2,7 and 8 are "unassigned" the group heading seems to shift (not properly positioned). Maybe you can confirm that - and fix it, heheheh ;-)

    Cheers,
    Roel

    ReplyDelete
  3. Hi Roel,

    Thanks for pointing out the bug. I've fixed it and uploaded v1.0.1

    ReplyDelete
  4. And now it works like a charm!
    Thanks for the good work.
    And, oooh, I love this plugin stuff...

    ReplyDelete
  5. Hi Martin,
    I found another strange "feature": if you uncheck all the "Allow Users To:" values for a column...it doesn't work anymore. If you check one of them - and it doesn't seem to matter which one - it works..
    Roel

    ReplyDelete
  6. Work Only IR?!?!
    Is possible for standard report?

    ReplyDelete
  7. Hi N@lt,

    You could do this with a standard report but you'd need some where to define column groups and link them to each column. This is not impossible, just requires some standards.

    Once you have defined your column groups you can modify the plugin to reference the new list of groups.

    Martin

    ReplyDelete
  8. Dear,
    i have download the plugin, but can not find the help text file
    how can i implement it ?
    Regards

    ReplyDelete
  9. Hi Martin,

    Thanks for the good work!
    If i use the plugin en use a "break" the column groups are not working anymore. Is this a bug?

    Kees

    ReplyDelete
    Replies
    1. Hi Kees,

      Yes this is a known bug. I've added this to my list and will hopefully get a fix out soon.

      Martin

      Delete
  10. Hi Martin, thankis for you work. I need new column group, now my columns have a group1 and group2; but i need grouping the column that in group1 and group2, like this.
    ------HILA----------- -> is that i need
    me tin acb mex mnv
    kg kg cant cant kg

    Thanks

    ReplyDelete
  11. Hi,

    Thanks, Can you please let me know why grouping is gone when you try to download as excel, or try to email it.

    Thanks
    Sunil Bhatia

    ReplyDelete
    Replies
    1. i agree sunil its not working when you download into excel or pdf ,so do you have another posible way

      Delete
    2. yes you are right sunil its not working when you download it into excel or pdf do you have any other posible solution

      Delete
  12. It's not a built in functionality of APEX. If you want it included you'll need to use a custom print server.

    ReplyDelete
  13. Hi Martin,

    Will this be updated to work with APEX 5?

    ReplyDelete
    Replies
    1. I know someone is working on an APEX 5 update of the plugin. If you follow the #orclapex hashtag on Twitter you'll know when it's released.

      Delete