Formatted Reports (Commercial Invoice) in Oracle APEX - Part 34

In this video, you'll learn how to create formatted Invoices in Oracle APEX using BI Publisher and Microsoft Word RTF.
Topics Covered in this video
====================================================
- Commercial Invoice
- Create Report Query
- Design report layout in Microsoft Word using XML data
- Data grouping and sorting
- Formatting reports using standard Microsoft Word tools
- Add conditional formatting to display data differently in the same report
- Add calculations
- Create parameterized report
- Upload RTF layout to APEX
- Attach custom report layout to the default report query
- Add link in the application to run advance reports
Download Source Code From Here:-
drive.google.com/drive/folder...
The content of this video is taken from my book "Create Rapid Low-Code Web Applications in Oracle APEX"
www.amazon.com/Create-Rapid-L...
Completely Free Oracle APEX Course
==============================
• Free Oracle APEX Course

[@sandeepreddy9929]

Hi, thanks for detailed explanation. I want to display multi level XML data like header, line, subline .. one header contains multiple lines, one line contains multiple sublines. How can we achieve this in the report query

[@ahmedharoon2740]

great... it solved my big problem, the step-by-step approach is an excellent approach to teach, i am enjoying learning this way. i was thinking modifying & using custom template within Apex, now it is super easy man. i love to use it. please help us creating with more ideas, more complex reports. regards

[@TechMining69]

Glad it helped!

[@sulemanmasood1382]

friend but i have a problem BI printer not set on my localhost

[@arunbhandari361]

I have same requirement but i have 23.1 version and when i call the url through button its giving error..URL probited i think its not supporting in latest version

[@faisalusmani9063]

can we design template as xls as excel instead of word please help

[@safiullah6167]

when I go to \Shared Components\Report Queries to create Report Query there is a message that "Report Queries are not supported. Native printing is configured for this application. A Remote Print Server is required to use Report Queries." Please help ...

[@user-zg1xr9qh5m]

i tried my best to run bi report but got report server error. please sir how can i configure report server for BI report

[@masifqadri12]

how to print page number if one order is printed on multiple pages like 1/4, ,2/4 aslo if multiple orders printed we have to intialize page number

[@TechMining69]

Page numbers are not usually printed on invoices. This is just for demonstration purposes. However, as a workaround you can print invoices individually that span multiple page.

[@emilioo5349]

Awesome!, thanks. By any chance, how to generate same report or another one but with Barcode or QR on it?

[@TechMining69]

In near future, we will upload a tutorial on QR code. Please share the details of your requirements.

[@emilioo5349]

@@TechMining69 basically I want to add a barcode or QR code to a pdf/word file from a report output, it could be a single page report or tabular one. Currently I have reports or regions inside the Apex app that can create QR/Barcode using JavaScript libraries

[@Maddzz8209]

When i click test print report, i get an http error, is there any solution? Ps: i use apex desktop version on windows 10

[@TechMining69]

For local APEX you need BI Publisher Server. It is better to test this tutorial on the online APEX version that already has BI Publisher Server.

[@nnnn_ee_family]

Respected Sir, I am using the same method as you are telling but when I print the page is blank no data.

[@TechMining69]

Share your workspace credentials with oratech69 gmail account.

[@mundova184]

Hi. Thank you, is downloading BI Publisher desktop free?

[@TechMining69]

Yes, it is. But you need to create an account on Oracle's site.

[@mundova184]

@@TechMining69 Thank you, I already have an account on oracle's site.

[@safiullah6167]

is it possible to use Reports 10g with oracle 21c for report development and deployment?

[@marceloosorio525]

Forms & Reports are past....