Browse By Tags

  • Workflow send crystal report pdf with different parameters

    Good day, I'm trying to use workflow standard rules to send a pdf (report created in crystal) to some users. Standard usege works fine for me, but I need to send, in my case, an sell order printed with different setup (for example outside with prices…
  • [v12p34] Unable to print Crystal Report dynamic image pulled from HTTP on a HTTPS website

    Hi, Context: - Sage X3 v12p34, single-tier (HTTPS; currently having issue) - AI image server (HTTP, inside Sage X3 v12p34 server, address used assume: http://localhost:58888/) - Sage X3 v12p26, single-tier (HTTPS; control) - Crystal Report 2020…
  • Edit Reports with full version of Crystal Reports

    I already own Crystal Reports. Is there a way to edit the Crystal Reports from Sage with my existing license and not purchasing the Sage version of Crystal Reports?
  • SY_State when added to InvoiceHistoryHeader duplicates the InvoiceNumbers? And it freezes the report when InvoiceHistoryDetail around 23K records.

    How come when I add SY_State to get the state name it duplicates the InvoiceNo from AR_InvoicehistoryHeader. The only field I use is StateName from SY_State. And when I add AR_InvoiceHistoryDetail it freezes the report around 23,000 records.
  • Running a Crystal Report with a range parameter from Web Services using (CWSGPRTRT) Generic Print Report

    We have set up an outside App that calls the Generic Print Report (GWSGPRTRPT). You pass the report name, language, destination, and an array of parameter names and values separated by "~". We have gotten this process to work, but only if the specific…
  • What is This Number On Our Purchase Order?

    We have gone to the Crystal Reports and cannot for the life of us figure our what this number represents? It didn't change when I printed the PO (as in it would roll up one for each time printed), it also did not change when I added lines or modified…
  • Looking for SQL table information

    HI, i'm trying to create a report for tax exemptions and W-4 amounts. I have the knowledgebase article that calls out that PARMSEQ refers to the field on the screen and PARMVAL is that value. But is there any way to get the Tax Field and Value entries…
  • Crystal Reports 2016 error in custom report after Sage 100 2021.6 update

    First time in 12 years that the report I maintain is getting an error. Failed to retrieve data from the database. Details: s0000:[ProvideX][ODBC Driver][PVKIO]Data page header contains invalid record offset information. [Database Vendor Code: 109…
  • Conditional field suppression in Crystal Reports

    MN has enacted Safe and Sick pay that must show on an employees paystub. I have added this field and label to the DD stub but do not want it to print for employees that are not in MN. The hours are helfd in time off 2. How can I suppress this field from…
  • Crystal Report - Text not visible

    I am working customizing Quote Forms using crystal reports and we have a standard text on each specific quote. This standard text will not show up on the sage preview. It is like somewhere in the report its blocking a view in some of the groups. Any Ideas…
  • (REPORTING) How to link invoice line items to GL Detail Posting?

    Hi all, We do most of our customer reports based off the GL_DetailPostings table. I have a few reports filtered to only show "SO" module transactions and I pull in some additional data from the InvoiceHistoryHeader table but now am being asked to…
  • how to filter the date range on AR statement printing

    Hi, My client wants to filter the transaction date range within a specific statement date on AR Statement Printing Report. I tried to filter the date range using 'select expert' which set the between from to transaction parameter. If I press F5…
  • Inventory Turns Report

    I have been tasked to create an Inventory Turns Calculation in Crystal, I have a report with all the items, a date range parameter and COGS calculation, Piece of cake. How would get average inventory? Is there a table that gives you historical inventory…
  • Sage 100 2022 Premium Crystal Reports Database Login Failed. Unable to connect: Incorrect log on parameters

    Hello I'm upgrading from 2018 Advance to 2022 Premium. When on the server we can run canned reports within Sage 2022 without error. When we try and run reports from a client 2022 workstation we get "The database login failed. Error in File GL_ChartofAccountxxx…
  • Generate separate PDF files of invoices from Crystal Report and send them by email to customers

    Dear community, we are trying to understand if a specific action is achievable with Crystal Reports. At the moment we are printing invoices by customer and invoices range and we get one PDF file with all the invoices inside. This file is then sent…
  • Sage 100 2023 & StarShip v24

    Hello everyone, My company has been having an issue with a Sage 100 & StarShip interaction. Basically, when shipping items, the associated Sage documents are not printing. I've doubled checked multiple times to ensure the Form Code is correct and no…
  • Crystal Report Printing Error

    I have modified the Packing LIst to show a total of items being shipped per page. On my system everything works fine. It prints 8 lines per page and shows the page totals very nicely. On my clients computer it only prints 7 lines per page, but the page…
  • SQL Login failed error in Crystal Reports

    We just upgraded a client to Sage 300 2023 on their existing server. After the upgrade, printing their customized PO form prompts to enter SQL name and password. Even when I enter the correct credentials, it fails with "login failed" message. I thought…
  • Crystal Reports 2020 Database connection Error

    Have a client that upgraded from Sage 100 2019 to Sage 100c Advanced 2023 PU1. They run several reports outside of Sage using Crystal Reports Writer version 2020. They can run these reports with no issues some of the time, but then later in the afternoon…
  • Issues with printing in Citrix 7.7 environment and version 2016.1

    We recently upgraded our environment to use Citrix 7.7. While initial testing did not reveal any issues, users are now experiencing application lockups when printing. We have possible workaround that works at the time of the issue, but is not a permanent…
  • Crystal Reports license key

    I need to migrate Fixed Assets to a new machine, which I've done. However, I don't quite know how to move Crystal Reports since I can't find a license key for it. I saw another post that said the license key was baked into the installer, so I don't know…
  • Global Task Manager

    Running depreciation reports and error comes back saying - Unable to run Depreciate -- Object reference not set to an instance of an object
  • Is Sage going to address the other log4j Security Vulnerabilities?

    There are other log4j vulnerabilities besides, CVE-2021-44228 . There are also vulnerabilities for CVE-2019-17571, CVE-2020-9488 and CVE-2022-23302 . I tried to flag this with Sage support but I hit a roadblock and they told me to contact SAP since…
  • ActiveFax Codes Not Reading on PDF Exports with Version 12 (Solved)

    The problem: When printing PDF files generated through X3 V12 to ActiveFax with the goal of automating email & print jobs; ActiveFax cannot read the codes despite having the font successfully installed on the server, pointing to the font in the crystal…
  • What Crystal Reports runtime engine use Sage 300 2022?

    Hi everyone, We just upgrade an old Sage 300 ERP v2012 to a new server with Sage 300 2022 Update. Not a problem. But a custom application IT create with VB that use Crystal reports is not working, apparently for some crystal runtime engine conflict…