So date purchased, organisation, location?
Should be easy enough - with one caveat...
There is no way to break a report into seperate sections.
I can create a report showing the details and sorted by the above order, but there will be no section breaks, as such.
A screenshot is attached - note I haven't populated any "Date Purchased" fields on this dataset, but it is sorting by that, then Org, then Location...
Try the below definition.
[code]<?xml version="1.0" encoding="ISO-8859-1"?>
<report>
<details>
<report_name>System Replacement</report_name>
<report_display_in_menu>y</report_display_in_menu>
<report_sql>SELECT system.system_id, system.hostname, system.man_manufacturer, system.man_model, system.man_serial, oa_location.location_name, oa_org.org_name, system.man_purchase_date FROM system left join oa_group_sys on system.system_id = oa_group_sys.system_id left join oa_location on system.man_location_id = oa_location.location_id left join oa_org on system.man_org_id = oa_org.org_id where oa_group_sys.group_id = ? GROUP BY system.hostname ORDER BY oa_org.org_name, oa_location.location_name</report_sql>
<report_display_sql></report_display_sql>
<report_view_file>v_report</report_view_file>
<report_view_contents></report_view_contents>
<report_processing></report_processing>
<report_sort_column>1</report_sort_column>
</details>
<columns>
<column>
<column_order>0</column_order>
<column_name>System Name</column_name>
<column_variable>hostname</column_variable>
<column_type>link</column_type>
<column_link>/main/system_display/</column_link>
<column_secondary>system_id</column_secondary>
<column_ternary></column_ternary>
<column_align>left</column_align>
</column>
<column>
<column_order>1</column_order>
<column_name>Date Purchased</column_name>
<column_variable>man_purchase_date</column_variable>
<column_type>text</column_type>
<column_link></column_link>
<column_secondary></column_secondary>
<column_ternary></column_ternary>
<column_align>left</column_align>
</column>
<column>
<column_order>2</column_order>
<column_name>Manufacturer</column_name>
<column_variable>man_manufacturer</column_variable>
<column_type>text</column_type>
<column_link></column_link>
<column_secondary></column_secondary>
<column_ternary></column_ternary>
<column_align>left</column_align>
</column>
<column>
<column_order>3</column_order>
<column_name>Model</column_name>
<column_variable>man_model</column_variable>
<column_type>text</column_type>
<column_link></column_link>
<column_secondary></column_secondary>
<column_ternary></column_ternary>
<column_align>left</column_align>
</column>
<column>
<column_order>4</column_order>
<column_name>Serial</column_name>
<column_variable>man_serial</column_variable>
<column_type>text</column_type>
<column_link></column_link>
<column_secondary></column_secondary>
<column_ternary></column_ternary>
<column_align>left</column_align>
</column>
<column>
<column_order>5</column_order>
<column_name>Owner</column_name>
<column_variable>org_name</column_variable>
<column_type>text</column_type>
<column_link></column_link>
<column_secondary></column_secondary>
<column_ternary></column_ternary>
<column_align>left</column_align>
</column>
<column>
<column_order>6</column_order>
<column_name>Location</column_name>
<column_variable>location_name</column_variable>
<column_type>text</column_type>
<column_link></column_link>
<column_secondary></column_secondary>
<column_ternary></column_ternary>
<column_align>left</column_align>
</column>
</columns>
</report>[/code]
[attachment=0]
1.png [ 227.92 KiB | Viewed 4964 times ]