Accessing custom fields in order information screen

Discussions related to Crystal Reports development.

Moderator: Lisa Ennis

Post Reply
sweinstock
Posts: 18
Joined: Thu Jun 16, 2016 2:45 pm

Accessing custom fields in order information screen

Post by sweinstock »

I have values saved in the order information screen custom fields. I need to retrieve them from the database, but I can't seem to find them. (Label, value)
The custom fields from the other screens are in the entity table but these are not there.

Thanks
Lisa Ennis
Posts: 84
Joined: Thu Sep 11, 2008 1:57 pm

Re: Accessing custom fields in order information screen

Post by Lisa Ennis »

The order information screen has lots of business objects (Order, Loan, Property, Contacts), so they may be on a different object than Order. In your custom field manager, double check which object they were added to. Also, you will only see the tags in the XML if there is data actually entered in the field, it won't be there for every order. Once you determine the object, you will use the type# field to determine the object in the Entity table.
Lisa Ennis
Senior Report Developer
SoftPro
Post Reply