Alchemex Tips & Tricks

I am using the Add-in Auto emailing for my Alchemex reports, but would now like to email the reports to a distribution list. Is this possible? Currently Alchemex does not allow for sending to a distribution list but there is an easy way for you to send these reports to people in a distribution list. [...]

{ 0 comments }

I would like to hide the source or raw data in my final report.  Is this possible? Yes, you can hide the first sheet containing your raw data. Method In Report Manager, select your report. In the Properties window, click Show Advanced. Click Hide the Source Data in Report and click Apply. When running your [...]

{ 0 comments }

I would like to create a Pivot to neaten my data but do not know Excel too well.  Is there an easy way within Alchemex to create a Pivot? Yes, you can use an Alchemex add-in to quickly create a Pivot. Method Run your report, in Excel select the Add-ins tab on the Ribbon, and [...]

{ 0 comments }

My users are not always sure what they are selecting when asked for a Parameter.  Can I supply a description to the Parameter as guideline? Yes, you can add a short description to the Parameter field.  When the field gets populated the description will be replaced. Method 1. Add a Parameter to your report by [...]

{ 0 comments }

I’ve added several Expressions to my container and could Lookup the values in the Report Manager. When I added a Pass through Variable though, I can no longer Lookup the values?  Can I add a Lookup to a Pass Through Variable? Yes you can, by allowing lookups in the Administrator module. Method 1. When adding [...]

{ 0 comments }

Field names in databases are often difficult to interpret. Using user-friendly names enables you to understand the field’s contents more easily. For example we are unable to tell from the expression Name whether the expression refers to a customer name or salesman name. Changing the expression: Name to Customer Name makes the expression less ambiguous. 1. Click [...]

{ 0 comments }

Alchemex offers the facility to consolidate data across more than 1 company or database. To enable the report to prompt for connection information at run time and therefore give us a choice which database to run from, we need to modify the Alchemex Administrator module to be dynamic.  The connection properties need to be modified [...]

{ 0 comments }

To change an xlt (Excel 2003) template to an xltx (Excel 2007) template the following steps need to be followed. Run your existing Excel 2003 report out as normal in Excel 2007 Minimise Excel 2007 Go back to Report Manager and unlink the xlt template from the report by selecting the Unlink Template icon Confirm [...]

{ 0 comments }

When consolidating multiple databases we sometimes need to be able to see which accounts belong to which Company dataset in our Income Statement and Balance Sheet. We do this by appending the Company name to the account number to ensure that each account number is unique. Amend the expression containing the account number simply by [...]

{ 0 comments }