Question: I have made several changes and customized the original Sales report that shipped with my Alchemex Software. Is there any way I can get hold of the original sales report? Answer: Yes, you can download the standard Alchemex report from the report download community. You will need your Alchemex software password to do […]
- Solutions
All Solutions
- Standalone Reporting Tool
- Sage Intelligence for Accounting
- Sage 300cloud Intelligence
- Sage 50cloud Pastel Intelligence Reporting
- Sage Pastel Payroll Intelligence Reporting
- Sage 100/200 Evolution Intelligence Reporting
- Sage 100 Intelligence Reporting
- Sage 300 Intelligence Reporting
- Sage 500 Intelligence Reporting
- Sage VIP Intelligence Reporting
- Resources
All Solutions
- Standalone Reporting Tool
- Sage Intelligence for Accounting
- Sage 300cloud Intelligence
- Sage 50cloud Pastel Intelligence Reporting
- Sage Pastel Payroll Intelligence Reporting
- Sage 100/200 Evolution Intelligence Reporting
- Sage 100 Intelligence Reporting
- Sage 300 Intelligence Reporting
- Sage 500 Intelligence Reporting
- Sage VIP Intelligence Reporting
Additional Reports
Download our latest Report Utility tool, giving you the ability to access a library of continually updated reports. You don’t need to waste time manually importing new reports, they are automatically imported into the Report Manager module for you to start using.Sage Intelligence Tips & Tricks
Our Sage Intelligence Tips and Tricks will help you make the most of your favorite reporting solution.Excel Tips & Tricks
Our Excel Tips and Tricks will help you improve your business reporting knowledge and skills.- Learning
- Support
All Solutions
- Standalone Reporting Tool
- Sage Intelligence for Accounting
- Sage 300cloud Intelligence
- Sage 50cloud Pastel Intelligence Reporting
- Sage Pastel Payroll Intelligence Reporting
- Sage 100/200 Evolution Intelligence Reporting
- Sage 100 Intelligence Reporting
- Sage 300 Intelligence Reporting
- Sage 500 Intelligence Reporting
- Sage VIP Intelligence Reporting
Additional Reports
Download our latest Report Utility tool, giving you the ability to access a library of continually updated reports. You don’t need to waste time manually importing new reports, they are automatically imported into the Report Manager module for you to start using.Sage Intelligence Tips & Tricks
Our Sage Intelligence Tips and Tricks will help you make the most of your favorite reporting solution.Excel Tips & Tricks
Our Excel Tips and Tricks will help you improve your business reporting knowledge and skills.Get Support Assistance
Can’t find the solution to the challenge you’re facing in the resource library? No problem! Our highly-trained support team are here to help you out.Knowledgebase
Did you know that you also have access to the same knowledgebase articles our colleagues use here at Sage Intelligence? Available 24/7, the Sage Intelligence Knowledgebase gives you access to articles written and updated by Sage support analysts.Report Writers
Having some trouble creating or customizing the exact report you need to suit your business’s requirements? Contact one of the expert report writers recommended by Sage Intelligence.- Sage City
- University
- About Us
- Contact Us
Home Archives for alchemextips
Using PivotTables To Create Report Templates
When using a PivotTable in the template file take the following into account: PivotTable Limitations – ensure that you do not display too many row fields that could cause the pivot table limitation to be reached. Use report filter/page fields where necessary to further summarise data. When pivoting data from a source data sheet where […]
Using Slicers and Sparkline’s in Excel Report Templates
When developing a template using Alchemex, it is recommended to do so using Excel 2003 and to link the template back as an .xlt file. This will ensure that the template is compatible on all versions of Excel. However if you want to use Sparkline’s and slicers in your reports you need to make you […]
Like Operator
The Like Operator is used in Filters and Parameters for doing pattern matching. Combinations of literal characters and wildcard characters can be used to locate patterns. The two wildcard characters that are supported by most Data Access Drivers are the _ (underscore) wildcard; which means any single character, and the % (percent) wildcard; which means […]
Direct SQL Query Tool
The Direct SQL Query tool allows direct interrogation via SQL of data within your Administrator defined Data Connections. The query tool allows only SELECT queries and {call} type queries for stored procedure execution (if supported). UPDATE, DELETE and INSERT and DDL (Data Definition Language) queries are not allowed. Launch the tool from your Administrator Click […]
Compacting MetaData
Compacting your MetaData occasionally can result in improved system performance. Depending on your usage levels it may be desirable to do this more often. Select File Then select Compact Metadata A window will appear stating that Alchemex Smart Reporting must shut down Select Yes The Maintenance Utility will then open Select Compact SVD A Confirm […]
Comparison Methods
What are comparison methods? Comparison methods are used with Filters and Parameters to refine or limit the rows that are returned to a report. Below is a list of Various Comparison Methods with an example: Comparison Method Example Search Objective Alpha /Numeric Equal To South Africa True when the expression contains ‘South Africa’. Both Greater […]
Date Formats
Date Formats Different database systems store and recognise dates in different formats. Alchemex Smart Reporting attempts to hide this detail from its end users by translating dates at run time into a recognizable format before passing the date to the underlying Database System. In order for Alchemex Smart Reporting to know how the Database System […]
Operating System Functions in Alchemex
Operating System Functions in Alchemex The following Add-In functions for operating systems are available within Alchemex. Select a report and select show advanced options. Select the run Ad-Ins option and select Operating System Functions Module. The Add-In functions below will be available: Function Description Use When DeleteFiles Deletes a list of specified files You […]
Viewing the raw data before it’s passed through to Excel
Did you know you can view the raw data of a report before it’s passed through to Excel? This can be very useful if you need to quickly check to see if you are getting the right data from your container or that your filters and/or parameters are working correctly without waiting for the data […]
Return to topLearning
Sage South Africa© Sage South Africa Pty Ltd 2020 . All Rights Reserved.