Reports defined in this window can be used for lot closeouts, invoicing, inventory, or any other lot based report. The information printed can be based on the full lot or an owner's percentage of the lot and can be narrowed down to a small time period. While most reports will be based on individual lots, you can also define reports that will print information from a combined detail from several lots or the result of comparing details.
Print Detail reports are section based, meaning that you specify which sections you wish to print in which order for the report. Each section can be customized and you can print the same section multiple times with different customization if you like. However, not all sections will make sense to print in all situations. For example, you cannot print the Pens section when dealing with a comparison detail.
Often, print detail reports are printed with a date range in mind. For example, invoices are generally printed for a certain month of activity. That doesn't mean that you want all the information in the report confined to what happened during that month. Using the same example, you would want the billing section of the invoice to show dollar values for the billing month, but you would probably want to show production information based on the entire life of the lot. Likewise, you may want some aspects of the report to only print the owner's percentage when an owner is involved. This is where the idea of a period type comes into play.
In most sections there will be a place to specify which period you want to use. For some sections you specify the period for the entire section. For others you can specify the period for each piece of information you want to print. Remember that you can print the same section (or element within a section) multiple times so you can show the same information based on different periods if you want.
Here are the possible periods types you will encounter:
For sections where you specify the period type for the whole section, you will find a popup labeled Period at the top of the Section Options area which you can use to specify the period type. For the other kind you will see a Period column. Right-Click or Double-Click a row in the Period column to change the period type.
Every section has a heading and comment area. When you add a new section, its heading is set to a default value which you are welcome to change. The comment area is blank by default, but you can enter any thing you like. The heading and comment (if any) will be printed at the top of the section when the report is run. So, if you want to add explanatory comments describing the information in the section, this would be a good place to do so.
You can also change the labels of elements and columns in the sections. Just Double-Click the label of the element or column in the list to edit it. This is especially helpful if you want to describe the data differently or if you have the same information printed multiple times in different periods and need to distinguish each one for the reader.
Several areas of a report, including section headers and comments, have a variable insertion button (
)next to them. You can use this to insert a variable in the text. When the report is printed, the variable will be replaced with other information. For example, if you inserted the <<LotName>> variable, it would be replaced with the name of the lot the report was currently being printed for.
You can change the ruler units with the popup at the top right of the window. These units affect the page margins and column widths for column type sections. When you are changing one of these values you can enter a measurement directly or you can use the Up Arrow and Down Arrow keys to change it. For example, to change the width of a column in a section, Double-Click the column width and then use the arrow keys to change the width just a little bit. You can also hold the Shift key down while you use the arrow keys to change by a larger amount. Notice that the total width value at the bottom of the section also changes to reflect the new values.
In most of the sections, you add or remove elements or columns using the + and - buttons. These sections will also have a Default Set button. If you click this button it will remove any elements or columns currently in the list and then add just the default ones. If you Alt-Click (Option-Click on Mac) this button, it will add any elements or columns that are not currently in the list. This is a quick way to add all possible information in a section.
If you Alt-Click (Option-Click on Mac) the + button to add an element or column, Fusion will only list the elements or columns that have not yet been added. This can make it easier to find the item you want to add.
You can also change the order that the elements or columns will print by drag and dropping within the list.
Make sure you enter a report name that is descriptive since this is how you will identify the report from other areas of the Lot Center window. The name must be unique.
The report options is where you set up the report's headers, layout, and description. Select one of these options from the list in the top left of the window.
Every report that prints will have a section at the top of the first page with your company logo on the left side and company address on the right side. In the middle are up to three lines that give a title to the report. The top line is the largest, so is the main title. The middle line can be thought of as a subtitle and the bottom line is the smallest for a sub-subtitle.
If the report ends up being more than one page long, subsequent pages will have a small header printed at the top. Use this to enter the left, middle, and right portions of that header. These might be the same as the first page report headers and might include the page number.
The headers are a good place to make use of the variables that can be inserted to give context for the report.
These settings allow you to specify whether the report prints in portrait or landscape and the print margins.
This area is where you can make notes to yourself about the usage of this report. It is not printed, but it will show up in some areas within Fusion where you can select which report you want to print.
On the left side of the window you can include which sections you want to print. Click the + button and then choose from the list of possible sections to add. To remove a selection, select it and then click the - button. You can also drag and drop sections to reorder them. Fusion will print them in this order. Remember that a section may be included multiple times.
As mentioned above, each section will have a section heading and comments area which you can change. Most of the sections will have additional options so you can customize them. Let's take a look at each section type.
This section is useful anytime you want to simply add some explanatory text to the report. Although each section provides a place to do that for the section, you may want to insert comments after a section, at the end of the report, or other areas. This section allows for that.
In the Lot Center window you can combine multiple lots for the detail area and then print a detail report for the combined lots as one. If you include this section in that situation, the section will list the lots that have been combined together.
The elements available to print here are based on the Basic Info and Extra Info sections of the Lot Center window. The elements will be printed in two columns in the same order as here.
There are several billing related columns you can choose to include in this section. In addition, you can have Fusion include the per unit, per animal, and per day breakdowns for each column. There is also an option to have Fusion include the billing information for previous periods. This last option is mainly for invoicing and lot closeouts and will not work if the report is printing for a combined lot detail.
These elements are based on the Profit/Loss section in the Lot Center window.
These elements are based on the Production section in the Lot Center window.
These elements are based on the Projections section in the Lot Center window.
These elements are based on the Carcass Adjusted Values section in the Lot Center window.
If you just want to show some feed related totals, there are elements in this section for that.
If you want to break down feed usage by ingredient, use this section.
If you want to break down feed usage by ration, use this section.
If you want to break down feed usage by ration version, use this section.
This section is where you can summarize the drugs used by the lot. If you include the Category column, the drugs will be broken into categories and summarized for each category. If you exclude it, the drugs will stand on their own.
| There is also an option to include a treatment only row. In the past, Fusion's ability to categorize drugs was limited because a drug could only be in one category. To get around this, this option was added. It calculates the drug usage during any treat subjob independently of the category of the drug. This option is left in for legacy purposes, but since Fusion can now categorize drugs by usage as well, we don't recommend using this option anymore. |
This section summarizes the inputs used. If you include the Category column, the inputs will be broken down by category and summarized for each.
This section will print a row for each day and show information such as the count and weight on that day.
If you want to show Other Items billing information, include this section.
This section will print any ownership arrangements for the lot that were active during the period type printed for unless Only Print Current Ownership is checked. Then it will only print the ownership arrangement current on the last day of the period.
Note that this section will only print for individual lots, not for combined details or comparison details.
This section prints information about each in cohort in the period. It will work for individual lots and for combined details, but not for comparison details.
There is an option to include the lot override values. If you have overriden the in cohorts for the lot and turn this option on, an extra line will be included to show the overriden totals. This option will be ignored for combined details. Now that you can edit cohorts, we no longer recommend overriding lot information.
This section is the same as the In Cohorts section, except for non-death out cohorts.
This section is the same as the In Cohorts section, except for death out cohorts.
This is based on the Morbidity section of the Lot Center detail area. It will not print for comparison details.
This is based on the Mortality section of the Lot Center detail area. It will not print for comparison details.
This section will list the pens the lot is in on the last day of the period. It only works for one lot, not for combined or comparison details. By default it will only look at drug withdrawals when calculating the pen withdrawal, but you can have Fusion include the feed withdrawal information if you are using Fusion that way by turning on that option.
This section will print a list of animals that belong to the lot. It only works for one lot, not for combined or comparison details.
| This section is left here for legacy purposes. We recommend using the new Inline Child Report section instead to print a list of animals as you will have more control over what is printed that way. |
This section allows you to include inline reports in a similar way that you can add inline reports in Advanced Print reports or open child windows from list window. An Advanced Print report must previously be defined. When you add this section you will also need to choose which child type to include.
Once this is done, you can choose the link type. The link type determines which items will automatically be included in the other report. For example, if you were inlining the Contacts list, you would choose to link to the contacts based on the lot's cattle buyer or originating herd.
You can choose an advanced search (which must have been previously set up) to further narrow the items which will be included in the inline report. Similarly, you can choose an Advanced Sort to determine how the items will be sorted before printing. And, of course, you must choose which Advanced Print report definition will be used during the inline reporting. (This report may also include inline reports itself, up to 20 levels deep.)
There are checkboxes to specify whether you want the header rows, body rows, etc. to be printed.
When Fusion goes to print an Inline Child section, it will print the section heading and comments and then print the inline report. Once done, it returns to printing the next section. Of course, you can have as many Inline Child report sections as you like.
You can open this window by creating or editing a detail report in the Print Detail window.
