You can now conveniently download the latest Crystal Reports Designer 2020 for Sage X3 directly from our Sage X3 UK FTP Site.
Previously this would need to be downloaded directly from the SAP website.
For any licensing inquiries or questions, please…
Wondering if anyone can help me. Since the last upgrade I have been having this error anytime I open a Sage/Timberline CR Report
"The saved data will be discarded since one of more formulas failed to compile
I can create new reports without issue…
We have created a new bank account in CM module and the transactions are correct going but when trying to generate crystal report in AP module the particular bank name is not listed.The CM and AP module details and not sync.
In order to generate crystal…
Hello,
I’m new to Sage and looking to access estimates through Power BI. I’ve connected through ODBC, but I do not see how to get estimate information, only Database information.
any ideas?
Hi guys, so I am trying to add a crystal report to Sage 300 ERP however whenever I add same and run the report after entering the date range parameters, the report just freeze, wont load and also wont close when I try to close it.
I've unchecked the…
When you print a report in Sage Enterprise Management, you may be greeted with an ERR 504. Perhaps also related to a message "The system cannot find the path specified."
The problem is that this is a very generic error and does not tell us what is really…
Previewing a report to ensure proper formatting and correct results is smart. The ability for a report writer to preview a report within Crystal Reports designer can be a real time saver.
In support, we are occasionally asked how to preview without…
If you are going to preview your report design inside of Crystal reports, you likely need to know what parameters you need to use during your preview.
Not all parameter values come from user entry, some values are automatically sent by the supervisor…
I want to create or modify a Crystal report in Sage Business Cloud Enterprise Management (X3). This functionality changed as of Product Update 9.
Be sure to review the Online help for Local Crystal Report development and for more specific details…
FLAKj92,
What do you mean by "doesn't work."
This appears to work for me:
if {podetail.poline} >1 and {podetail.job}<>{poheader.job} then "See Below" else {poheader.job}
In my test, I did notice that Crystal makes an assumption on how the tables…
I am working on one Crystal and one RD report for Sage CRE. These are Job Cost reports using JC Transactions.
The reports are very very slow to return information. The computer I am using is an older Windows XP model.
Does the speed of the user…
Teresa,
It could be the 32-bit ODBC Adminstrator. You can run it from C:\Windows\SysWOW64\odbcad32.exe.
You may also want to review the knowledgebase article: Error: The setup routine for the Timberline Data ODBC driver could not be loaded due to…
SAP is the current ownder of Crystal reports. Sage 300 CRE used Crystal Reports XI. There are many resources available online.
I did find the the user's guide which you may find helpful. Chapter 23 is parameter fields and prompts.
http://help.sap…
I have created a custom Crystal Report. It has three parameters related to dates and job status.
The report runs in the Crystal application and I would like to make it available via the Sage CRE report list. I have added the new report with the filename…
I have several years of experience with Crystal Reports.
I opened Report Designer today and it is totally alien to me. The first report I am working on is RD report. I made a copy and was surprised to find no undo function.
Ordinarily I would think…
Greetings,
I am following the instructions of KB186526 to create a Date Prompt on a JC report. I am able to create the prompt fields.
I can make the design formula (using Accounting Date [JC Transaction] instead of Accounting Date [GL Transaction…
Katie,
I am glad that was helpful. It is tough to troubleshoot a report without seeing it and fully understanding what the report is designed to do. I am not sure what you mean by “breaks down again.” Troubleshooting report designs are beyond our typical…
Katie,
It helps me to think of the Sage MyAssistant condition and running the attached report as two completely different processes.
The Sage MyAssistant condition does generate a set of results, but these results generated basically tell Sage MyAssistant…
I just began using My Assistant and it looks incredible.
I am trying to set up a task that runs and emails a job costing Crystal Report. However, I want multiple conditions set.
I've set them up in My Assistant and the test works exactly how it…