topic Re: Options page size not working for ODS RTF in ODS and Base Reporting

Options page size not working for ODS RTF

adrnneadriana — Mon, 30 Mar 2020 14:11:57 GMT

When I'm generating a ODS RTF file, Im getting my footer in next page. But I still have some empty space in first page above title.

I have tried PS options, but its not working. When I use PS = 40 or PS = 80, RTF output remains same

How to increase my number of Lines than can be there in a RTF page ?

options orientation=landscape nodate PS=65 ls=120 nocenter nonumber nobyline topmargin=1.5in bottommargin=1in leftmargin=1in rightmargin=1in;

Re: Options page size not working for ODS RTF

ballardw — Mon, 30 Mar 2020 15:13:31 GMT

1) you should show the actual settings you use including the ODS rtf statement with all options

2) I don't believe Pagesize has anything to do with any ODS destination. You might try using Papersize.

Also I think you may want to set the options prior to the ODS RTF and don't attempt to change the page size or orientation within the ODS RTF / ODS RTF Close code block.

Re: Options page size not working for ODS RTF

adrnneadriana — Mon, 30 Mar 2020 16:25:32 GMT

Below is the code
Im using options only before ODS RTF call not in between the ODS RTF / ODS RTF Close code block.

options orientation=landscape nodate PS=65 ls=120 nocenter nonumber nobyline
topmargin=1.5in bottommargin=1in leftmargin=1in rightmargin=1in;
title; footnote;
title;
ods _all_ close;
ods rtf file="&resultpath.&filename..rtf" startpage=yes style=tablertf BODYTITLE_AUX nogtitle;
ods escapechar='^';
<proc report code >
ods rtf close;

Re: Options page size not working for ODS RTF

Tom — Mon, 30 Mar 2020 16:27:52 GMT

PS and LS have nothing to do with ODS destination. Just the plain text LISTING destination.

Re: Options page size not working for ODS RTF

adrnneadriana — Mon, 30 Mar 2020 16:29:50 GMT

how can i increase the number of lines in a page in RTF destination ?

Re: Options page size not working for ODS RTF

Tom — Mon, 30 Mar 2020 16:31:44 GMT

Make the page larger or make the font smaller (actually really the space between lines, but you don't want the lines so close together that the characters are printed on top of each other).

Re: Options page size not working for ODS RTF

adrnneadriana — Mon, 30 Mar 2020 16:38:54 GMT

how can I make Page larger ? There is some space left before the title and after footer. How Can I increase number of lines in page ?

There is NO data wrap in my table also, and text format and size I cannot change as its company standard.

Re: Options page size not working for ODS RTF

ballardw — Mon, 30 Mar 2020 17:50:08 GMT

OPTIONS Papersize = (8in 15in);

before the ODS RTF statement will set the papersize default to 8 inches wide by 15 inches long.

Or use other measurement unit like CM if that is better for you.

You can also use some paper size names like 'Letter' or 'A4'. Current list depends on your install and likely LOCALE setting. I tend to just specify the measurements.

Papersize will override the Orientation option.