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 you are going to love this place.

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 Apex
    • Python
  • Tags
  • Users
  • Badges & Points
  • About
Home/Questions/Q 3814
In Process
Shimul
Shimul

Shimul

  • 16 Questions
  • 21 Answers
  • 0 Best Answers
  • 113 Points
View Profile
  • 1
ShimulProfessional
Asked: November 30, 20202020-11-30T01:27:29+05:30 2020-11-30T01:27:29+05:30

Bi Publisher Report: Single query, Multiple Layouts

  • 1

In Bi Publisher Report, How can i use multiple layouts through a Single query? That means my query will be one but the layout will be Many.

apexbi publisheroracle
  • 2
  • 34
  • 0
  • 0
  • Share
    • Share on Facebook
    • Share on Twitter
Answer

    2 Answers

    1. Himul Hasan

      Himul Hasan

      • 0 Questions
      • 1 Answer
      • 0 Best Answers
      • 25 Points
      View Profile
      Himul Hasan Contributor
      2020-11-30T08:02:21+05:30Added an answer on November 30, 2020 at 8:02 am
      APEX_UTIL.GET_PRINT_DOCUMENT (
          p_report_data         IN CLOB,
          p_report_layout       IN CLOB,
          p_report_layout_type  IN VARCHAR2 default 'xsl-fo',
          p_document_format     IN VARCHAR2 default 'pdf',
          p_print_server        IN VARCHAR2 default NULL)
      RETURN BLOB;
      Try it.
      • 0
      • Share
        Share
        • Share on Facebook
        • Share on Twitter
    2. Shimul

      Shimul

      • 16 Questions
      • 21 Answers
      • 0 Best Answers
      • 113 Points
      View Profile
      Shimul Professional
      2020-11-30T11:26:47+05:30Added an answer on November 30, 2020 at 11:26 am

      Vinish Please Help me.

      • 0
      • Share
        Share
        • Share on Facebook
        • Share on Twitter

    You must login to add an answer.

    Forgot Password?

    Sidebar

    Ask Question
    Write a Post
    • Recent
    • Answers
    • Engr. SM Hasem

      How to insert item data with default IG in IG ...

      • 0 Answers
    • suriya

      how to download multiple view/table data in one excel

      • 1 Answer
    • Engr. SM Hasem

      How to add one column data to another column in ...

      • 11 Answers
    • Bheem

      What is best way to design school time table?

      • 0 Answers
    • Vinish
      Vinish added an answer Below is an example to download the CSV file using… January 25, 2021 at 12:54 pm
    • afzal
      afzal added an answer step 1--- report query like-- select EMPNO, ENAME, JOB, MGR,… January 25, 2021 at 10:14 am
    • Engr. SM Hasem
      Engr. SM Hasem added an answer Thank you so much sir. January 25, 2021 at 9:22 am
    • Vinish
      Vinish added an answer For all rows? It seems you want to compare the… January 25, 2021 at 6:19 am
    • Vinish
      Vinish added an answer Ok, then create a dynamic action on the bill month… January 25, 2021 at 6:17 am

    Recent Blog Posts

    • Vinish

      Pro*C - Connect to Oracle Database

    • Vinish

      Copy URL to Clipboard on Button Click Examples

    • Vinish

      Find When Your Mac Was Last Shutdown

    • Vinish

      Oracle SELECT Statement

    • Vinish

      Python Append List to List Example

    Explore

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

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