Method Community

I will try this.  Is this a SQL IN () clause?  Are you parsing the commas into ',' and adding ( and ) on the ends?  That must be what you are doing because in another filter I have the following working fine: RecordID > 0  AND Class IN ('<City>','_National').   "Build Selection ...

I have tried every which way to add IsManuallyClosed = False to my report filter but it does not affect the resulting report.  I have tried: IsManuallyClosed is No, = No, <> True, <> Yes, and ISNULL(IsManuallyClosed,0) = 0, = 0, <> 1.  All don't work.  Whats the secret for filtering for IsManuallyClosed = ...

I need to unlock a screen field only for specific users by name.  I have a conditional statement with Build Selection List based on Session User Name.  I use Type In with the list of users I want to have the condition return true for.  I have a list of users, such as: ...

Russell, Thanks for the reply.  We are using the Standard version so we cannot alter tables.  Looks like we cannot accomplish our dropdown goal. Thanks.

I have a linked field in SalesOrderLine to SalesOrder.DueDate and this field is relabeled StartDueDate in the linked Field.  I can see StartDueDate on my reports. If I create a calculated field that is merely a copy of StartDueDate, like [SalesOrderLine.StartDueDate], it will not print.  I eventually need to do date math in ...

How can I create a dropdown for SalesOrderLine.Other1 and put it into the grid in a SalesOrder screen?  Thanks!

Has anyone been successful setting up a Credit Card Payment Gateway into First Data, the Credit Card processor for Bank Of America?  Thanks!

I am not able to get calculated fields to print on a report.  Neither formulas nor the mere placement of a copy of data from an actual column into a calculated field will print.  What am I missing?  Thanks.

Can I get a PDF of the Method CRM database diagram with table names, column names, data types, primary key indications and lines indicating foreign key table relationships?  I'm looking for something like you can generate using the SQL Server database diagram tool with output printed to a PDF. Thanks!