Formatting a section

[VB400]

When I double click on a section, it takes me to VB code as follows:

Private Sub Section3_Format(ByVal pFormattingInfo As Object)

End Sub

It made sense to me that I can format data here before it prints. For example, I thought I'd be able to format a phone number before printing or other complex formatting. I can't figure out how to do it.

Formula fields can be a bit difficult to deal with when the data is not consistent. For example, formatting a Date field that has been stored as a numeric field in the database (6 digits yymmdd) or formatting a social security number field if it is present in the record, etc.

I know in Access, you can format data before a section is printed. Can we do this in CR6?

Any help or guidance is appreciated.

Thanks! Tarek

 

[kenhamady]

The options that you are describing are not 'formatting' in Crystal terms. To see the formatting options for a field, right click on the field object and select Format - Field. The two examples you describe would need to be done in using a formula. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)

 

[VB400]

Thanks Ken -- I was hoping that I can do my formatting in VB code as it is much easier than with CR. Tarek