<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Object size - Sheet vs Report object size and Printed font size not correct in QlikView</title>
    <link>https://community.qlik.com/t5/QlikView/Object-size-Sheet-vs-Report-object-size-and-Printed-font-size/m-p/270555#M101473</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi everyone,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I would appreciate any assistance wrt the following problems with the Qliview report creation tool. The problem consists of two issues: (a) screen/sheet size versus report size and (b) resultant compression of objects on printed report.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;Background&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;I have an object (straight table chart) on a sheet and it's dimensions are 559 wide by 137 high. When I print the sheet (via File menu) then the object is displayed correctly.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;When I insert the object into a report then the size is automatically changed from 559x137 to 768x129 but neither of these sizes print the object correctly (as displayed on the sheet).&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;Problems&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;I have enabled the object border in Item Settings on the Report in order to see what is happening. The following problems occur:&lt;/P&gt;&lt;P&gt;1. If I print the object at either 559x137 or 768x129 then the full width is used but available height is not used and there is blank space within the border.&lt;/P&gt;&lt;P&gt;2. In either case the object font size does not agree to the original used on the sheet i.e. the sheet object uses Arial size 8 font. If I print the same text, using &lt;STRONG&gt;Excel&lt;/STRONG&gt; and Arial size 8 font, then the printed Qlikview text and Excel text sizes are different. I worked out the Qlikview/Excel ratio (width of text on Qlikview print versus width of the same text in Excel print) and applied this to the Report object and this almost agrees.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I assume that there is a difference between the screen/sheet resolution &amp;amp; ratio versus the ratio that is used for a report. I know that I can manually resize and apply the ratio that I calculated but this will be extremely time consuming as it is a 6 page report with a large number of objects per page.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;Additional Question&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;1. Does anyone know of any alternative tools to the Qlikview Report creation tool?&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Thanks in advance.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Regards,&lt;/P&gt;&lt;P&gt;Craig&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Mon, 24 Oct 2011 11:25:58 GMT</pubDate>
    <dc:creator />
    <dc:date>2011-10-24T11:25:58Z</dc:date>
    <item>
      <title>Object size - Sheet vs Report object size and Printed font size not correct</title>
      <link>https://community.qlik.com/t5/QlikView/Object-size-Sheet-vs-Report-object-size-and-Printed-font-size/m-p/270555#M101473</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi everyone,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I would appreciate any assistance wrt the following problems with the Qliview report creation tool. The problem consists of two issues: (a) screen/sheet size versus report size and (b) resultant compression of objects on printed report.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;Background&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;I have an object (straight table chart) on a sheet and it's dimensions are 559 wide by 137 high. When I print the sheet (via File menu) then the object is displayed correctly.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;When I insert the object into a report then the size is automatically changed from 559x137 to 768x129 but neither of these sizes print the object correctly (as displayed on the sheet).&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;Problems&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;I have enabled the object border in Item Settings on the Report in order to see what is happening. The following problems occur:&lt;/P&gt;&lt;P&gt;1. If I print the object at either 559x137 or 768x129 then the full width is used but available height is not used and there is blank space within the border.&lt;/P&gt;&lt;P&gt;2. In either case the object font size does not agree to the original used on the sheet i.e. the sheet object uses Arial size 8 font. If I print the same text, using &lt;STRONG&gt;Excel&lt;/STRONG&gt; and Arial size 8 font, then the printed Qlikview text and Excel text sizes are different. I worked out the Qlikview/Excel ratio (width of text on Qlikview print versus width of the same text in Excel print) and applied this to the Report object and this almost agrees.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I assume that there is a difference between the screen/sheet resolution &amp;amp; ratio versus the ratio that is used for a report. I know that I can manually resize and apply the ratio that I calculated but this will be extremely time consuming as it is a 6 page report with a large number of objects per page.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;Additional Question&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;1. Does anyone know of any alternative tools to the Qlikview Report creation tool?&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Thanks in advance.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Regards,&lt;/P&gt;&lt;P&gt;Craig&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Mon, 24 Oct 2011 11:25:58 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/Object-size-Sheet-vs-Report-object-size-and-Printed-font-size/m-p/270555#M101473</guid>
      <dc:creator />
      <dc:date>2011-10-24T11:25:58Z</dc:date>
    </item>
    <item>
      <title>Re: Object size - Sheet vs Report object size and Printed font size not correct</title>
      <link>https://community.qlik.com/t5/QlikView/Object-size-Sheet-vs-Report-object-size-and-Printed-font-size/m-p/270556#M101474</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi Craig ... Did you manage to solve this issue? .. as i have the same issue!!&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Thu, 05 Jul 2012 12:30:39 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/Object-size-Sheet-vs-Report-object-size-and-Printed-font-size/m-p/270556#M101474</guid>
      <dc:creator />
      <dc:date>2012-07-05T12:30:39Z</dc:date>
    </item>
  </channel>
</rss>

