BI Publisher for word: For each group spacing issue — Oracle Analytics

Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

BI Publisher for word: For each group spacing issue

Received Response
358
Views
3
Comments
Jmunoz
Jmunoz Rank 2 - Community Beginner
in Oracle Analytics Cloud and Server

Summary

BI Publisher for word: For each group spacing issue

Content

I am using the For-each group property for a report with if conditions for each paragraph and it seems that whenever I print out to pdf that there is a bunch of white space between each paragraph. The goal is to eliminate the white space and have the paragraphs print the next line. I've tried editing the Word properties, putting it in a table and nothing has made a difference. I'm leaning on the idea that this is a BI pub issue with xsl and was wondering if there are any way to do this or at least some alternatives to eliminate as much white space as possible.

This is what i have now on the report. Note the outlining of the table.

<?choose?> for-each<?if:C.PLAN_TYPE=10?>

Health Insurance

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

<?end if?><?end for-each-group?> <?end choose?>

<?choose?>for-each<?if:C.PLAN_TYPE=11?>

Dental Insurance

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

<?end if?><?end for-each-group?><?end choose?>

Answers

  • Youssef_B_82
    Youssef_B_82 Rank 5 - Community Champion

    Hi,

    Have you tried to toggle the "Show or hide formatting marks" ON/OFF on you .rtf file? This way you can turn on or off some or all formatting symbols and marks.

    Delete all useless formatting marks if applicable, example: the pilcrow sign (¶) indicates that it will skip to next line, if you have many for no reason, try removing them and test again.

    Regards,

    Youssef

  • timdexter
    timdexter Rank 6 - Analytics Lead

    Ensure all your report code ie anything contained in <? ?> is inside a gray formfield.As someone wlse has mentioned you can use simple if statements rather than a choose to speed up the report. You would have something like

    <?for-each:ROW?><?if:C.PLAN_TYPE=10?>

    Health Insurance

    xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

    <?end if?><?if:C.PLAN_TYPE=11?>

    Dental Insurance

    xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

    <?end if?><?end for-each-group?>

    Put each command in a formfield and have them on the same line. At runtime the formatter will collapse the lines with formfields in them.

    Tim

  • Venkat Thota - BIP
    Venkat Thota - BIP Rank 7 - Analytics Coach

    Why you are using multiple choose conditions ? you can use simple if conditions after and before for each group. https://blogs.oracle.com/xmlpublisher/conditional-templates