>>>>>Hi everybody,
>>>>>
>>>>>I have several reports designed by my colleague in a Legal size paper and some of them in Landscape mode. The user requested for all reports to be in a Letter paper format and preferably in portrait. Can you please advise me on the best course of actions in attempts to fit user's requirements?
>>>>>
>>>>>Thanks a lot in advance.
>>>>
>>>>Just ask your users which columns they want to eliminate.
>>>
>>>Nice, thanks :) I think they want to keep all the columns but would not mind using a different font (the narrowest).
>>
>>Then it's simple: print couple things for them in the narrowest font and ask the same question again. Some, more stubborn, users may still request 2-row detail band.
>
>Yes, looks like I can not make all columns to fit. I can not use Arial Narrow font for amounts :( and can not find a better font than Courier New. Any ideas?
>
>Thanks again.

You could print details in 2 rows and have 2-rows header too. It may not look nice but if your users are so eager to have all data in portrait let them have it.