Don't you give up Arun.
In my case I did a merge cells on all columns for a header row in a table and one page in the report when exported to pdf was printing in bits and pieces across several pages.
After so many attempts at rebuilding the reports for several days, by chance I discovered this. Merging cells for a report table title is a common thing and never would I have realised that this would cause printing problems.
So, again do not give up, try building the report from scratch. do not make a copy of the existing report and make design changes. you never know what caused the craziness in the original report.
Like I said, it is only by trials we perfect the art.
Also, space(), chr(), vbcrlf, newline() might behave differently in Rpt Mgr, Excel, PDF......
"Software changes. This is a rather obvious statement, but it is a fact that must be ever present in the minds of developers and architects. Although we tend to think of software development as chiefly an engineering exercise, the analogy breaks down very quickly. When was the last time someone asked the designers of the Empire State building to add ten new floors at the bottom, put a pool on the top, and have all of this done before Monday morning? " : Doug Purdy, Microsoft Corporation