How to vertically centre

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

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

???????Let me know if it works 

1. Right-click on the field representing the Sr. No (the formula field or database field you used for generating the Sr. No).

2. Select "Format Field" from the context menu.

3. In the "Format Editor" window that appears, go to the "Common" tab.

4. Look for the option called "Vertical Alignment" or "Text Interpretation" (depending on your Crystal Reports version).

5. Choose "Center" from the drop-down list for the vertical alignment.

6. Click "OK" to apply the changes.

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

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:

1. Open your Crystal Report in Crystal Reports version 16.

2. Insert the necessary fields (Sr and Name) into your report.

3. 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;
   

    

4. Place the formula field ({@SrNumber}) in the Details section of your report, where you want the serial numbers to appear.

5. Right-click on the formula field and select "Insert" -> "Summary."

6. 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).

7. Click "OK" to create the running total field.

8. The running total will increment for each record, effectively displaying the serial numbers in ascending order as desired.

    

    

9. Preview your report, and you should see the serial numbers displayed correctly in the Sr column.