If you are running your report and only part of the data is being captured, try the following steps until the problem is fixed:
- Make sure that you are connecting to the correct Sage 50 company. This is the most popular reason for a report to show incomplete results. Compare the path and filename should in the XLGL connection panel to the one in Sage 50. Where you can see this will depend on your Edition of Sage 50:
Canadian Edition: Look under File, then Properties. 
US Edition: Look under Maintain, then Company Information.
If you need to change the connection location, make sure to disconnect, then reconnect.
- Make sure that XLGL is connected to the company. A green dot should be showing on the XLGL Connection Panel beside your connection name.
- Verify the parameters to the report. Check that the values of all parameters are valid and in the correct format. We recommend to enter dates in the YYYY-MM-DD format.
- Click Refresh on the XLGL ribbon to force a update.
- Close all Excel windows. Verify the Windows Task Manager and stop all Excel process still running. Restart Excel and try your report again.
- Restart the computer.
If you are still having issue, contact our support team. Include a copy of your file and describe the steps you have tried so far.