<div>
That took care of it....gotta love Experts-Exchange.com<br />
Its like a beatiful woman except much easier to deal with........!
</div>


That took care of it....gotta love Experts-Exchange.com
Its like a beatiful woman except much easier to deal with........!

<div>
^^^ &nbsp;Dude, don't do that. &nbsp;I had coffee in my mouth when I read the above line, and nearly sprayed. <br />
<br />
Thanks for the grade. &nbsp;Good luck with your project. &nbsp;-Jim
</div>


^^^  Dude, don't do that.  I had coffee in my mouth when I read the above line, and nearly sprayed.

Thanks for the grade.  Good luck with your project.  -Jim

<div>
<div class="content wysiwyg-content">
I have a report that needs to pull records that are equal to S, R, or M.<br />
<br />
So I need to pull records from OD_RECORD_TYPE = S,R,M<br />
<br />
1. How do I write that in either section<br />
2.......and does either affect the results since I will need these records for various parts of the report for several columns of data.
</div>
</div>


I have a report that needs to pull records that are equal to S, R, or M.

So I need to pull records from OD_RECORD_TYPE = S,R,M

1. How do I write that in either section
2.......and does either affect the results since I will need these records for various parts of the report for several columns of data.

Filtering records in the FROM clause vs the WHERE clause

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

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.