Content-Type: |
multipart/mixed;
boundary="_002_CY4PR03MB2567D03437C1FDEC75490F7C86A60CY4PR03MB2567namp_" |
Date: |
Tue, 8 Nov 2016 15:01:43 +0000 |
Reply-To: |
|
Subject: |
|
From: |
|
Message-ID: |
|
In-Reply-To: |
|
MIME-Version: |
1.0 |
Sender: |
|
Parts/Attachments: |
|
|
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.
|
|
|