Creating a Date Range Prompt in Web Report Studio

2


Getting a date prompt that filters on a range of dates requires an Information Map with a date variable that exists twice on the Information Map, two different prompts, and application of both within a Web Report Studio Report. Included are steps to get this to work.

  1. Within Information Map Studio select the data and select the ‘Date’ variable twice (since a prompted filter can only be applied to one value at a time).
  2. Rename the second ‘Date’ variable & don’t utilize in subsequent Web Report Studio Reports.
  3. Create a New Filter for ‘Start Range’ and select the first Date Variable
  4. Click ‘Create Prompt’
  5. Do steps 4 & 5 above for ‘End’ date, but select the ‘Data Item’ called ‘Date-Copy’ and ‘Is before or equal to’ condition
  6. Save the Information Map
  7. Go to Web Report Studio
  8. At the Select Data Screen, choose both the Date & Date-Copy data elements
  9. Apply the Start Range prompted filter to Date and End Range prompted filter to Date-Copy
  10. On the report table, move the ‘Date-Copy’ to hidden.
  11. Now click ‘View Report’, the returned prompt allows the user to enter in Date Values (in m/d/y format) to query the start & end range of values in the data table.
Share

About Author

Angela Hall

Senior Technical Architect

Angela offers tips on using the SAS Business Intelligence solutions. She manages a team of SAS Fraud Framework implementers within the SAS Solutions On-Demand organization. Angela also has co-written two books, 'Building BI using SAS, Content Development Examples' & 'The 50 Keys to Learning SAS Stored Processes'.

2 Comments

  1. The date range prompt instructions provided here were created in tested in the SAS 9.1.3SP4 environment (with WRS 3.1). I havent taken a look at this scenario in the new WRS for SAS 9.2. New blog post will likely be in the works.(Also, I'll add version information in future posts. Thanks for the feedback!)

Back to Top