I have a requirement to create a VA report with monthly data snapshot. The report should have a List report which gets populated with a months data based on month value (drop down control). How to create such a report where the report maintains monthly history snapshot
Are you attempting to use something that is persistent between execution? It sound like you want to select a single value(month) but then have the result include all of the previously selected reports generated. Is that correct? Also would the "new" month be at the top or bottom of the result? What order would the previous "monthly snapshots" have?
Would the data source(s) used to make the previous snapshots be the same or a different data set?
I have no actual clue on how to do this in VA as I have no access but I think the answers to the questions may help others that may.
You need to load all of the months you wish to report on into your VA LASR source data. Your drop-down control can automatically select the latest month, or select another month if required.
Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.