Automatically Running Macros Did you know that you can automatically run macros you have created when you run your report in Alchemex? Why would you want to do this? Macros can be very powerful for doing many different things in Excel (e.g. formatting, filtering and securing data.) This makes the report one step closer to […]

Continue reading

Automatically Running Macros Did you know that you can automatically run macros you have created when you run your report in Alchemex? Why would you want to do this?   Macros can be very powerful for doing many different things in Excel (e.g. formatting, filtering and securing data.)   This makes the report one step […]

Continue reading

Did you know you can create Excel formulae as data expressions in the Administrator module? This can be very useful if you have a Formula you need to be extended as far down the sheet as the rest of the data. How to create an Excel Formula in your Report Open your Administrator Module and […]

Continue reading

Did you know you can view the SQL code passed by Alchemex to the ODBC driver in the Administrator? This can be very useful if you are developing a report but keep getting a “Report Execution Error”, you will be able to see exactly what is passed to the ODBC driver, including Table joins, Sort […]

Continue reading

Using Variables in Other Report Properties Variables (System and Pass Through) variables can also be used in certain properties on a report to dynamically affect them when a report is run. Some scenarios where this might be useful are listed below: Example 1 You are specifying an output file in the “Generate Output File” property […]

Continue reading

Using System Variables System variables can be used with Parameters and Filters to dynamically determine a comparison Value at report Run Time. An example of this is where a report is run and expected to return data for the current day. In this example a Filter could be set on the report for a Date […]

Continue reading

Run All Reports in Folder The Run Report Batch facility allows users to run a sequence of reports one after the other from top to bottom. The option Run Report Batch aborts the batch of reports if any of the reports return no data. The second option Run Report Batch (Mode 2) will run all […]

Continue reading

Enabling the BI Tools Tab in Microsoft Excel Note: This applies only to the Report Designer or Excel Genie Enabled Reports If the BI Tools tab is missing in Microsoft Excel it could be due to the following: BI Generator could be inactive BI Generator could be disabled BI Generator Installer files may need to […]

Continue reading

Retaining Items Deleted from the Data source If you create a new report, in PivotTable format, using Alchemex, off a standard container then when you export this report and import it into another database, by default it will retain the filter fields that were used in the original report. To see, use the filter fields […]

Continue reading

Is there a way to convert an Alchemex report automatically to a PDF file? This can be done by using the Generate Output file option that can be made available by selecting your report in the Report Manager and checking the Show Advanced Checkbox on the Properties Tab               […]

Continue reading