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

Continue reading

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

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