tag:blogger.com,1999:blog-21122514.post5076772504888022163..comments2024-03-23T11:05:13.046+01:00Comments on Dimitri Gielis Blog (Oracle Application Express - APEX): Group Headings in an Interactive Report (APEX)Dimitri Gielishttp://www.blogger.com/profile/16295721159626839167noreply@blogger.comBlogger10125tag:blogger.com,1999:blog-21122514.post-50344670203055730932017-09-08T11:08:45.786+02:002017-09-08T11:08:45.786+02:00Nice Blog Post !Nice Blog Post !Used PC Distributorhttp://www.electrocw.com/noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-28597666247086739882012-09-03T11:47:43.006+02:002012-09-03T11:47:43.006+02:00Hi Andy,
You would need to create a procedure tha...Hi Andy,<br /><br />You would need to create a procedure that generates the correct csv then. APEX itself or my blog post won't handle that.<br /><br />Thanks,<br />DimitriDimitri Gielishttps://www.blogger.com/profile/16295721159626839167noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-75671790564256151862012-09-03T10:19:50.868+02:002012-09-03T10:19:50.868+02:00Dimitri,
Is it possible to download the report as...Dimitri,<br /><br />Is it possible to download the report as CSV with the column groups?<br />I have made a IR with column groups but when I print it only the IR columns show but now the group.<br /><br />Regards <br />AndyAndynoreply@blogger.comtag:blogger.com,1999:blog-21122514.post-48284530027863645372012-08-02T13:52:27.724+02:002012-08-02T13:52:27.724+02:00Yeah it was Excellent, I was looking for this tech...Yeah it was Excellent, I was looking for this techique....<br />I can't access your application, Please provide credentials for this technique as soon as possible.<br /><br />Thanks in Advance.<br /><br />Regards,<br />ShaliniAnonymoushttps://www.blogger.com/profile/11709443428296193051noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-19870578841542194662012-08-02T13:38:27.784+02:002012-08-02T13:38:27.784+02:00Yeah it was Excellent, I was looking for this tech...Yeah it was Excellent, I was looking for this techique....<br />I can't access your application, Please provide credentials for this technique as soon as possible.<br /><br />Thanks in Advance.<br /><br />Regards,<br />ShaliniAnonymoushttps://www.blogger.com/profile/11709443428296193051noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-64813193044926204672009-03-26T15:38:00.000+01:002009-03-26T15:38:00.000+01:00Thanks for posting the solution! I've posted the u...Thanks for posting the solution! I've posted the updated code <A HREF="http://apex-smb.blogspot.com/2009/03/column-groups-in-apex-interactive.html" REL="nofollow">here</A>Martin D'Souzahttps://www.blogger.com/profile/06992954599899886499noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-32649857210075974532009-03-26T12:55:00.000+01:002009-03-26T12:55:00.000+01:00This is nicely done and I could see some good uses...This is nicely done and I could see some good uses for it.<BR/><BR/>Somewhat off-topic, the thing I <B>don't</B> like about the groups is the way they display the group name next to the column names in a column drop-down list, for example when you use Select Columns. <BR/><BR/>They look like:<BR/><BR/> My Column (Group name)<BR/><BR/>We wanted to group long list of columns in the drop-downs in my current application, but the users said this looked "too geeky" (their words). So I ended up adding dummy column names like:<BR/><BR/>--------- Group name --------<BR/><BR/>to organize the columns. That seems very lame to me, but it works.<BR/><BR/>I wish Apex would add support for including the group names in the drop-down lists in this sort of form, maybe even allowing bolding of the group names.<BR/><BR/>Maybe this will give you an idea for a cool-new add-on?<BR/><BR/>Thanks for listening,<BR/><BR/>StewStewhttps://www.blogger.com/profile/05177922393895344852noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-74124585872670143162009-03-05T16:01:00.000+01:002009-03-05T16:01:00.000+01:00Dimitri, I'm running version 3.1.2.00.02 of Apex a...Dimitri, <BR/><BR/>I'm running version 3.1.2.00.02 of Apex and there is no l_LastFunction available on the apex.worksheet.ws object. Is there an equivalent function that I can use? Is there any documentation available for apex.worksheet.ws stuff? Without the l_LastFunction I can still use your code but it will fail to prepend the group heading when the AJAX driven report refreshes selective parts of itself.ninohttps://www.blogger.com/profile/13082461509715181593noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-45230209136155971172008-11-21T17:20:00.000+01:002008-11-21T17:20:00.000+01:00Dimitri, There is a flaw in the way you've done th...Dimitri, <BR/><BR/>There is a flaw in the way you've done this whereby if you close the Column Selection box and then re-open it, the Group Headings get included Again at the top of the report. <BR/><BR/>Each time you open and close the column selection dialog the group headings get added. You might want to add some kind of identifier you can check for to see if the group row already exists and only add it if it does not.Doug Gaulthttps://www.blogger.com/profile/16786329323466667017noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-29456324571039975112008-11-21T14:24:00.000+01:002008-11-21T14:24:00.000+01:00Excellent Dimitri. I was looking for just such a ...Excellent Dimitri. I was looking for just such a fix a few weeks ago. I'll definitely try it on my site (although my vacation takes precedence!). Originally, I kept playing with the column groupings not realizing at the time that they only applied to the single row view.<BR/><BR/>I've found a fair amount of benefit to extending APEX with JavaScript such as enabling and disabling dependent fields without having to do a submit, calling Ajax database calls when a field value is changed, etc.<BR/><BR/>Rgds/Mark M.Mark M.https://www.blogger.com/profile/16857319998291373026noreply@blogger.com