There are 30 variables in my dataset and for that dataset if I create a pdf file through ods odf then it shows 20 columns in first page and remaining 10 columns in second page,but i want all 30 columns should come in first page only.Is there any way to do that.
If you search in the forum search facility for the string "very wide" there was an earlier forum posting on dealing with very wide tables when landscape orientation was not "wide" enough. Basically your choices are to make the font smaller, reduce the cell padding in the table, remove interior tables lines and/or some combination of all of the above.
The earlier forum posting had a large section of code that showed the correct style attributes to change and how to change them in order to try to get "wide" output onto a PDF or RTF page.
One easy alternative is to switch to HTML output which can be as wide as you need it to be because there is no limit on how wide a browser screen can be ... although realistically, you will probably reach the limit of someone's patience to either scroll or squint when you have very wide tables if you make the table too wide or the font too small!