Setting width for the page for the PDF report

[deep2021]

Hi All,

We are using on demand reporting and our output is in the pdf format.

It seems our last column of the table is not appearing in the generated output.

Could you please suggest where to set the width of the page so that I can get the column and values in the output.

Thanks

[Ruggero_Piccoli]

Hi,

Please specify what kind of template are you using. I suppose, reading your text, that you are creating a PDF from an Excel template. In this case please note that Excel is not the best choice to format the PDF layout. You have to proceed by trial and errors to find the best settings. 

You can try to set the page width to 1 page in the template:

Best Regards,

Ruggero

[deep2021]

Thanks,

You mean I need to set the width in the below section?

Thanks

[Lech_Miszkiewicz]

This is just excel setting and printing from excel is set in Print Area. 

https://support.microsoft.com/en-us/office/set-or-clear-a-print-area-on-a-worksheet-27048af8-a321-41...

Once you declare print area you can then choose setting Ruggero suggested like ("Width" - 1 page) etc...

[deep2021]

Hi, 

Thanks for your valuable response. 

Currently I am facing the issues related to the formatting.

I received the comment as "check you’re using the entire width and height of the page".

i am using excel bar chart and line chart, the I am unable to move or align.

There is also issues related to the font size.(I checked i am using the same font size and till there are issues.)

Could you please suggest the steps that I need to follow for the formatting.

Thanks

[Lech_Miszkiewicz]

If you are using multiple excel sheets then in order to retain the same font size you need to ensure that "Print Area" has also the same width which in turn typically is controlled by columns width. So whatever print area is setup on each sheet it needs to have exactly the same width if you want it to be consistent on all pages. 

If the print is set to "1 page" width then obviously it getting scaled to the size of PDF page print (letter, A4, A3 or whatever you have set). 

So - This is not really nprinting question you have. You can address this question to excel experts on microsoft community. Simply produce your report as excel and then open it and try to print it as PDF - as this is exactly what NPrinting does. 

[deep2021]

Hi Lech,

Thanks again for your valuable response.

Although, I set the  equal font size for the report, there are significant differences in the generated reports.

Below are the screen shots for the same.

Report 1->

Report2->

Could you please assist me where I need to set the  page settings so that the report looks same.

Can the same font size and the equal layout.

I am struggling a lot .Could you please suggest on this

Thanks

[Lech_Miszkiewicz]

Hi @deep2021 

I said it already - it is not only the same font size but also the very exact width of all columns which are within the print area.  That means that width of print area needs to be exactly the same amongst all sheets.  

The matter is quite clear and there is nothing else to add to it so if you still struggle with that setup I think you should maybe try and get a consultation from experienced Qlik partner who will show you how to do it. Here on community we already provided you with all required information and on top of that this not even NPrinting issue - as i is simply excel behaviour when setting printing from excel. 

cheers

Lech 

[Ruggero_Piccoli]

Hi,

If your goal is to create PDF and have a full control of the layout it we suggest to develop a PixelPerfect template.

Exporting Excel, Word and PowerPoint templates in PDF is supported but not ideal. Creating a PDF from an Excel template always rises the layout issues you are experiencing and the cause is that Excel itself is not designed for this usage. So you have to proceed by using Excel native formatting features, as suggested by @Lech_Miszkiewicz , and by testing, checking the results and try to modify the template.

There are no other ways. There are many conversations here in the community about this topic, so you could also give a check at them to find more suggestions but it will stay a matter of using Excel features. 

Best Regards,

Ruggero

[deep2021]

Hi Both,

Thanks for your valuable response.

Because of your help I have fixed many issues.

But still on the right hand side, there are blank spaces.

That I highlighted below,

Could you please suggest how to remove that.

Thanks