<div>
Which database are u using?
</div>


<div>
Hi,<br />
If you are using command object for free hand sql, then you can include where clauses for the respective conditions. And if you want to do it thru parameters at Crystal Reports level, then you can use record selection with filter conditions using the parameter values. Provide more details on how you want to achieve this.
</div>


<div>
ok let me make it clearer sorry. im using crystal reports. So every employee has a Company # and a Dept #. I need to capture specific Company numbers with specific Department #. like on the table I showed earlier. what would be the best way to capture them. I tried doing on record selection filtering Companys and filtering departments but there are similar department numbers between companies for example company A can have dept 1 and company B can have dept 1 also and so does C. but lets say I only need company 1 from A and not from B and C.
</div>


<div>
so I need to capture all in Company 700 and 701 and<br />
In in company 400, select only the following depts:<br />
7550, 7800, 7801,7802,7803,7805,7806,8<wbr />133,8800,8<wbr />801,8807,8<wbr />808,8813 and<br />
In company 100, select only the following departments:<br />
7550,7551,7556,7557,7800,8<wbr />800,8813<br />
<br />
so if you see the departments in the Companies are similar. but for some I have to capture everyone and for some I need specific ones
</div>


<div>
Raghavendra Hullur - There was no need to change the SQL I provided. &nbsp;Crystal converts it automatically for you so you can use = with lists as I did.<br />
<br />
mlmcc
</div>


<div>
Thanks mlmcc, is that a new feature or is it like that from earlier versions?
</div>


<div>
Been like that since at least CR8<br />
I tried it before I posted to make sure<br />
<br />
mlmcc
</div>


<div>
<div class="content wysiwyg-content">
hi im new on crystal so please bear with me<br />
for example this is my data<br />
<br />
EMPID &nbsp; &nbsp; COMPANY &nbsp; &nbsp; DEPT<br />
12345 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;100 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;22<br />
23456 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 100 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 23<br />
34567 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 200 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 33<br />
45667 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 200 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;34<br />
11111 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 200 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;35<br />
11112 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 200 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 36<br />
11113 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 200 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 37<br />
11114 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;300 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;11<br />
11115 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;300 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 12<br />
11116 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;300 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 13<br />
11117 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;300 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;14<br />
11118 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;300 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;15<br />
<br />
lets say I need to capture empID in company 100 and on 200 I only need dept 35,36 and on 300 I need depts 11,12,13<br />
how will I be able to get that? lets say there are more data in it with lots of departments but I only need specific ones from specific companies
</div>
</div>


hi im new on crystal so please bear with me
for example this is my data

EMPID     COMPANY     DEPT
12345          100              22
23456           100             23
34567           200             33
45667           200              34
11111           200              35
11112           200               36
11113           200               37
11114            300              11
11115            300               12
11116            300               13
11117            300                14
11118            300                15

lets say I need to capture empID in company 100 and on 200 I only need dept 35,36 and on 300 I need depts 11,12,13
how will I be able to get that? lets say there are more data in it with lots of departments but I only need specific ones from specific companies

how do i grab these records?

Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.