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.
Posted by at
Labels: ,

18 comments:

  1. Dan McGhanDecember 13, 2010 at 7:51 PM

    Martin,

    Great plug-in, keep them coming!

    Regards,
    Dan

    ReplyDelete
  2. Christian Rokitta ♠December 15, 2010 at 2:47 AM

    Cool!

    ReplyDelete
  3. RoelDecember 15, 2010 at 5:34 AM

    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
  4. Martin D'SouzaDecember 15, 2010 at 8:10 PM

    Hi Roel,

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

    ReplyDelete
  5. RoelDecember 16, 2010 at 2:23 AM

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

    ReplyDelete
  6. RoelFebruary 1, 2011 at 8:14 AM

    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
  7. N@LTFebruary 18, 2011 at 5:51 AM

    Work Only IR?!?!
    Is possible for standard report?

    ReplyDelete
  8. Martin D'SouzaFebruary 18, 2011 at 7:39 AM

    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
  9. AnonymousOctober 19, 2011 at 11:18 PM

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

    ReplyDelete
  10. UnknownApril 13, 2012 at 4:28 AM

    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. Martin D'SouzaApril 13, 2012 at 7:59 AM

      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
  11. UnknownAugust 27, 2012 at 3:32 PM

    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
  12. Sunil BhatiaApril 14, 2014 at 4:55 AM

    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. UnknownJanuary 25, 2016 at 10:12 PM

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

      Delete
    2. UnknownJanuary 25, 2016 at 10:14 PM

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

      Delete
  13. Martin D'SouzaApril 14, 2014 at 5:37 AM

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

    ReplyDelete
  14. UnknownSeptember 18, 2015 at 11:45 AM

    Hi Martin,

    Will this be updated to work with APEX 5?

    ReplyDelete
    Replies
    1. Martin D'SouzaOctober 17, 2015 at 3:26 PM

      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

Subscribe to: Post Comments (Atom)