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.