Oracle APEX Report Development Using Standard Functionality

This video will show you how to develop like Purchase Order/Invoices etc reports without using any plugin or XML Publisher.
Sample code can be copied from the following link,
erpstuff.com/v...
#APEX #REPORT #ORACLE

[@arunbhandari361]

Hi sir I'm working in a same profile as a oracle apex devloper ... It's really helpful please make it more content on this things..... appreciate your work ...God bless you

[@ERPstuff]

You are welcome and sure will try our best. Thanks

[@dewdrop4804]

Very Helpful Tutorial for Me... Waiting for next one.. Jajakallah...

[@ERPstuff]

You are welcome. thanks

[@JorgeSoler]

Excelent, greate video!!! thank you

[@ERPstuff]

Glad you liked it!

[@MrBandhuraj]

Thanks for the demo, Great work and teaching. question window.print() works fine however I wanted to save PDF into a blob, how would you do that.

[@iqbalsetiawan7558]

Thank you for sharing this. This is make us love apex and oracle in general. Hope you can make more videos like this (APEX DEV TIPS).

[@ERPstuff]

Thanks for the feedback and for future videos please subscribe to the channel.

[@realtalk3216]

thank you sir for this amazing walk through, is it possible to add company logo and description in the header as well as heading of purchase order and also to insert system date in the footer. it would really be grateful.

[@ERPstuff]

Dear try this way kzbin.info/www/bejne/nGmpm3SAjNJ9mNU

[@ar13147]

hi sir i m facing a problem is that "window.print()" command just print a one page if my report has 2 pages then it is not show 2nd page. please help.

[@ERPstuff]

kzbin.info/www/bejne/nGmpm3SAjNJ9mNU

[@ahmedrashed5567]

thanks do much - but when loop for details come more one page it just print only one page - hope if there's help - thank you again

[@ERPstuff]

You are right as this limitation is there while you can try this solution kzbin.info/www/bejne/nGmpm3SAjNJ9mNU

[@masifqadri12]

Zabardast

[@ERPstuff]

Welcome

[@muhammadkamranriaz3918]

Thanks for Sharing! Really You've explain everything nicely. but one thing i want know more that you've missed here which is how can i display page number if I've multiple pages to printout. Thanks in advance.

[@ERPstuff]

Hi, Had tried and raised this matter to Oracle support but was no solution available. May be if someone found any tweak can share. Thanks

[@bhavinadhvaryu8549]

Great Stuff...! Very nice tutorial...! Can you please share the sample data?

[@ERPstuff]

Dear the script to create tables is there in the following URL while data you can insert as per your own inputs, www.erpstuff.com/forums/viewtopic.php?f=48&t=10906

[@juno7893]

Interesting. I’ll definitely try this.

[@burjisazrael4164]

Great video. Very well explained.

[@ERPstuff]

You are welcome. Thanks

[@varshahr3174]

Nice video, well explained... I tried your code and it's working fine but when the loop contains more number of rows it is not initiating the next page to print. kindly help me...Thanks in advance

[@ERPstuff]

True it was not supporting and even raised to Oracle support they were of no gain. Once any solution available will share. Thanks

[@MitraRSingh]

Good day Sir, great content and very informative, however the link you provided for the sample source code isn't working. It says unavailable, can you assist attaining the source code please? Thanks

[@ERPstuff]

Hi Mitra, sorry for inconvenience you can try now. Thanks

[@MitraRSingh]

@@ERPstuff Hi sir, the link is working, thanks. But I am getting an error in my coding...is there an email I can contact you on, this way I can show you the error and explain?

[@ERPstuff]

@@MitraRSingh [e-mail]

[@tdmrco4155]

Thanks :)

[@ERPstuff]

Welcome

[@iisdw5033]

Thanks for share

[@ERPstuff]

you are welcome...

[@wisalkhan2381]

Thanks Sir for knowledge sharing. But Sir can you tell about po_header_id? Because I tried your code and it's working perfectly but not picking the parameter po_header_id item value. Without po_header_id my report display all the product information but I want the specific report the one I clicked. Kindly tell me about the parameter po_header_id. Thanks.

[@ERPstuff]

Dear welcome try to create sample at apex.oracle.com and share details at [e-mail] Thanks

[@ghulambutt]

Very informative video. I have prepared a report but when I see the pdf, it includes the button as Print. Also, I see some small text on the bottom of the page. Is there any way I can print a clean report with the text / table I want to see or print on the reprt?

[@ERPstuff]

I think these are browser settings try and let me know if resolved. Thanks

[@ghulambutt]

@@ERPstuff I dont see any browser settings about this. Please help

[@ERPstuff]

Like in chrome click on print and you will see setting on right side under more settings else if you can share anydesk please right an email at [e-mail]

[@belalahmad84]

I have a problem can you help me please i did html report like you did but the problem is the data is more than one page when i try to print it , it appear only the first page have you solve for that ??

[@ERPstuff]

kzbin.info/www/bejne/nGmpm3SAjNJ9mNU

[@ERPstuff]

Please try this as html output having this issue. Thanks

[@yeasinopu451]

Thanks.

[@NaeemAlsaadi]

very good

[@dattamanees2900]

Sir its very good video if you please share pl/sql code file it very helpfull thanks

[@ERPstuff]

Dear please check the link below the video. thanks

[@musman85]

Thanks

[@fabulman90]

Thanks...

[@ERPstuff]

You are welcome

[@bulbulahmed3098]

Great !

[@ERPstuff]

Welcome and thanks

[@niazact]

Keep It Up Good One

[@tesyimer6339]

can you please advise me how to get the HTML script, thanks

[@ERPstuff]

Please check description of the video link will be there. thanks

[@tesyimer6339]

the script for this video. thanks

[@ERPstuff]

Please check description of the video link will be there. thanks