Hi How to design report with more than 30 columns? I have columns like, company code, company name, currency, transaction date, .... so when i print it comes on 2/3 pages, few columns on one page and few columns on other page so on. Any idea to print this report on one page or can i automaticlly repeat some columns like company name, code on other page also? so that no need to design those columns again it will come automaticlly on next(other half columnwise) pageh2007

Hi, 1.If you can Reduce the Column Width. 2.You can Adjust the Page Width and Size in Report Properties. 3.Use Landscape as Prininting Mode and set the same in Report Properties. You can Look into this Link for More Info. http://msdn.microsoft.com/en-us/library/bb677374.aspx Mark it as Answered if Found Useful. Rakesh M J