Alchemex Tips & Tricks

It is handy to be able to hide reports that do not need to be run separately, but only as sub reports of a union report.  This will give your object window in the Report Manager a neater look. To hide a report: Select the report in the Object window of the Report Manager, under [...]

{ 0 comments }

Quick Navigating between Report Manager and Administrator Did you know you can quickly navigate from the Report Manager to the Administrator tool, taking you directly to the appropriate container or expressions that need changes made? 1.  How to Quickly Navigate to the Appropriate Container a.  Open your Report Manager b.  Double click on the report, [...]

{ 0 comments }

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

{ 0 comments }

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

{ 0 comments }

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

{ 0 comments }

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

{ 0 comments }

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

{ 0 comments }

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

{ 0 comments }

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

{ 0 comments }