Narrowing Selection Critera based on Parameters

[bkanetek]

I am trying to cut the run-time down on a report by altering the SQL sentence for my report based on used defined parameters. I'm not having any luck and need some advice on what my options are. If I alter the SQL sentence directly and refresh the report, it works great, but if I use the Select Expert, the report fetches the entire table and then limits the data displayed to those rows that match my criteria. I'm trying to speed this up by having it select only those rows that meet my criteria on the front side.

Any ideas would be appreciated.

 

[Ngolem]

it is quite simple really if there are only equal joins the following are sames of the statements that could be used in a Record Select Formula:

{table.field1} = {?param1} and
{table.datefield} >= {?StartDateParam} and
{table.datefield} < {?EndDateParam} and
{Table.field2} in {?Multi-selectParam}

If it is possible, Crystal will add these statements to the SQL and push the processing to the server...if this is not possible then the retreived records will get a secondary filtering from statements not pushed down...there is no need to directly modify the SQL.


If you have problems just post your Record Select Formula and we shall see what the problem is

Hope this helps
Jim