Traditional web-based reporting with SAS BI tools

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

Reply
Contributor RSB
Contributor
Posts: 72

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

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.
Contributor
Posts: 40

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

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

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

The table properties are available only if the source is an information map.
SAS Super FREQ
Posts: 8,815

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

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
Contributor RSB
Contributor
Posts: 72

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

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.
Ask a Question
Discussion stats
  • 4 replies
  • 285 views
  • 0 likes
  • 3 in conversation