This is how I pull for more than one text type (see attached jpg).



-----Original Message-----
From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Sarah Nankivell
Sent: Tuesday, November 08, 2016 8:38 AM
To: [log in to unmask]
Subject: Record selection by text status

Hello! I am trying to modify a subreport for an exhibitions module report in Crystal Reports. Currently, the record selection formula is set to pull text entries from the objects module that are of a certain text type (in this case, the text type is "Label - Brief"). However, I would like this subreport to pull text entries that are both of the 'Label - Brief' type as well as having been assigned a certain text status (in this case, the status is called "*Approved").

My current record selection formula looks like this:

{TextTypes.TextType} = "Label - Brief" and {TextEntries.TableID} = 108 and {TextEntries.ID} = {?Pm-Objects.ObjectID}


Any help would be appreciated, thank you!

To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email:

     signoff TMSUSERS

     //  eoj


You will receive a confirmation that your subscription has been removed.

To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email:

     signoff TMSUSERS

     //  eoj


You will receive a confirmation that your subscription has been removed.