change report row limit
I previously set a 10,000 record limit on the data source and build a few reports on it. I later realized that this is being applied on sub-queries instead of overall result, so i removed limit from the data source. There is no limit on the view either.
The report still shows 10,000 limit applied to sub-queries. I can't find an option to change that. I want to avoid recreating the views and report as I'll have to do it for quite a few reports built on this view.