After you build your query and apply filters, computations, sorts, and any other adjustments to further refine your request, you need to process it. Processing your query may take a few moments if your query is complex or if the data in linked report sections needs to be refreshed.
When you process your query, the data is retrieved to the Results section in tabular form. You can reprocess your query at any time and in any section to refresh the data. You can also return to the Query section from any other section at any time to alter the query and reprocess it.
To process a query:Since an Interactive Reporting document file can contain multiple queries, there are three processing options on the Process drop-down list:
Process Current—Processes the current object. In some cases more than one query may be processed, for example, if a report references results sets from multiple queries. Process Current is the default selection when using the toolbar button.
Process All—Processes all the queries in the document. By default, queries are processed in the order in which they are displayed in the Section catalog. For example, in a document with three queries, Query1, Query2, and Query3, the queries are executed in that order when you select Process All. (See Query Processing Order).
Process Custom—Opens the Process Custom dialog box so that you can select the order in which queries are processed.
The query is sent to the database and retrieved data is displayed in the Results section. While the data is retrieved, the Status bar displays a dynamic row count indicating rate and progress of server data processing and network transfer.
Note: | In the Interactive Reporting Web Client, a ZException might occur if you attempt to process a large query. To process larger queries successfully, increase the value of the DAS property "mdd Partial Result Cell Count", and then restart DAS. |