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.
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 thatConsultantMSBI |
|
|
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 |
|
|
|
|
|
|
|