Printing memo field from employee setup...

Question

I'm using Crystal Reports, i would like to print out the memo field from custom fields for any employees who have a memo entered? 
 
 "PRM_MASTER__EMPLOYEE__CUSTOM_FIELDS" is the table 
 and 
 "Employee_Custom_Flds_Nots: Memo" is the field 
 This is not a browsable field in Crystal Reports and if I just add tghe field to a report it prints nothing. 
 Thanks 
 V

Art Minds · Accepted Answer

Knowledgebase Solution: 24722 might also be helpful. Here is the contents of that article: 
 Cause 
 The join type to the custom field table is an Inner join. This join type will return no data to the report if there is no value in the custom field. 
 Resolution 
 
 Change the join type to Left Outer: 
 
 Go to Database , Database Expert . 
 Select the Links tab. 
 Click on the join line to select and click Link Options . 
 Select Left Outer Join and click OK . 
 Click OK to close the Database Expert window. 
 
 - ArtMinds Senior Independent Consultant Pasadena CA

Art Minds · Answer

Go to the Knowledgeable and search for Solution ID: 25043 where you will find these steps to add your custom field to the report: 
 
 In Crystal Report Writer, from the File menu, select Open . 
 Select the report design (*.rpt) you want to change. 
 From the Database menu, select Database Expert . 
 In the Data tab, select the appropriate data source and browse to the custom field record you would like to add. 
 Click the [>] to add the record. 
 In the Links tab, create a link between the appropriate fields, then click OK . Refer to Related Resources: "I added a custom field to a Crystal report and now the report prints blank." 
 Add the individual custom fields to the report as desired. 
 
 -- 
 Art Minds Senior Independent Consultant Pasadena CA

Vince Glisson · Answer

Art, 
 Choosing the correct join was the issue... 
 Sorry for the late reply... 
 Thank you for the assist... 
 v

Sage Construction & Real Estate

Printing memo field from employee setup...

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING