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 […]

Continue reading

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 […]

Continue reading

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 […]

Continue reading

You created a collection of reports that are running on a specific database you would like to test the reports on different databases. 1. In this example I’m connecting to my “TEMPDB” Database.   2. I have a different database called “DEMODATA “and I would like to run the reports on this database. All the […]

Continue reading

Using the Alchemex Administrator to Sample Specific Data You can use the Alchemex Administrator to Sample a specific data i.e. an invoice. Open the Alchemex Administrator and browse to the connection that you want to sample. Add the data container that you wish to sample; I have chosen “DocumentLines.” If you sample the data now […]

Continue reading

Selecting Multiple Columns You can select multiple columns in the report manager by using the “Crtl” or “Shift” key along with a mouse click. Hold down “Shift” for selecting multiple adjacent columns or “Crtl” for selecting multiple random columns. This is useful tip when moving, deleting or adding the aggregate function to multiple columns.  

Continue reading

If you want to move or copy a union report from one folder to another you need to export the report to an easy attainable location then import to the new folder in the Report Manager. The reason you can’t copy and paste a union report is that the sub reports then get left behind […]

Continue reading