User Defined Reports

Columns in a user-defined report (UDR) may include values from analysis results, formulas, and expressions. This article describes the order in which columns are calculated and how formulas and expressions may use values in other columns.

Knowing the sample turnaround time for specific samples processed within your lab can be a valuable managerial tool. This article shows you how to use sample dates and times and a user-defined report (UDR) to calculate this important met...

If you produce invoices in LIMS 4.0 with an Excel template and you enable the template’s option to save the invoice number and date to the LIMS, you can create a simple invoice summary user-defined report (UDR) to track invoiced samples.

Q: “Attached are the versions of the UDR set up and the output. … I would also like an average turn around. Would I copy the formula from the MSC LIMS insight Jan 07 page 4, bottom right into the ‘text’ section for “headers and footers”?”

While previewing any LIMS report, you can use File | Output To to save the report to one of several file formats supported by Microsoft Access 2002. If you try the available formats you may find the rich text format useful. However, the...

Q: Is there some way you could write a macro when doing the COAs to put an automatic footer on the report if in the results there is an *? In our old system, * stood for Estimated plate count and when a report had the * it would automati...

This article describes a technique that can speed development of a user-defined report (UDR) by using both the report definition and generate forms to incrementally develop and test the report.

When creating a user-defined report (UDR) it is often necessary to display a value that is derived from one or more analysis results. This article describes a simple technique used to hide a column whose value need not be displayed but i...

Prior to LIMS version 2.2, a user-defined report (UDR) column with an expression could not include summary statistics. Beginning with version 2.2, all summary statistics except geometric mean can now be used in UDR columns with VBA expre...

Q: Main Menu → Samples → Data Entry/Inquiry → Sample Login In addition to the Collected and Received Date/Time fields, we need fields for the Start Date/Time and End Date/Time of the analysis. This is essential for drinking water microor...