Hi, I have a question - how to show a value from DB during prompt (if it is possible). What I have currently: In oracle database I have a view AView with data for a report In SAS Enterprise Guide I have prepared Stored Process for feeding data to report (query overriden by oracle sql) In SAS Information Map Studio I have preparde Information Map from AView for Report In SAS Web Report Studio I have prepared report that uses above products Report uses prompt for date (calendar) 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
... View more