Posts

Showing posts with the label Report

columns in a columnar section have automatic totaling?

No, but you can add totals to a columnar section by creating a level break footer section.

How many body sections can you create initially when using the Report Design Director?

Only one section can be created initially when using the Report Design Director but additional sections can be added later.

What four types of body sections can you create in a report?

Columnar, group, tabular, financial (application specific)

What is the function of the Report Design Director?

The director guides you through all the steps of creating a report section.

What must you have in a report body section to extract information from a database?

A business view, this links the report section with the data in a table.

If you wanted the report you created in the previous question to have employees listed alphabetically, what feature would you use to accomplish this?

Data sequencing allows you to list your data in the order that best fits your needs.

If you needed to create a report that included data for employees only, what feature would you use to filter the data?

Data selection allows you to filter your data to provide you with only the records that are of interest to you.

Creating a report including several columns that require totaling would lend itself to which type of section?

A tabular section as it provides a columnar layout with automatic column totaling.

If you need to create a report section that lists rows of data beneath a heading with no need for totaling you would use which type of section?

A columnar section would provide you with rows of data beneath a heading.

If you were creating a report requiring a free-form layout, which type of section would you choose?

A group section as it allows you to place fields in a free-form manner.

Name three of the things you must consider when first planning your report?

Layout of section, content, headers/footers, page breaks, section breaks, and group breaks.

Custom Section in Report

Custom Sections allow you to control, through event rules, the information that prints on a report. We can use Custom Sections to print additional information depending on certain criteria.

Text Variables

Text Variables are used to store strings, which can be attached to the reports using Event Rules. They are used as alternative to hard coding text strings in assignments.

Subsection Join

A subsection join is used in specific circumstances to present data from two different business views in the same report using two sections (a parent and a child) each with a different business view attached. You must join your parent and child sections on common key fields

Columnar Section

The layout of a columnar section consists of column headings with the associated column values listed under the headings. Each data field is a column, and each record is a row. The column heading is linked to its column data, and the two cannot be disconnected in the report. If one is deleted, the other is deleted also. Because you cannot change the column format, the columnar section is the least flexible detail section.