Sign Up

Hey, Dev!
Are you looking for a forum full of active developers to help you?
So if you want to:
➡️ Get answers for your development issues
➡️ Help others
➡️ Write an article
➡️ Get rewarded for your active participation
Then this place is just for you and it is 100% FREE.

Have an account? Sign In


Have an account? Sign In Now

Sign In

Forgot Password?

Don't have account, Sign Up Here

Forgot Password

Lost your password? Please enter your email address. You will receive a link and will create a new password via email.

Have an account? Sign In Now

Sorry, you do not have a permission to ask a question, You must login to ask question.

Forgot Password?

Need An Account, Sign Up Here
Sign InSign Up

OrclQA.Com

OrclQA.Com Logo OrclQA.Com Logo
Search
Ask A Question

Mobile menu

Close
Ask a Question
  • Home
  • Blog
  • New Questions
  • Tutorials
    • Oracle
    • Oracle Apex
    • Python
  • Tags
  • Users
  • Badges & Points
  • About
Home/Vard/Answers
  • About
  • Questions
  • Answers
  • Best Answers
  • Posts
  • Comments
  • Followers Questions
  • Followers Answers
  • Followers Posts
  • Followers Comments
  1. Asked: February 16, 2021

    How to Generate Multi-Sheet Excel Export From Oracle APEX with Bi-Publisher

    Vard

    Vard

    • 1 Question
    • 2 Answers
    • 0 Best Answers
    • 27 Points
    View Profile
    Vard Contributor
    Added an answer on February 22, 2021 at 9:18 pm

    Hi Vinish, Thank you for the reply and looking forward to seeing your tutorial. Your tutorials and blog posts are usually very in depth and helpful! I don't have Bi-Publisher installed on my Windows. We are using Bi-Publisher that came installed by default with Oracle Cloud Control and it runs a serRead more

    Hi Vinish,

    Thank you for the reply and looking forward to seeing your tutorial. Your tutorials and blog posts are usually very in depth and helpful!

    I don't have Bi-Publisher installed on my Windows. We are using Bi-Publisher that came installed by default with Oracle Cloud Control and it runs a server that does not have MS Word installed.

    I tried to install B-Publisher locally, but the installation fails because I don't have the correct version of WebLogic Server.

    Do you know any other ways or tools I can utilized to create TRF files without the need to install Bi-Publisher.

     

    Thank you so much!

     

    Vard

    See less
    • 1
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  2. Asked: February 16, 2021

    How to Generate Multi-Sheet Excel Export From Oracle APEX with Bi-Publisher

    Vard

    Vard

    • 1 Question
    • 2 Answers
    • 0 Best Answers
    • 27 Points
    View Profile
    Vard Contributor
    Added an answer on February 18, 2021 at 9:42 pm

    Hi Vinish, Thank you for the reply. But I'm still a little confused on how to achieve this in APEX. Can I create RTF file on Microsoft Word or I need special plugin (or external program) to create one If I need my excel output in 3 different sheets in on excel spreadsheet do I need to create 3 diffeRead more

    Hi Vinish,

    Thank you for the reply.

    But I'm still a little confused on how to achieve this in APEX.

    1. Can I create RTF file on Microsoft Word or I need special plugin (or external program) to create one
    2. If I need my excel output in 3 different sheets in on excel spreadsheet do I need to create 3 different Source Queries in APEX Report Query Section
    3. Do I Need to use the RTF file in Report Layout section when I create a new layout
    4. Do I need to make any changes in APEX Report Layout xml section ( I have been using Generic Layout for the simple exports)

    I would really appreciate, if you can provide me with a simple example on how would the set up look like.

    Thank you,

    Vard

     

    See less
    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter

Sidebar

Ask Question
Write a Post
  • Recent
  • Answers
  • GudDud

    Load PDF into APEX, Edit it and Print it.

    • 0 Answers
  • AnuK

    Error: Ajax call returned server error ORA-00932: inconsistent datatypes: expected ...

    • 0 Answers
  • pavlos

    How to reduce space between two Display Image items?

    • 1 Answer
  • Bheem

    Scrollable News with thumbnail

    • 0 Answers
  • Vinish
    Vinish added an answer You can reduce the number of column span for the… March 4, 2021 at 7:53 am
  • Abdulkareem
    Abdulkareem added an answer Below query is working fine SELECT city,name FROM JSON_TABLE ('[{"city":"Stockholm","name":"Lennart… March 3, 2021 at 6:16 pm
  • Vinish
    Vinish added an answer Below is the correct query: SELECT city, name FROM JSON_TABLE… March 3, 2021 at 9:18 am
  • Bheem
    Bheem added an answer Got the answer. Thank you March 3, 2021 at 9:07 am
  • afzal
    afzal added an answer STEP -1 CREATE REPORT LIKE-- select SAL AS "SALARY", NVL(COMM,0)… March 2, 2021 at 10:25 am

Recent Blog Posts

  • Vinish

    Oracle Apex - Display External File in Region

  • Vinish

    Oracle PL/SQL Download BLOB File to Disk

  • Vinish

    Oracle Convert External File to BLOB

  • Vinish

    Oracle Apex Calendar Example

  • Vinish

    Oracle Apex - Open Modal Dialog Page Using JavaScript

Explore

  • Home
  • Blog
  • New Questions
  • Tutorials
    • Oracle
    • Oracle Apex
    • Python
  • Tags
  • Users
  • Badges & Points
  • About

© 2021 OrclQA.Com. All Rights Reserved. Privacy Policy