topic Re: Custom Footer - Report Viewer in SAS Web Report Studio

Custom Footer - Report Viewer

Ronny_Dsouza — Tue, 28 Jun 2016 21:10:16 GMT

Hi ,

We have a requirement , wherein as part of the footer we need to showcase the user who is viewing the report, GIven that we know that the same is not availbale OOTB, we thought that we would have an STP capture the same and display in the lower section of the report,

Any thoughts of a better way to do so. Please let us know.

cheers

Ron

Re: Custom Footer - Report Viewer

Madelyn_SAS — Wed, 29 Jun 2016 14:30:18 GMT

I think that the stored process is a good idea. You could use code similar to this. This link has the list of reserved macros:

http://support.sas.com/documentation/cdl/en/stpug/68399/HTML/default/viewer.htm#p184mqqbi9w6qjn1q0619x19eg02.htm

*ProcessBody;
%stpbegin;

data t; 
user_details = "Query submitted by - &_METAPERSON "; 
run; 
proc report data = t nowd noheader style =[bordercolor=white cellwidth=700 ] 
style(column)=[font_weight =bold font_style=italic] ; 
title; 
run; 

%stpend;

Here it is in a report (bottom left)

Re: Custom Footer - Report Viewer

Ronny_Dsouza — Wed, 29 Jun 2016 18:47:24 GMT

Yup, thats the approach we have kept it so far, the only drawback is we loose the synchronization among all the objects in the report. anyways we can retain that functionality along with the STP presence.

Re: Custom Footer - Report Viewer

Madelyn_SAS — Wed, 29 Jun 2016 19:41:09 GMT

You cannot synchronize as long as the section includes a stored process. Another possible workaround is to edit the information map to add a character data item with the expression:

scan("&_METAUSER",1,'@')

Then, hide that data item in all objects, placing it in a list table at the bottom of the report.