There are some advanced options as well when we create a publication located under the Additional Options category.
We will navigate to the Advanced option located under Additional Options:
Here, I'll discuss the options in the Report Bursting Method:
One database fetch for all recipients: This option should be used when we need to run the report once and then, using the profile, deliver it to its recipients. This option reduces database hits as the report runs only once and it's also configured to users that don't have row-level security (security at the database level).
Using this scenario will usually output the report to Excel, PDF, or any other supported output format; otherwise, if we are publishing the report as a Web Intelligence report, then users can access the report filter and remove it as personalization is nothing more than a report filter.
One database...