Hi,
We have a report which displays lot's of info.
but we do have a wizard sort of functionality which allows the user to select a lot of criteria based on which the report will be displayed.
When the Selection formula is modified will it change the SQL of the report so that the conditions are added to the query and executed(which i think gives a better performance) or is the selection done after executing the generalized query and fetching the results.
eg:
if i want to display a specific set of records between 2 dates my query at the design time will be something like "select * from table" and at the run time it should get changed to "select * from table where date between 12/03/2001 and 12/04/2001".
will crystal report does this or will it just execute the first query and after getting all the results will it display only those between these dates.
I need this clarification asap.
please help me out.
regards,
venu.
We have a report which displays lot's of info.
but we do have a wizard sort of functionality which allows the user to select a lot of criteria based on which the report will be displayed.
When the Selection formula is modified will it change the SQL of the report so that the conditions are added to the query and executed(which i think gives a better performance) or is the selection done after executing the generalized query and fetching the results.
eg:
if i want to display a specific set of records between 2 dates my query at the design time will be something like "select * from table" and at the run time it should get changed to "select * from table where date between 12/03/2001 and 12/04/2001".
will crystal report does this or will it just execute the first query and after getting all the results will it display only those between these dates.
I need this clarification asap.
please help me out.
regards,
venu.