Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 export report shrink into A4

Author  Topic 

pecunn
Starting Member

20 Posts

Posted - 2011-05-06 : 04:04:34
Hi team,

I have report with around 15 coloums, it is showing nicely on preview mode, however when i try to export to PDF/ TIFF mode it split into multiple pages because cant fit to a single A4.
I have set the report properties page to A4 landscape but it still not enough.
Is there any way/ properties to set up it will shrink automatically to 1 page?
Im using sql reporting builder 2008

syedathariqbal
Starting Member

3 Posts

Posted - 2011-05-11 : 16:23:08
Hi,

I have faced this several times and there is a very simple solution to it.

In the report designer page, go to "Report" in toolbar at top, then go to Report Properties and then in PageSetup.
First thing, of course would be to change the page set up to Landscape which you have already done.

and now the secret.....
In the 'Width' section, increase the Width, say by 15-20%, default is say 11 inches, make it 13 inches and see your pdf export how it looks like....Better? :)
Increase is as much as you would like.
Note that however, you should also minimise the font and spaces if any in the columns and shrink it as much as possible.

As simple as that

Consultant
MSBI
Go to Top of Page

arronlee
Starting Member

12 Posts

Posted - 2013-12-27 : 01:48:11
Hi,
I have ever tried to
split PDF files with the help of the following code:

using YiiGo.Imaging.Basic;
using YiiGo.Imaging.Basic.Core;
using YiiGo.Imaging.Basic.Codec;
using YiiGo.Imaging.PDF;

namespace YG__Test
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}

public static string FolderName = "c:/";

private void button1_Click(object sender, EventArgs e)
{
string fileName = FolderName + "Sample.pdf";

YGDocument doc = YGFile.OpenDocumentFile(fileName, new PDFDecoder());
//use PDFDecoder open a pdf file List<BaseDocument> baseDocs = doc.SplitDocument(1);

int index = 0;

foreach (BaseDocument baseDoc in baseDocs)
{
// YGImage reimage = (YGImage)baseDoc.GetPage(0).ToImage();
index++;

YGFile.SaveDocumentFile((YGDocument)baseDoc, "c:/reDoc" + index + ".pdf", new PDFEncoder());
}

}

Or you can also google it and select a professional 3rd party Tiff splitter whose way of processing is simple and fast to help you with the related work. It will be better if it is totally manual and can be customized by users according to our own favors. Remember to check its free trial package first if possible. I hope you success. Good luck.



Best regards,
Arron
Go to Top of Page
   

- Advertisement -