04-29-2015 04:21 AM
I have a question - how to show a value from DB during prompt (if it is possible).
What I have currently:
Currently all of above works ok but I would like to add one thing to above:
When prompt shows calendar - before report is executed - I would like to show additional information from database sql (eg. when data warehouse was last processed) and show it to user - he would see then my information as txt and normal prompt defined as it is now.
Currently user - when selects data for report - does not know for what day database is processed.
Could anyone help me with this topic? Where should I look for?
SAS Enterprise Guide 5.1
SAS Information Map Studio 4.31
SAS Web Report Studio 4.31