tag:blogger.com,1999:blog-2132893136140848212.post3958484316107909559..comments2023-09-09T03:03:30.219-06:00Comments on Martin Giffy D'Souza on Oracle APEX: Custom Download for APEX Interactive ReportsMartin D'Souzahttp://www.blogger.com/profile/06992954599899886499noreply@blogger.comBlogger35125tag:blogger.com,1999:blog-2132893136140848212.post-49056240324902794292016-02-15T11:18:17.879-07:002016-02-15T11:18:17.879-07:00Try APEX_IR.GET_REPORT https://docs.oracle.com/cd/...Try APEX_IR.GET_REPORT https://docs.oracle.com/cd/E59726_01/doc.50/e39149/apex_ir.htm#AEAPI29379 to get the query.Martin D'Souzahttps://www.blogger.com/profile/06992954599899886499noreply@blogger.comtag:blogger.com,1999:blog-2132893136140848212.post-5302935337306851152016-02-10T17:45:41.073-07:002016-02-10T17:45:41.073-07:00I have a question... I am trying to centralize thi...I have a question... I am trying to centralize this type of accessing apex_application_page_ir into one schema... <br />So idea is setup a package that would bring the query from the IR in X schema.<br />And then, in Y schema, make a call to the package that is setup in X schema.<br />My attempt gave null result, it seems apex_application_page_ir depends on the "current" schema from which you are accessing the data... so, is there a workaround for this? <br />thanks!Jorgelinahttps://www.blogger.com/profile/07824593781275440873noreply@blogger.comtag:blogger.com,1999:blog-2132893136140848212.post-49877957712352604462015-06-05T07:42:02.305-06:002015-06-05T07:42:02.305-06:00Actions > Download > HTMLActions > Download > HTMLMartin D'Souzahttps://www.blogger.com/profile/06992954599899886499noreply@blogger.comtag:blogger.com,1999:blog-2132893136140848212.post-52297414493815943222015-06-04T17:04:24.053-06:002015-06-04T17:04:24.053-06:00Hi Martin,
Is there any to Convert IR report to HT...Hi Martin,<br />Is there any to Convert IR report to HTML with all the Actions.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2132893136140848212.post-87706859560282111782015-02-25T03:04:03.767-07:002015-02-25T03:04:03.767-07:00Hi Martin,
I am using APEX 4.1.1.00.23.
Thank yo...Hi Martin,<br /><br />I am using APEX 4.1.1.00.23.<br /><br />Thank youAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-2132893136140848212.post-9986541877760721232015-02-24T08:23:49.617-07:002015-02-24T08:23:49.617-07:00What version of APEX are you using. This is a very...What version of APEX are you using. This is a very old post for APEX 3.2Martin D'Souzahttps://www.blogger.com/profile/06992954599899886499noreply@blogger.comtag:blogger.com,1999:blog-2132893136140848212.post-35293518641525713032015-02-24T03:46:55.267-07:002015-02-24T03:46:55.267-07:00Hi Martin,
I have try to access the IR sql using ...Hi Martin,<br /><br />I have try to access the IR sql using the below code. Btt i am not able to get the same. Getting the error message as -"ORA-20001: NO_WORKSHEET_FOUND"<br /><br />Please let me know where the below code is incorrect. <br /><br />I have grant the WWV_FLOW_WORKSHEET and created the synonyms for my schema.<br /><br />select ir_rpt.base_report_id, ir.interactive_report_id ,ir.region_id<br /> into l_base_report_id, l_report_id,l_region_id<br /> from apex_application_page_regions reg,<br /> apex_application_page_ir_rpt ir_rpt,<br /> apex_application_page_ir ir<br /> where reg.application_id = p_app_id<br /> AND reg.page_id = p_page_id<br /> and reg.source_type = 'Interactive Report'<br /> AND REG.REGION_ID = IR.REGION_ID<br /> and reg.application_id = ir.application_id <br /> and reg.page_id = ir.page_id<br /> and ir.interactive_report_id = ir_rpt.interactive_report_id<br /> and ir_rpt.session_id = v('SESSION');<br /> <br /> L_QUERY := WWV_FLOW_WORKSHEET.GET_WORKSHEET_REPORT_QUERY (P_WORKSHEET_ID => L_REPORT_ID,<br /> p_app_user => v('APP_USER'),<br /> p_report_id => l_base_report_id );<br /> Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2132893136140848212.post-17212093674882795942014-04-16T07:30:01.738-06:002014-04-16T07:30:01.738-06:00Hi Saurabh,
For custom templates you'll need ...Hi Saurabh,<br /><br />For custom templates you'll need to use a report engine of some sort. They're several options available for APEX.<br /><br />MartinMartin D'Souzahttps://www.blogger.com/profile/06992954599899886499noreply@blogger.comtag:blogger.com,1999:blog-2132893136140848212.post-64304592701516122862014-04-16T04:44:32.694-06:002014-04-16T04:44:32.694-06:00Hi Martin ,
I have to decide wether to use APEx ...Hi Martin , <br /><br />I have to decide wether to use APEx for below reporting Requirement.<br />Is it possible to in APEX to download report as per a predefined CSV template ?<br />I want to have Header information(for the values of user parameters) before the report begins and actual data is displayed<br /><br />Please let me know. <br /><br />Thanks and Regards<br />SaurabhAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-2132893136140848212.post-85660695904329030682013-01-27T21:54:43.807-07:002013-01-27T21:54:43.807-07:00Unfortunately CSV doesn't store meta data such...Unfortunately CSV doesn't store meta data such as row colors. You'll need to look at a print server option to download to excel.Martin D'Souzahttps://www.blogger.com/profile/06992954599899886499noreply@blogger.comtag:blogger.com,1999:blog-2132893136140848212.post-15449193093119014772013-01-25T07:45:08.315-07:002013-01-25T07:45:08.315-07:00Hey,
I used your code and have now a csv with css...Hey,<br /><br />I used your code and have now a csv with css and so on.<br />So I have the layout the user has made.<br />But how can you see now this layout ?<br />When you open the csv ist only text but no colors or something of the layout.<br /><br />Greetz<br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2132893136140848212.post-36605671976682571312012-03-22T21:23:16.693-06:002012-03-22T21:23:16.693-06:00Thank you for this post, exactly what I needed to ...Thank you for this post, exactly what I needed to fix my report download!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2132893136140848212.post-27512832789634908012010-02-26T02:07:35.027-07:002010-02-26T02:07:35.027-07:00Hi Martin,
Thanks for your comment. I am running ...Hi Martin,<br /><br />Thanks for your comment. I am running apex 3.2.1.00.10. I am using IR's download. But now I fix problem with HTP.prn() function.<br /><br />Best regards<br />E.Enkh-AmgalanEnkh-Amgalanhttps://www.blogger.com/profile/00138573517159899961noreply@blogger.comtag:blogger.com,1999:blog-2132893136140848212.post-2673676986057782762010-02-11T20:51:21.596-07:002010-02-11T20:51:21.596-07:00Hi E.Enkh-Amgalan,
It could be 2 things. What ver...Hi E.Enkh-Amgalan,<br /><br />It could be 2 things. What version of APEX are you running? Did you also open your csv file in a notepad editor? <br /><br />I just did a test: <a href="http://apex.oracle.com/pls/apex/f?p=20195:3000" rel="nofollow">http://apex.oracle.com/pls/apex/f?p=20195:3000</a> and this returned 66536 rows (1 thousand more than your limit). I know Excel 2003 had a limit on the number of rows in a spread sheet.Martin D'Souzahttps://www.blogger.com/profile/06992954599899886499noreply@blogger.comtag:blogger.com,1999:blog-2132893136140848212.post-27233912662870204392010-02-09T03:14:51.723-07:002010-02-09T03:14:51.723-07:00You can download an other package for Excel export...You can <a href="http://progkor.inf.elte.hu/APEX/README.html" rel="nofollow">download</a> an other package for Excel export of interactive reports.<br /><br />AlbertAlberthttps://www.blogger.com/profile/11517955915545298341noreply@blogger.comtag:blogger.com,1999:blog-2132893136140848212.post-12634443899157824962010-02-04T20:53:26.441-07:002010-02-04T20:53:26.441-07:00Hello Martin,
I am atemping to download more than...Hello Martin,<br /><br />I am atemping to download more than 65536 records on interactive report.<br />It download only lower than 65536 records.<br /><br />How can i do that?<br /><br />Best regards<br />E.Enkh-AmgalanEnkh-Amgalanhttps://www.blogger.com/profile/00138573517159899961noreply@blogger.comtag:blogger.com,1999:blog-2132893136140848212.post-50986996749853172752009-12-03T07:15:10.555-07:002009-12-03T07:15:10.555-07:00This comment has been removed by a blog administrator.Custom Paper Writinghttp://www.researchpaperspot.com/noreply@blogger.comtag:blogger.com,1999:blog-2132893136140848212.post-81278420244693513022009-09-24T08:03:00.936-06:002009-09-24T08:03:00.936-06:00Hi Stijn,
apex_application_page_ir will give you ...Hi Stijn,<br /><br />apex_application_page_ir will give you the SQL of the IR that you entered. When the user modifies an IR (removes a column, applies a filter etc) the query is changed.<br /><br />As for the wwv_flow_conditions, I use it to determine if the user can view the column or not. I get the condition from the dictionary views then apply it to a process in wwv_flow_conditions.<br /><br />MartinMartin D'Souzahttps://www.blogger.com/profile/06992954599899886499noreply@blogger.comtag:blogger.com,1999:blog-2132893136140848212.post-19449787907844551102009-09-24T01:13:07.410-06:002009-09-24T01:13:07.410-06:00Hi Martin
I used apex_application_page_ir to retr...Hi Martin<br /><br />I used apex_application_page_ir to retrieve the ir sql query.<br /><br />To retrieve the conditions i used apex_application_page_ir_cond and apex_application_page_ir_rpt.<br /><br />I think you can avoid using wwv_flow_conditions and wwv_flow_worksheet by using those 3 views. Although my code doesn't check if a user is allowed to view a column because that wasn't necessary in the case I needed it.<br /><br />I'm gonna have a deeper look at you're code, when I have the time, so I can expand/improve my code.<br /><br />Greets<br />StijnStijnnoreply@blogger.comtag:blogger.com,1999:blog-2132893136140848212.post-64474265389961794452009-09-23T08:13:09.158-06:002009-09-23T08:13:09.158-06:00Hi Danny,
You can get the base report id using th...Hi Danny,<br /><br />You can get the base report id using the JavaScript function: $v('apexir_REPORT_ID')<br /><br />Hope this helps,<br /><br />MartinMartin D'Souzahttps://www.blogger.com/profile/06992954599899886499noreply@blogger.comtag:blogger.com,1999:blog-2132893136140848212.post-58418405920608685852009-09-23T08:11:18.388-06:002009-09-23T08:11:18.388-06:00Hi Stijn,
It is possible to write similar code wi...Hi Stijn,<br /><br />It is possible to write similar code without the grant statements but I don't know if it will cover everything. Here's an outline of why I required the grants.<br /><br />wwv_flow_worksheet_standard: You could make your own datatypes if you wanted to so not necessarily required<br />wwv_flow_conditions: Used to determine if the user is allowed to view a column<br />wwv_flow_worksheet: Used to get the SQL that the user is currently looking at (wwv_flow_worksheet.get_worksheet_report_query) as well as the column attributes (wwv_flow_worksheet.get_all_column_attributes)<br />wwv_flow_render_query: Used to generate the CSV file. You could write your own code to do this so this isn't required.<br /><br />Can you please let me know how you enabled this functionality without the grants? I was hesitant to use the grants and synonyms so I'd like to avoid that if possible.<br /><br />Thank you,<br /><br />MartinMartin D'Souzahttps://www.blogger.com/profile/06992954599899886499noreply@blogger.comtag:blogger.com,1999:blog-2132893136140848212.post-6747239338041532092009-09-23T06:18:53.415-06:002009-09-23T06:18:53.415-06:00Why do you need all those grants?
I wrote a simula...Why do you need all those grants?<br />I wrote a simular code(a bit less extended) on the apex dictionary views, without having to need any grants.<br /><br />GreetzStijnnoreply@blogger.comtag:blogger.com,1999:blog-2132893136140848212.post-70117270808054929342009-09-15T09:24:43.558-06:002009-09-15T09:24:43.558-06:00I am trying to determine the report ID that a user...I am trying to determine the report ID that a user is looking at when they click on a link in and IR. The reason is that I want to populate an item with the report ID so that when they click the back button on the browser to get back to the IR, they will be on the same saved report that they were on before clicking the link. Is this possible?Dannynoreply@blogger.comtag:blogger.com,1999:blog-2132893136140848212.post-71723103698533674932009-06-14T08:02:13.033-06:002009-06-14T08:02:13.033-06:00Hi Thomas,
Excellent job on your IR download tool...Hi Thomas,<br /><br />Excellent job on your IR download tool! Thanks for the info on the HTP.FLUSH function.<br /><br />MartinMartin D'Souzahttps://www.blogger.com/profile/06992954599899886499noreply@blogger.comtag:blogger.com,1999:blog-2132893136140848212.post-51888714682989293822009-06-12T07:58:30.835-06:002009-06-12T07:58:30.835-06:00Hi,
I have create a custom download procedure for...Hi,<br /><br />I have create a custom download procedure for regular and IR reports. It includes the computed columns, highlights, sorts etc.<br /><br />Since we use OpenOffice in our company it has to the Excel and CSV also an OpenOffice export function.<br /><br />I went a different road then you. Instead of using the internal function to retrieve the SQL I build it myself.<br /><br />I also do not use the regular HTP.P feature - I do with the BLOB download. I found that you can compress the BLOB easier then HTP buffer. We often have files > 20 Megs - with a 80%+ compression this saves a lot of time.<br /><br />About the css in the header of your CSV - you can call the HTP.FLUSH function to clear the page buffer after its filled. That way you can write your CSV into a empty buffer. <br /><br />If you are interessted you can check our my code at www.tbe2001.com.<br /><br />Pop me an e-mail if you like it.<br /><br />Best Regards<br />ThomasThomashttp://www.tbe2001.comnoreply@blogger.com