-
a GST Software that do not require you to have much GST Knowledge!
Support Center > Knowledge base> Article: Stock/Service Items Listing-Total Page No. difference when Preview on screen and report designer

Stock/Service Items Listing-Total Page No. difference when Preview on screen and report designer

Article ID: 52602 Email Print
Question
Stock/Service Items Listing-Total Page No. difference when Preview on screen and report designer

Answer

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.


related articles

Article Details
Views: 1282 Created on: Aug 07, 2014
Date updated: Aug 07, 2014
Posted in: Delphi

Poor Outstanding