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.