Oracle Analytics Cloud and Server

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

Text size becoming too small when image cell has both image and text

Received Response
131
Views
14
Comments

Summary

Text size becoming too small when image cell has both image and text

Content

I have a report in which a column has cells that have both image and text. The text size is getting too small and not visible(1px) when images are present. I have used the same definition for pdf xslfo and it is working fine.

XSLFO has FO_TABLE_CELL
inside FO_TABLE_CELL we are creating FO_BLOCK

inside FO_BLOCK we have FO_INLINE

inside FO_INLINE First we insert image then text(order may vary according to alignment required)

I have attached a sample use case. The second row should contain the image followed by the number 2. But it is becoming too small to be visible

«1

Answers

  • Brajesh Shukla-95078
    Brajesh Shukla-95078 Rank 7 - Analytics Coach

    Can you upload your XSL file? It may calling some template for look and size

  • Anish Pr
    Anish Pr Rank 4 - Community Specialist

    This is the XSL

  • Anish Pr
    Anish Pr Rank 4 - Community Specialist

    This is the XML DATA

    <?xml version="1.0" encoding="utf-8"?>

    <Root>

    <Report id='101771'>

    <Row>

    <item0 style="Ex1;ExImg1">

    <![CDATA[1]]>

    </item0>

    </Row>

    <Row>

    <item0 style="Ex1;ExImg1">

    <![CDATA[2]]>

    </item0>

    </Row>

    <ExImg1>iVBORw0KGgoAAAANSUhEUgAAABQAAAAUCAYAAACNiR0NAAACX0lEQVQ4T6VUPUhyYRR+rqkVCA4OSiQoDrqImwSOQo0OzjqENOQmDiI0CCIEgi4qCoKDm4FjIbgELkJQm6sYYTQpmvl3jXO+7/VTs/ygA9d77/F9n/d5znnOlWRZXmAjotEoEokEJEnCYrGARqPBYDDYXLb2rlAoJEpI2wD5D0mCUqnEdDqFQqFApVKB1+tFuVyGz+fjg8SBtH4noEqlwmw24037+/sYjUZwu92o1+vMLJPJIBgM8jOtkejnO4Yulws2mw3FYpE33N/fo1qtIpVK8bvJZMLz8zMfKOJHhuFwGMlk8kvNer0etFotMyIFdNDJycluhq+vrzAYDLi9vcVkMoHH4+GarUYoFEI6nV7ml5IXfwKFQgHn5+fo9/vQ6XS8lySp1WrIsrwGKJqxel8DvLy8RDabZRCqX6PRwOHhId7f31mOCMFS5PL5PC4uLtYlE735fM4WoW5SM56enrC3t4fhcMi5VUACu76+RiQSwcPDAwKBACwWC25ubrZ3+fHxEQ6HgwEpqJvHx8f8TNJF1Go1nJ6e8it50+/3bwe02+3odrt4e3tjQ5NMusiHpIIOErUV4Dt9SEBXV1eIxWI4OjrCy8vL8k4gVIbxeLxkuxOQ2FBTRPFXx0x4kEZS5P9Oy/eT8vHxgXg8zpfT6USz2WQ2RqMRnU7ni+F3MiTJogGijq1WC1ardSvYfzE0m81cO2oCSTs7O8Pd3d2aLwlIyP7x40ALS6USS83lcryJGAsrbY7hVsmiATTDNMsUer0eBwcHaLfbS/usTs6q4Zdfmy9F+WXi36D+Ekhs/wSRhlAksFxe6AAAAABJRU5ErkJggg==</ExImg1>

    </Report>

    </Root>

    and this is the particular row

    <Row>

    <item0 style="Ex1;ExImg1">

    <![CDATA[2]]>

    </item0>

    </Row>

  • Brajesh Shukla-95078
    Brajesh Shukla-95078 Rank 7 - Analytics Coach

    Are you facing issue in Both Case-1 and Case-2?

    In Case-1 : Image and text both are inside <fo:inline> where attribute set  is applied.

    In Case-2: Image is outside of <fo:inline> so there is no attribute set .

    Attribute sets are responsible for passion, fonts etc.

  • Brajesh Shukla-95078
    Brajesh Shukla-95078 Rank 7 - Analytics Coach

    Here seems to be issue

    Case 1 : XSL which you shared before

    Here image and text both are under <fo:inline and attribute set is ="Ex1_101771"  which is 9 pt

    <fo:inline height="9.0pt" white-space-collapse="false" xsl:use-attribute-sets="Ex1_101771">

    <xsl:value-of select=".//item0" xdofo:field-name="item0"/>

    <fo:instream-foreign-object content-height="10pt" content-type="image/png" content-width="10pt">

    <xsl:value-of select="//Report[@id='101771']//ExImg1"/>

    </fo:instream-foreign-object>

    </fo:inline>

    Case 2 : XSL which you shared after

    Here image is outside <fo:inline where attribute set is applied. That is why I feel problem is coming

    <fo:instream-foreign-object content-height="10pt" content-type="image/png" content-width="10pt">

    <xsl:value-of select="//Report[@id='101771']//ExImg1"/>

    </fo:instream-foreign-object>

    <fo:inline height="9.0pt" white-space-collapse="false" xsl:use-attribute-sets="Ex1_101771">

    <xsl:value-of select=".//item0" xdofo:field-name="item0"/>

    </fo:inline>

  • Brajesh Shukla-95078
    Brajesh Shukla-95078 Rank 7 - Analytics Coach

    Hi,

    Can I understand? whenever we are printing image we print item0 as well.

    That always print before the image...but the example which you shared image is appearing first than number.  So are we using same xsl which you shared?

    <xsl:value-of select=".//item0" xdofo:field-name="item0"/>

    <fo:instream-foreign-object content-height="10pt" content-type="image/png" content-width="10pt">

    <xsl:value-of select="//Report[@id='101771']//ExImg1"/>

    </fo:instream-foreign-object>

  • Brajesh Shukla-95078
    Brajesh Shukla-95078 Rank 7 - Analytics Coach

    Sorry my mistake...I ran as pdf...you have already mentioned its working fine with PDF

  • Brajesh Shukla-95078
    Brajesh Shukla-95078 Rank 7 - Analytics Coach

    Hi,

    I ran the xsl with the xml data provided...output looks good for me. Number 2 is appearing in same font size?

    Also I have seen all the attribute set declare on the top of xsl almost all the places font size is 9pt

    image

  • Brajesh Shukla-95078
    Brajesh Shukla-95078 Rank 7 - Analytics Coach

    Thank you...could you please upload the Sample XML data as well. You can choose-when condition so its difficult to find out with table row is getting printed for line 2.

  • Anish Pr
    Anish Pr Rank 4 - Community Specialist

    yes the same issue is there for images regardless of case 1 or case 2. Yes xsl:use-attribute-sets="Ex1_101771" is meant for text font size and style. and this is what is required in case of font in this case

    <xsl:attribute-set name="Ex1_101771">

    <xsl:attribute name="font-variant">small-cap</xsl:attribute>

    <xsl:attribute name="color">rgb(0,0,0)</xsl:attribute>

    <xsl:attribute name="font-size">12pt</xsl:attribute>

    <xsl:attribute name="font-family">Tahoma</xsl:attribute>

    </xsl:attribute-set>

    and image height and width to be 10pt.