x Want to participate? Join the group to interact
  • State Verified Answer
  • +1 person also asked this people also asked this
  • Replies 3 replies
  • Answers 2 answers
  • Subscribers 239 subscribers
  • Views 545 views
  • Users 0 members are here
Browse Forums
Sage 100 Contractor Announcements
119
topics
57
replies
Sage 100 Contractor General Discussion
1k
topics
4k
replies
Sage 300 CRE Announcements
168
topics
526
replies
Sage 300 CRE General Discussion
3k
topics
9k
replies
Sage Construction Management Announcements
4
topics
0
replies
Sage Construction Management General Discussion
16
topics
21
replies
Sage Estimating Announcements
39
topics
3
replies
Sage Estimating General Discussion
189
topics
448
replies
Vince Glisson

Printing memo field from employee setup...

SOLVED
Posted By

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

  • 0
    SUGGESTED

    Go to the Knowledgeable and search for Solution ID: 25043 where you will find these steps to add your custom field to the report:

    1. In Crystal Report Writer, from the File menu, select Open.
    2. Select the report design (*.rpt) you want to change.
    3. From the Database menu, select Database Expert.
    4. In the Data tab, select the appropriate data source and browse to the custom field record you would like to add.
    5. Click the [>] to add the record.
    6. 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."
    7. Add the individual custom fields to the report as desired.

    --

    Art Minds
    Senior Independent Consultant
    Pasadena CA

  • +1
    verified 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:

    1. Go to Database, Database Expert.
    2. Select the Links tab.
    3. Click on the join line to select and click Link Options.
    4. Select Left Outer Join and click OK.
    5. Click OK to close the Database Expert window.

    -
    ArtMinds
    Senior Independent Consultant
    Pasadena CA

  • 0 in reply to Art Minds
    SUGGESTED

    Art,

    Choosing the correct join was the issue...

    Sorry for the late reply...

    Thank you for the assist...

    v

*Community Hub is the new name for Sage City