Got a curly one from a customer yesterday, so thought I would throw it out to the wider community (and Chris from SAS
to see if there is an answer.
So in Web Report Studio you can have the prompts that have been selected (i.e City = Auckland) automatically displayed on a report.
The customer is of course not using WRS but is using Enterprise Guide, Stored Processes and Office Addin.
They worked out a way to have Stored Processes that are delivered via Excel/AMO to display the selected prompts when executed, and we could use this concept in EG to effectively create two list reports (one for report content and one for selected prompts) and combine them in report.
But I was wondering if any knew of a way to have the prompts shown in a graph output etc?
Shane,
Since prompts are simply macro variables with the answers, this should be possible. You would have to know what the macro variables are and then use them appropriately as TITLE or FOOTNOTE values, perhaps.
If you examine the SAS log when you run a Stored Process in Enterprise Guide, you should be able to see how the macro variables resolve. Some prompt types, such as lists or date ranges, get kind of funky in their format, so you might need to get a bit fancy when you reference the macro variable in your output.
Chris @ SAS