Formula to calculate column height

In Crystal Reports, the concept of calculating column height isn't exactly the same as in spreadsheet or web layout scenarios. In Crystal Reports, you're primarily dealing with arranging and formatting data for printing or display, rather than calculating visual column heights.

1. **Field Height:** You can control the height of a specific field by right-clicking on the field, selecting "Format Field," and then going to the "Common" tab. There, you can adjust the height of the field by changing the "Height" value.

2. **Font Size:** If you're looking to adjust the amount of text that fits within a specific field's height, you can control the font size. You can do this by formatting the field, going to the "Font" tab, and adjusting the font size.

3. **Text Wrapping:** Crystal Reports also allows you to enable text wrapping for a field. This means that if the content is too large to fit in the allotted field height, it will automatically wrap to the next line.

4. **Adjusting Section Height:** The overall height of a section in Crystal Reports can also impact how the columns appear. You can adjust the section height by dragging the section boundary up or down in the Design view.

If you need more advanced layout control, you might consider using other tools that are specifically designed for web layouts or visual design.

// Assuming you have fields for Base Area and Volume // Replace {BaseAreaField} and {VolumeField} with your actual field names // Declare variables to store base area and volume NumberVar BaseArea := {BaseAreaField}; NumberVar Volume := {VolumeField}; // Calculate height using the formula Height = Volume / Base Area NumberVar Height := Volume / BaseArea; // Return the calculated height Height

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Cr Bhargavi3y ago
In Crystal Reports, the concept of calculating column height isn't exactly the same as in spreadsheet or web layout scenarios. In Crystal Reports, you're primarily dealing with arranging and formatting data for printing or display, rather than calculating visual column heights.

1. **Field Height:** You can control the height of a specific field by right-clicking on the field, selecting "Format Field," and then going to the "Common" tab. There, you can adjust the height of the field by changing the "Height" value.

2. **Font Size:** If you're looking to adjust the amount of text that fits within a specific field's height, you can control the font size. You can do this by formatting the field, going to the "Font" tab, and adjusting the font size.

3. **Text Wrapping:** Crystal Reports also allows you to enable text wrapping for a field. This means that if the content is too large to fit in the allotted field height, it will automatically wrap to the next line.

4. **Adjusting Section Height:** The overall height of a section in Crystal Reports can also impact how the columns appear. You can adjust the section height by dragging the section boundary up or down in the Design view.

If you need more advanced layout control, you might consider using other tools that are specifically designed for web layouts or visual design.

Tahir Ansari3y ago