Filtering a Database Query

[N22S]

In order to improve response time, I want to limit the amount of data queried from an Oracle database. For example, if I'm querying a table to create a financial statement only reflecting data from period 9, I only want to query the database fields containing that period's data instead of all 12 periods.

Obviously a broad question so I'll be very happy with broad answers that give me a place to start.

Thanks!

 

[synapsevampire]

In the record selection criteria, limit rows using something akin to the following:

month({MyTable.Myfield}) = 9

You can also use a parameter (prompts for user input):

Create a date parameter and then use it in the record selection criteria:

{MyTable.MyDateField} = {?MyDateParameter}

There are several tricks to getting the SQL to pass to the datbase, there are many posts on this site related to this.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com