Pulling A List of Report Variable Values per User in AppStudio

JacobDavis

Hello, in ApplicationStudio, I've created a variable that counts the number of times the report is opened.  The variable is named "rv_Counter".  If I right click the variable in the Accessories panel and go to Manage Values for Variables, I can see a list of the users and the rv_Counter value associated with that user.  Is there a way to extract this list, or pull it into another report?  The goal is to see how often users interact with each of the reports.  If reports are not being interacted with, then we want to be able to retire them and stop maintaining them.  If you have a better or alternate way, please do inform, I'm all ears.

John Robson

Assuming you have access to a relational database I would use an on load action to write records to an SQL table - e.g. Report UniqueName,, User, DateTime,

The same load action can be used for every report and could leverage the built in variables for _CurrentUser and _CurrentReportID.