Traditional web-based reporting with SAS BI tools

Custom Footer - Report Viewer

Reply
Contributor
Posts: 42

Custom Footer - Report Viewer

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

SAS Super FREQ
Posts: 468

Re: Custom Footer - Report Viewer

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)

 sample_footer.jpg


sample_footer.jpg
Contributor
Posts: 42

Re: Custom Footer - Report Viewer

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.

SAS Super FREQ
Posts: 468

Re: Custom Footer - Report Viewer

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.

sample_footer_2.jpg

Ask a Question
Discussion stats
  • 3 replies
  • 260 views
  • 0 likes
  • 2 in conversation