Browse By Tags

  • Qual o campo em Crystal Reports para o Motivo de Crédito para uma NC?

    Também gostaria de saber se existem modelos base de Reports para poder personalizar e adicionar formulas aos meus sem ter de estar sempre a procurar na Base de Dados.
  • Can you add a url to products so the crystal reports will export hyperlinks to our website?

    We'd like our quotes to display the product codes hyperlinked to their associated webpage on our website. Is there a way to do this with sage 100 and crystal reports? Seems like a very basic thing that should be doable.
  • Getting total pieces ordered on a SO to print on the SO

    is there a way to get a sum total of all the pieces ordered to calculate and print on the SO, Packing list or bill of lading. I am looking for the grand total of all the items. Having a grand total of the items shipped would also be helpful. Than…
  • Supressed Entries leave large blank spaces on Picking Sheets after Sage 2021 update

    Ever since we update to Sage 2021, the suppression in on our forms doesn't work correctly. It will leave large blank areas for al the supressed values. Supress blank sections is already selected in the group and details. It was working perfectly before…
  • Sage 300 Retail: Error: ActiveX component can’t create object(429) when printing any POS reports

    Problem: Whenever printing a POS report an ActiveX component can’t create object(429) error occurs. Cause: That is usually the Crystal 8.5 runtime that is still part of the program, it is part of the old workstation setup and they may need to re…
  • PII fields in formula Payroll

    Trying to do a simple formula combining the PR Employee last name with the suffix. Both fields are PII fields. When I run the report data formula only works if employee has a suffix so I had to place the last name field in the report and then cover it…
  • Connect multiple UDFs so selecting one will display extra info to be used in Crystal Reports

    I added a tab to my Invoice Data Entry panel with UDFs I want to be able to select an option in "SCAC Code" which will then display the proper name of the carrier outside of the SCAC Code dropdown. I want the SCAC Code and CARRIER NAME to be separate…
  • AR Aging Report with Description in Crystal Reports

    Hi, I wanted to add "invoice transaction description" into it original report file ARTBAL.RPT using Crystal Reports. But there is no description field found from it existing table in this report. The field that I want to add is in table AROBL.DESCINVC…
  • Crystal shared var printing previous record

    I am passing a value from a subreport to main report and in the main report this is the formula: WhilePrintingRecords; shared numbervar Cafe; Cafe If there is not a match between the main report and subreport, Then it prints the value from the previous…
  • Crystal Reports and the viewer

    First of all, I don't want to buy a plugin because there is zero budget for this. Secondly, I will also state that I know Crystal is not officially supported any more. With that out of the way as well, I'll get to my point. I am creating reports in…
  • Crystal reports

    Firstly, I know Crystal isn't supported with CRM. I have CRM v7.3c1 Moving on, I have had to create some reports in Crystal as they're far more complex than CRM can produce. There are plenty of articles on the community that mention how to call a Crystal…
  • Working with Multi Select fields in Crystal Reports

    I’m working on a CRM project and I need to write a Crystal report to provide a prioritised list for selection based on a complex set of criteria. A number of the criteria are contained in CRM Multi Select fields. I can’t figure out how to work with these…
  • Crystal Reports for Sage 7.1f

    Hi All, I tried to configure Crystal Reports Samples using the Admin Guide - Section 42. The List of reports appears on screen but do not run The error: Could not find CLSID for CrystalReports.ActiveXReportViewer I have Crystal Reports Install…
  • Generate Crystal Reports using ASP

    Hello everyone, Does anyone have a ASP source code to export a crystal report to pdf? Cheers Tiago
  • add button to main menu with menu

    Hi can i add button to main menu and sub button when click on it like shown in image i try to do this but System Act make it hard
  • I want to create a simple macro that does a bank transfer

    It would need to prompt for from bank, to bank, amount, and transfer date. then offer OK or cancel. The rest of the stuff on the bank transfer screen I find not helpful.
  • 100CLOUD - EMISSÃO DE MAPAS / DOCUMENTOS EM CRYSTAL REPORTS

    A aplicação Sage 100cloud contém mapas e documentos desenvolvidos sobre a plataforma Crystal Reports, em determinados sistemas operativos é necessário efetuar procedimentos adicionais para que sejam emitidos com sucesso. Deverá garantir que antes da…
  • Crystal Report 2011 install on Server 2016 terminal server

    Trying to install Crystal Reports 2011 on a Server 2016 with terminal services enabled. I have A: UAC disabled B: Changed user status to "install" and C: Disabled the antivirus. It appears to install and gets to the point of clicking on "Finish" at…
  • Sage 100 Advanced 2018 - Crystal 2016 New Payroll Check Alignment - assistance needed

    Sage 100 Advanced 2018 - Crystal 2016 - New payroll check alignment using Stub, Check Stub format - The "file", "page setup" allows the increase of the top margin without causing it to go to a second page (at least from my testing so far). I've been able…
  • Signature Capture in S/O in Sage 100

    I am looking to see if anyone has sucessfully integrated a signature capture pad, i.e a Topaz Model T-S460-HSB-R, into Sage 100 Sales Order. We are looking to get signature pads for our customers to sign before printing in Invoice Data Entry, that…
  • Sage 2017c web screen printing

    We have Sage 300c installed and the Web Screens are accessible. However, none of the standard reports display on the web screen if accessing them from a workstation that doesn't have Sage workstation installed on it already. Is there a fix for this…
  • Why does a UDF in work table which should be null has value of other record?

    Hi all, I hope you are up for some puzzles, I've spent 2 hours and I'm now lost. The version is Sage 100 Advanced 2015, 5.20.1 We have a UDF in SO_InvoiceWrk. The purpose of it is to grab the invoice number to which a credit memo will apply and shows…
  • Crystal Report Invoice Report field with No data

    I did the following to the YSBONFAC Report. When I print the report, the report does not break. But it does not out put the lot number either. Any recommendation. The lot number is on the delivery.
  • Sage X3 Edition CR .NET engine - Memory Full

    Good day everyone I have an instance where a report has images for products displayed on the report. The images are stored within X3 database which is used on the report. The problem we are experiencing is that when the report is executed to generate…
  • SHIP To Address Raw Material Order Crystal Report

    The system is printing the wrong Ship to address on the RAW Material orders. On the order it is displaying the correct address but on the PDF crystal report it has the wrong ship to address on all the raw material orders. Any Idea how to fix this…