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
Alchemex Tips
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
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
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
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
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
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
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
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
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