We have table on a report in VA. The user choose some options from combobox filters to display the records on a table. In some case, we have a huge number of records and appears a warning on the reports and not shows the results.
My question is, there is any way to show only 1,000 records on a table report? And if the result has more than 1,000 shows a message saying which is the total number of records and a text saying that is only display the first 1,000?
What version of VA are you using?
There are administrative options to to set the data limits for some objects, but I'm not sure if there is one specifically for list tables.
I don't think that customizing the message will be possible.
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.