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

Continue reading

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

Continue reading

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

Continue reading

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

Continue reading

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

Continue reading