topic Re: Control number of rows per page from Stored process output in WRS 4.2 in SAS Web Report Studio

Control number of rows per page from Stored process output in WRS 4.2

RSB — Thu, 03 Feb 2011 13:50:43 GMT

Is there a way to restrict the number of rows per page to 20 from stored process output in WRS 4.2, currently it is displaying 40 rows per page by default.

Re: Control number of rows per page from Stored process output in WRS 4.2

Nithin — Thu, 03 Feb 2011 21:33:53 GMT

Do you want to control the number of rows from stored process only ?
You can change the default 40 rows by changing table properties.

Re: Control number of rows per page from Stored process output in WRS 4.2

RSB — Fri, 04 Feb 2011 04:32:10 GMT

The table properties are available only if the source is an information map.

Re: Control number of rows per page from Stored process output in WRS 4.2

Cynthia_sas — Fri, 04 Feb 2011 05:29:32 GMT

What procedure is producing the output in your stored process??? PROC PRINT, PROC REPORT, PROC TABULATE??? Some other procedure or combination of procedures???

Without knowing more about the program or procedures involved in the SP code, it is hard to comment constructively.

cynthia

Re: Control number of rows per page from Stored process output in WRS 4.2

RSB — Fri, 04 Feb 2011 05:49:51 GMT

Hi, Sorry if my Question was too abstract. My Stored process uses Proc Report to produce the output and I am trying fit 20 rows per page in the report.