Browse By Tags

  • Wiki Page: 605-16736 - SqlError when making a search with extended character in Sage CRM Reports

    Summary: Modify a Communication Report to make a search on the character "ñ". Symptoms: The report should display communications with character "ñ". But the following is shown: SQl Error message - an error occurs during process. Resolution: This issue is resolved in...
  • Wiki Page: 492-16996 - Users with a plus sign (+) in their username may be unable to display reports

    Summary: Users with a plus sign ("+") in their username may be unable to display reports on-screen. Symptoms: As a user with a username of test+admin , try running a report to the screen. A 404 error message is displayed Error text: HTTP Error 404.0 - Not Found The resource you are looking...
  • Wiki Page: 636-17031 - Issue with report setting to select only the reports from the previous weeks

    Summary: Issue with report setting to select only the reports relative to the previous weeks in the search criteria on 7.0 and 7.1 installs. Symptoms: 1. This is for reports where the search criteria uses some form of date field. 2. For this example the 'opportunity: close by' date field was...
  • Wiki Page: 632-17213 - Cannot sort a cross tab report by translation

    Summary: Cannot sort a Cross tab report using the "by translation" option. Symptoms: The following error message is displayed when running the report: An error occurred while running the report. SQLError The following appears in the logs: errormsg 15 SELECT comp_sector,comp_type, COUNT(*) AS...
  • Wiki Page: 536-17368 - Reports go missing

    Summary: An issue can occur if a user logs out of CRM after clicking on a report category in the Reports section but before the report category loads. Symptoms: The next time any user clicks on a Report Category the reports will not be displayed on the UI even though they still exist on the database...
  • Wiki Page: 536-17476 - Reports go missing

    Summary: An issue may occur when a user clicks on a report category and then immediately clicks on the log out button. This can cause a problem displaying reports on the UI for all users of the system until a metadata refresh is done. Symptoms: An Access Violation error will be seen in the logs and when...
  • Wiki Page: 632-17532 - Exporting to Excel Issue

    Summary: When exporting a report to Excel in Sage CRM an error is shown and no report is exported. Symptoms: The following error message is shown: Cause: The cause of this was that the "Report generator maximum memory (MB):" was set too high, in this case 2048 MB. Resolution: Navigate to Administration...
  • Wiki Page: 492-17948 - Reports unable to display Thai characters

    Summary: Issues may arise when running reports containing Thai or other Unicode characters from an external database. Symptoms: Thai characters in reports generated to the screen or any export format (such as PDF) may display as blank squares. This issue does not affect data stored in CRM in entity records...