I have a report that I would like to call from a number of different query operations & form operations. So I have the checked 'Data determined at run time'. My stumbling block is in sorting the data.
I am able to control the sort order of sub-reports by setting the Data Source of the embedded report, but can't figure out how to control the sort order of the 'top' level of the report (which is not a sub-report).
If I change it to a 'Custom Query', I loose the flexibility of determining the data on the report from the context of the form operation or query operation. Right?
Is there something I am missing?
Thanks,
Tom
Sorting a Report when data is 'Determined at run time'
-
- Posts: 595
- Joined: Sun Apr 24, 2005 2:22 am
- Contact:
Support,
A Query is only involved in calling this report from an Operation on the Query. The report is 'determined at run-time'. Sometimes this report will be called via a Form Operation & therefore will only include 1 BO instance & obviously sort order does not matter then.
The sort order of the BO items on the report does not seem to be effected by the sort order of the Query that calls it via Create Document operation.
I'll send you a test BSV if you'd like.
Tom
PS -- you can ignore my mention of subqueries in the initial post. They have no bearing on the core question.
A Query is only involved in calling this report from an Operation on the Query. The report is 'determined at run-time'. Sometimes this report will be called via a Form Operation & therefore will only include 1 BO instance & obviously sort order does not matter then.
The sort order of the BO items on the report does not seem to be effected by the sort order of the Query that calls it via Create Document operation.
I'll send you a test BSV if you'd like.
Tom
PS -- you can ignore my mention of subqueries in the initial post. They have no bearing on the core question.
-
- Posts: 595
- Joined: Sun Apr 24, 2005 2:22 am
- Contact:
Hi Tom,
> The sort order of the BO items on the report does not seem to be effected by the sort order of the Query that calls it via Create Document operation.
Do you mean manually selecting multiple items in a query result table and then starting a Create Document operation for the selected items?
> The sort order of the BO items on the report does not seem to be effected by the sort order of the Query that calls it via Create Document operation.
Do you mean manually selecting multiple items in a query result table and then starting a Create Document operation for the selected items?
Aware IM Support Team
I finally figured out how to get a Report's data to be BOTH 'determined at run time' and sort order defined in Custom Query section of the report specs:
1- Define the report
2- In the "Data shown on the report" section:
2a- Click on Run Query / Custom Query
2b- Select BO to look for and Sort Results desired
2c- Click "Determined at run time"
While the radio button options make it look like 2a and 2c are mutually exclusive, they are NOT. You can determine the sort order with 2c and the instances of the BO at run time by selecting 2a.
If this behavior is not by design, please don't let this "feature" disappear in future versions.
Thanks,
Tom
1- Define the report
2- In the "Data shown on the report" section:
2a- Click on Run Query / Custom Query
2b- Select BO to look for and Sort Results desired
2c- Click "Determined at run time"
While the radio button options make it look like 2a and 2c are mutually exclusive, they are NOT. You can determine the sort order with 2c and the instances of the BO at run time by selecting 2a.
If this behavior is not by design, please don't let this "feature" disappear in future versions.
Thanks,
Tom
Support,
Please ignore my post yesterday. While those steps works with a mini test BSV I put together, they do not work BSV in question.
Yes - when manually selecting multiple items in a query result table and then starting a Create Document operation for the selected items, I would like the Document [which is flag as 'Determined at run time'] to reflect the sort order of the calling query.
Can that be accomplished?
Thanks!
Tom
Please ignore my post yesterday. While those steps works with a mini test BSV I put together, they do not work BSV in question.
Yes - when manually selecting multiple items in a query result table and then starting a Create Document operation for the selected items, I would like the Document [which is flag as 'Determined at run time'] to reflect the sort order of the calling query.
Can that be accomplished?
Thanks!
Tom
-
- Posts: 7527
- Joined: Sun Apr 24, 2005 12:36 am
- Contact:
-
- Posts: 7527
- Joined: Sun Apr 24, 2005 12:36 am
- Contact: