2007 May 25 9:39 PM
I have a selection screen with several select-options, most of which
allow multiple selections and/or ranges.
These selection crietera have to be used to retrieve data for
a report. I can generate a first SQL statement to retrieve all
the records meeting the top-level selection criteria. And then I would
have to filter the data using several loops to apply the other
selection criteria. I could also create one or more views in the dictionary
to reduce the need for this loop processing.
What is the best way to proceed?
2007 May 25 9:56 PM
Depend on ur database then you can decide ,You could write Normal select query with having join select query .
Please take up in internal table only 3 tables for each join query and if you take more than 3 tables and it would be performance issue.
and also try to use for all entries and it gives better option.
Or you could use JOINs.
Rob
2007 May 25 9:42 PM
2007 May 25 9:56 PM
Depend on ur database then you can decide ,You could write Normal select query with having join select query .
Please take up in internal table only 3 tables for each join query and if you take more than 3 tables and it would be performance issue.
and also try to use for all entries and it gives better option.
| User | Count |
|---|---|
| 6 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |