Custom Footer - Report Viewer

[Ronny_Dsouza]

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

[Madelyn_SAS]

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#p184mqqbi9w6qjn1q061...

*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)

 

[Ronny_Dsouza]

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.

[Madelyn_SAS]

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.