![]() Finally, it is appended with the LastName field and then assigned the keyword formula. It is "built" by first assigning the FirstName field to it and then testing for a MiddleName with an If Then conditional statement. The variable declared is called fullName. The fields may be pulled from the ADO OLE DB connection or from the Report fields. In the Editor, select Basic Syntax from the toolbar to create code in Visual Basic. Click Use Editor to get into edit mode for the formula. The popup box requires a name to be entered (in this case, it is ContactName). In the Field Explorer, right click on Formula Fields and click New. To create a new "field" that contains the complete name, a formula may be created. ![]() To fix this, the FirstName, MiddleName and LastName fields will be removed from the report by clicking on each textbox and pressing delete or right clicking and selecting Delete from the Context Menu. The appearance of the Contact Names does not look pleasing in the report. In Propeties, the HorAlignment can be set to crHorCenterAlign. The textboxes in the header need to be centered. Also, I made a mistake in using the Country for the Grouping because all of the Vendors are located in the United States. The Vendor Name is cut off and the Contact Name and Addresses require formatting. The Preview of the Crystal Report is in need of some additional formatting.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |