I have an Interactive Report whose source is set with a PL/SQL Function Body returning SQL Query. The SQL:
SELECT record_id, doc_name, file_name, issued_date
FROM tbl_files
ORDER BY record_id;
In the column attributes, I have set the sequences as follows:
record_id (1), doc_name (10), file_name (30), issued_date (40)
The columns are listed in the correct order in the Page Designer Columns sub-node, but for some reason, when the IR renders on the page the issued_date column appears before the file_name column. Is there another attribute or setting that I'm overlooking that sets the column order for an IR? The only thing I can think of is initially the Source SQL had column ordered issued date then file_name. I have since updated the SQL (to the above SQL), and I ran the Synchronized Columns context menu action.
Thanks,
Mike