TMSUSERS Archives

The Museum System (TMS) Users

TMSUSERS@SI-LISTSERV.SI.EDU

Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
From:
Christine Droll <[log in to unmask]>
Reply To:
The Museum System (TMS) Users
Date:
Tue, 8 Nov 2016 15:01:43 +0000
Content-Type:
multipart/mixed
Parts/Attachments:
text/plain (1493 bytes) , Capture.JPG (47 kB)
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.

ATOM RSS1 RSS2