Hi - I need some help with a difficult record selection formula, please.
Here's what I'm looking at: I'm running CR9 with a SQL database over a network. (If you need more information than that, let me know, I'm not too technically literate when it comes to networking.)
What I need is to create a record selection formula that will select all the Products that have been sold to both of two clients. Here's what I have so far for the record selection:
{vRDSO.ClientID} = 16 and
{vRDSO.ClientID} = 5
The way the report is set up looks like this:
GH1: {vRDSO.RegionName}
GH2: {vRDSO.Product}
Detail: {vRDSO.ClientID}, {vRDSO.ContractID}
Theoretically, I would like it to print only the products that have sold to client 16 AND client 5, and I know there are a large number (probably a hundred or more), but when I run the above record selection formula, I'm getting a null report.
What (probably very simple) thing am I missing here?
LK
Here's what I'm looking at: I'm running CR9 with a SQL database over a network. (If you need more information than that, let me know, I'm not too technically literate when it comes to networking.)
What I need is to create a record selection formula that will select all the Products that have been sold to both of two clients. Here's what I have so far for the record selection:
{vRDSO.ClientID} = 16 and
{vRDSO.ClientID} = 5
The way the report is set up looks like this:
GH1: {vRDSO.RegionName}
GH2: {vRDSO.Product}
Detail: {vRDSO.ClientID}, {vRDSO.ContractID}
Theoretically, I would like it to print only the products that have sold to client 16 AND client 5, and I know there are a large number (probably a hundred or more), but when I run the above record selection formula, I'm getting a null report.
What (probably very simple) thing am I missing here?
LK