Database consults

Porcitec includes a set of powerful tools to analyze the data. Often the same question can be solved using one or more types of the Report Designer. For example, the number of females removed by removal reason is a distribution. We can use the Histogram, List Data, or Query report designers. All reports show the same results.

All report designers use the variable system, see Agritec Variable Dictionary. The variables are defined in this document. Additionally you can create new variables from the existing ones using mathematical expressions or functions.

This chapter will serve as a tutorial for using the database tools included in Porcitec. It has been designed like a forum, you will find dozens of questions that Porcitec users have sent us and the corresponding solutions. We try to show how to solve questions using the several types of report designer, however you may use the one most comfortable for you.