How to vertically centre

Question

Hi

How to display Sr no like below . I am using Crystal report version 16

Sr	Name
1	aaaaaaa
2	aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
	aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
	aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
	aaaaaaaaaaaaaa

Thanks

Jignesh Kumar · Answer

Hello Ramco, Have you tried Can Grow check box enable, Right click on your field, then Under the Common tab, set text rotation to 90 degrees and set the Can Grow check box to on

Lokesh Varman · Answer

???????Let me know if it works Right-click on the field representing the Sr. No (the formula field or database field you used for generating the Sr. No). Select "Format Field" from the context menu. In the "Format Editor" window that appears, go to the "Common" tab. Look for the option called "Vertical Alignment" or "Text Interpretation" (depending on your Crystal Reports version). Choose "Center" from the drop-down list for the vertical alignment. Click "OK" to apply the changes.

Lokesh Varman · Answer

To display serial numbers (Sr no) in a Crystal Report, you can create a running total to serve as the counter. Unfortunately, Crystal Reports does not have a built-in feature to directly display serial numbers. Here's how you can achieve this using a running total: Open your Crystal Report in Crystal Reports version 16. Insert the necessary fields (Sr and Name) into your report. Create a formula to generate the Sr no. To do this, go to "Field Explorer" -> "Formula Fields" -> "New." Name the formula something like "SrNumber" and use the following formula: // {@SrNumber} formula WhilePrintingRecords; Global NumberVar SrCounter; SrCounter := SrCounter + 1; Place the formula field ({@SrNumber}) in the Details section of your report, where you want the serial numbers to appear. Right-click on the formula field and select "Insert" -> "Summary." In the "Insert Summary" dialog box, choose the following options: "Type of Summary": Running Total "Field to summarize": {@SrNumber} "Type": "Count" "Evaluate": "For each record" "Reset": "On change of group" (if you want to reset the serial number count for each group, otherwise, choose "Never" if you want continuous serial numbers throughout the report). Click "OK" to create the running total field. The running total will increment for each record, effectively displaying the serial numbers in ascending order as desired. Preview your report, and you should see the serial numbers displayed correctly in the Sr column.

Ramco Ramco · Answer

Hi Lokesh My question is to how to display Sr.No vertically centered as per scenario shown. I am able to generate Sr No. Thanks

Ramco Ramco · Answer

Hi Jignesh It is running total field . CanGow option is appearing disabled. . I want if Description is of 5 lines then height of Sr No should be 5/2 and it should appear as Vertically centered. If it is 7 then 7/2 and so on Thanks

How to vertically centre

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (5)