Welcome to the Sage 300 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
We have attempted to add an optional field from ORORDDO to the picking ticket. If we run on the server, the report runs fine, but when we run on a workstation we get this error: Failed to retrieve data from the database. Has anyone seen this issue and…
I'm customizing the Ardinvo report in crystal reports. I took a copy of the report, saved it as a different file name.
Now I want to add some fields to it that are not in the set of data tables already in the report.
In the "Field Explorer" I right…
Hi, We're running Sage 300 2022. We just got Paya installed and did our first Credit Card transaction. I'm still fairly new to the usage of Sage and Crystal Reports. How do I customize our receipt confirmation report to include Order Number or an Invoice…
Created a custom crystal report for client with Date from and Date to and customer number as parameters in order for sending all invoices to a particular customer for a specific month or range of dates.
The custom crystal report on the sage server…
We have a Sage 300 2020 PU2 installation that works on most workstations, but one virtual machine running windows 10 Pro 64bit does not work.
The issue is that when we print a report - any report, it runs the database record select and then stops…
Is there a canned report (or a canned report that would require minimal manipulation) to determine the total count of commitments that were issued in any/all jobs over a given period of time?
We're trying to determine:
1) How many commitments were…
Hi All,
Problems found when we had started doing new forms/reports for Sage 300 2019.
Recently we found out that when using View Table as Data Source, the reports are unable to generate any results in Sage 300 2019, while Sage 300 2018 or earlier…
Sage 300. I have written a report in Crystal which runs great from crystal but generates nothing when I add it to the reports Menu in SAGE. I get a bit of an hourglass but no output. It is setup for preview.. Any tips on how to troubleshoot this?
Hi, I wondered if I could tap in to sage city for some advice, as I am frustrated with support.na.sage
The whole reason I am here, is that when I search the support site, I get to a issue, on the topic I want to learn about, and the article has a an…
Can anyone recommend a Sage Specialist for writing reports in the Financial Reporter in Canada? I need help and it can't be someone who is just learning to write these things, its a little complex.
We are migrating Sage to a new server. When I move over the custom crystal forms, some of them are prompting for a sa password before running. I have checked all my database connections. There is one difference between the two database connections - when…
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…
I am a complete newbie to Crystal Reporting and have watched several tutorials, but they are all for stand alone spreadsheets. I have no clue how to use information within Sage to create a custom Crystal report and how to connect the two of them.
Hi,
The requirement is to to be able to run the Crystal Report on a preset day and email it out - without manual intervention. The report is not parameterized. I have hard coded the dates.
Is this possible using Windows Task Scheduler or is there…
Greetings!
If this is the right forum, I have been having a perplexing issue with printing payroll cheques using either CPCHECK4 and CPCHK4A forms - regardless of the Advice Lines per page and MaxDetails field in the Crystal Report Design tab being…
Dear All, I would like to reprint order confirmation with different completed status in OEORDH & OEORDD. So I edited the selection formula in crystal report (oeconf01) like that. ( ({OEORDH.COMPLETE} = 1 or {OEORDH.COMPLETE} = 2) or // order header is…
Greetings,
I created a custom label report in Crystal using the Mailing Label and Report Wizard and it works well in Crystal. I saved it and am trying to open it from within Sage 300 2014 PU3 and I am getting the Error:LoadLibrary message.
Has anyone…
Datapipe report runs well in Crystal Reports preview, but when placed on desktop this error is received "..\a4wdp.c line 372".
Copied datapipe.ini file for ICSLOW and commented out stock report and entered my report name and parameter.
Copied same…
