text object with font size 7 is missing top portion

[Former Member]

Reports that previously rendered correctly in Crystal Reports 8.5 is having vertical truncation when using Crystal Reports XI.

Further, when we export the reports to text file, fields where the top portions of text are lost are removed completely in the resulting text file.

The question is how to preserve the font size 7 in the reports in Crystal Reports XI? We have applied Service Packs 2, 3, and 4 but without success on this issue.

[former_member11696]

Please re-post if this is still an issue

[Former Member]

Thanks Purva for your posting. The export issue is actually a manifestation of the underlying problem which is that these reports used to render correctly in CR 8.5 but in CR XI, both tempate and data in the reports are rendered with vertical truncation.

I can present a graphical view of the issue if there is a way to upload a screen shot.

[Former Member]

Hello Sam

The export format relies on the Character per inch (CPI) Option in the Export menu. The CPI option controls the amount of text exported.

To control the behavior, it is necessary to modify the amount of exported text with the CPI option. Since the text exporter uses a fixed pitch font, it is solely controlled by CPI. When not enough text is exported, use a larger CPI. Always use the smallest font size in the report as the reference. Determine how many characters of that font fit in a horizontal inch, and use that as the CPI.

Calculate the characters per inch with the following methods:

A 10-point font has characters 6 points wide and 10 points tall. There are 72 points in an inch. The CPI for a 10-point font is 12 (72 / 6 = 12 CPI).

A 12-point font has characters 7.2 points wide and 12 points tall. The CPI for a 12-point font is 10 (72/7.2 = 10). The ratio for the courier font is typically 6:10.

To improve the similarities between what is seen on the screen and in the text of the exported document

use fixed pitch fonts (for example, Courier)

use the same font size throughout your document

choose fonts that are a multiple of that font size.

I hope this helps.

Regards

Purva Naik

[Former Member]

cpi in excel or crystal and does it work for version 8.5?