The SQL query Order by is prioritize as:#1. Group(s) inside the report format.#2. The Main tab report screen's Order by checkboxes.
- When preview button was hit, system can get #1 because only 1 format is selected to preview.- But it's not the same for customize button. Since you can see that 1 report may consist more than 1 format and each format may has different group(s) among itself. Then, which format #1 need to capture?- If preview 1st, then only do the customize - why the report shows correctly? A: Coincidence the report that you were preview contains similar group as the report that you are trying to amend, this is ReportBuilder problem because it's doesnt refresh after the report is closed. Let's preview different format instead, eg: <SR>04 Stock/Service Item Listing By Class > Close > Customize > Select Format - A4-2COL-GROUP- PORT. You can see result is different since <SR>04 is sort by Class.
For this case, 103 pages is the correct result since the query is loaded the correct Order by information as you can see 380 pages due to the records are not sort properly.