No Sorting node in report datasource, also no OrderMode in propert

[Celeste]

Hi
I am having difficulty grouping a report.

If I create a report with the report wizard, I can see the 'Sorting' node in
the report datasource, but when I create a report in the AOT, and drag and
drop the table I want to use from the DataDictionary to the report data
source, the 'Sorting' node is not available. Also, the OrderMode property on
the datasource is gone.

I use the same table in both the reports (the one created with the wizard,
and the one created in the AOT). And still only the one created with the
wizard have the 'Sorting' node and the OrderMode property. All the other
properties of of the datasources and the report is exactly the same.

I want to create the report in the AOT because I have specific condition
that I need to add to the fetch method. but the problem is now that I cannot
group the report, even if I add section groups in the Design, it does not
show.

Does anybody have a solution?

Thanks.

[sams9]

Hi Celeste,
You would have to use the "Order By" and "Group By" nodes instead.
It looks like the "Sorting" node is old (?) style.
Here is what I mean by old style..go to the first report, AssetAcquisition
(note it has Sorting)-> right-click on "Order By" node click New Field. You
get this error message; Cannot mix old-style sorting with new-style Group By
or Order By on a query.

Post by Celeste
Hi
I am having difficulty grouping a report.
If I create a report with the report wizard, I can see the 'Sorting' node in
the report datasource, but when I create a report in the AOT, and drag and
drop the table I want to use from the DataDictionary to the report data
source, the 'Sorting' node is not available. Also, the OrderMode property on
the datasource is gone.
I use the same table in both the reports (the one created with the wizard,
and the one created in the AOT). And still only the one created with the
wizard have the 'Sorting' node and the OrderMode property. All the other
properties of of the datasources and the report is exactly the same.
I want to create the report in the AOT because I have specific condition
that I need to add to the fetch method. but the problem is now that I cannot
group the report, even if I add section groups in the Design, it does not
show.
Does anybody have a solution?
Thanks.
--
//https://www.xing.com/profile/Celeste_Lategan

[Celeste]

Hi
I did use the old-style group by and sorting by, but the report still did
not group. I am absolutely sure that I have indictaed the groupings
correctly on the design.

As a way around this I have decided to create the report with the wizard and
then add changes to the fetch method. That seems to work.

Regards,
Celeste
--
//https://www.xing.com/profile/Celeste_Lategan

Post by sams9
Hi Celeste,
You would have to use the "Order By" and "Group By" nodes instead.
It looks like the "Sorting" node is old (?) style.
Here is what I mean by old style..go to the first report, AssetAcquisition
(note it has Sorting)-> right-click on "Order By" node click New Field. You
get this error message; Cannot mix old-style sorting with new-style Group By
or Order By on a query.

Post by Celeste
Hi
I am having difficulty grouping a report.
If I create a report with the report wizard, I can see the 'Sorting' node in
the report datasource, but when I create a report in the AOT, and drag and
drop the table I want to use from the DataDictionary to the report data
source, the 'Sorting' node is not available. Also, the OrderMode property on
the datasource is gone.
I use the same table in both the reports (the one created with the wizard,
and the one created in the AOT). And still only the one created with the
wizard have the 'Sorting' node and the OrderMode property. All the other
properties of of the datasources and the report is exactly the same.
I want to create the report in the AOT because I have specific condition
that I need to add to the fetch method. but the problem is now that I cannot
group the report, even if I add section groups in the Design, it does not
show.
Does anybody have a solution?
Thanks.
--
//https://www.xing.com/profile/Celeste_Lategan

[Anitha Santosh]

Hi,

You can add these methods in init or initQuery methods..

Post by Celeste
Hi
I am having difficulty grouping a report.
If I create a report with the report wizard, I can see the 'Sorting' node in
the report datasource, but when I create a report in the AOT, and drag and
drop the table I want to use from the DataDictionary to the report data
source, the 'Sorting' node is not available.  Also, the OrderMode property on
the datasource is gone.
I use the same table in both the reports (the one created with the wizard,
and the one created in the AOT).  And still only the one created with the
wizard have the 'Sorting' node and the OrderMode property.   All the other
properties of of the datasources and the report is exactly the same.
I want to create the report in the AOT because I have specific condition
that I need to add to the fetch method.  but the problem is now that I cannot
group the report, even if I add section groups in the Design, it does not
show.
Does anybody have a solution?
Thanks.
--
//https://www.xing.com/profile/Celeste_Lategan