• 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…
  • 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…
  • 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 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…
  • 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…
  • QR Barcodes

    Does anyone know if there is a Crystal font available for a QR barcode? We are using Sage 100 v 2015 Thanks
  • Custom report: G/L Account and Date Last Used?

    Is there a specific field and/or table to use within Crystal Reports to determine when a G/L account was last used? This would be for the purpose of delete the obsolete account. Please advise and thanks! T. Helm
  • Crystal Report: HELP! (Item Sales History report)

    To anyone out there who can help with this...I would be most grateful! Our boss needs a very specific Item Sales History report for Fiscal Year '2016' that should include the following as COLUMNS ( if possible ): Item Code, Item Description, Qty Sold…
  • Crystal Reports Quotes Appear in Export

    We export a bunch of reports in CSV format using Crystal Reports. I just updated to Sage 100 2016 from MAS 200 4.4 and something weird is going on. When we try and export a report to CSV format on the Server/Remote Desktop, the Delimiter and Separator…
  • New to Sage 100, need to customize some defaults and to access Crystal Reports

    I won't go into great detail but I am not getting the training I need from my employer and joined here to find answers to questions that I should be able to find myself in a normal working environment. I would like to fix the alignment for check printing…
  • resolved

    Thank you resolved
  • Can I print multiple forms when printing invoices from sales order?

    I have setup paperless office and it is working great, thank you all for your help. Is there anyway to also send the other forms requested by certain customers with the invoices such as the C of C's, BOL's or Packers? I'm not sure if there is a way to…
  • Report for Expired Credit Card Authorizations on Sales Orders

    I've searched through various posts and cannot seem to find an answer to a simple, specific question. Hopefully, someone can provide some input. I have created a very simple Crystal report, using the SO_SalesOrderPayment table. I want the report to…
  • Delimiter for Item Extended Description

    Sage 2016 SP1 The Extended descriptions are fine. I need to write a crystal report that uses the Second line of the Extended description. I am trying to use the Split command and it works for spaces, but I have tried the chr(13)+chr(10) for line feed…
  • Crystal 2011 report slow after Windows Update on Server 2012 R2

    Windows updates installed on 2/25/16 Server 2012 R2. Remote desktop sessions are used for our Sage 2015 version with Crystal 2011. User experienced crystal reports running extremely slow. When running these same reports from Crystal and not from Sage…
  • Crystal Report 2011 - Need to install full version?

    I recently upgrade from MAS200 4.4 to MAS200 2014. the version of Crystal reports for 4.4 will not work when creating custom reports in the NEW MAS200 2014. I need to install a full version of crystal reports 2011, it usually is on the MAS200 CD or…
  • Crystal Reports 10-Failed to export the report to pdf

    Just started with this error in December 2015. Users of both DC Reader and Acrobat Standard XI, Windows 7 ,Mas 4.2. Not sure if MS or Adobe update caused the issue. Any help is appreciated!
  • ODBC Crystal Reports driver - does not look accurate?

    I have reports that when I go into designer I see the ODBC connection and it not using the SOTAMAS90 ODBC connector, it has some other type of connection. I do not think it is correct and if someone can explain the connector and how to fix it I would…
  • How to change XML Export Schema in Crystal Reports 2011

    So there is a feature that seems to be included in CR 2011 that was not available in CR XI. It appears that we now have the ability to change the XML Schema for exporting from Crystal. The problem is that I can't figure out how to utilize it. Before…
  • Crystal - template expert

    Template expert is grayed out. How can it be accessed to apply/change a template?