It works perfectly now - thank you! On Tue, Nov 8, 2016 at 10:19 AM, Chad Petrovay <[log in to unmask]> wrote: > Make a new Crystal report, and only include the table > [dbo].[TextStatuses]. Include the [TextStatusID] and [TextStatus] fields in > Details section, and preview. Voila! Now you can find the appropriate > TextStatusID for your formula. > > On Tue, Nov 8, 2016 at 10:13 AM, Sarah Nankivell < > [log in to unmask]> wrote: > >> Thank you for your response, however what I am trying to figure out is >> how to pull by text status. >> >> I can see that there is a TextStatusID field, which I think would give me >> the results I'm looking for, but I cannot figure out how to determine the >> TextStatusID number for the status I would like to pull. >> >> I think my formula will work if it looks like this: >> >> {TextTypes.TextType} = "Label - Brief" and >> {TextEntries.TextStatusID} = # and >> {TextEntries.TableID} = 108 and >> {TextEntries.ID} = {?Pm-Objects.ObjectID} >> >> However, what I can't figure out is how to find the text status ID number >> to insert for the # sign. >> >> Thank you in advance! >> >> 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. > 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.