Topic: Adding Where to Select Field Posted: 14 Jun 2012 at 3:20am
In SQL, I would do this on the join - could also be a subquery.
My company has a table of customer IDs that has a composite primary key. Because of many mergers, a customer might have up to 5 IDs. It want to select CUSTOMER_ID from that table only where ID_TYPE = 3.
In Crystal, is there a way to do this with a simple formula that can then be used as a field in the report? I will have to do this a lot and would like to avoid using SQL commands or subreports every time, if possible.
Not all customers will have IDs with ID_TYPE = 3. Some will have an ID with ID_TYPE = 2, and they still need to be on the report, but the ID field should be null.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
