DevOps, CI/CD and Automation

hi,
I wish to build a jsp report in which the query is sorted by a user parameter. Passing parameters to the WHERE clause works, but it doesnt for the ORDER BY clause. This is what I wish to do


<%@ taglib uri="/WEB-INF/lib/reports_tld.jar" prefix="rw" %>
<%@ page language="java" import="java.util.*;" errorPage="/rwerror.jsp" session="false" %>
<%@ page contentType="application/vnd.ms-excel"%>
<rw:report id="report" parameters="userid=usr/pwd@db">
<rw:objects id="objects">
<?xml version="1.0" encoding="WINDOWS-1252" ?>
<report name="REPORT_EXCEL" DTDVersion="9.0.2.0.10">
<xmlSettings xmlTag="REPORT_EXCEL" xmlPrologType="text">
<![CDATA[<?xml version="1.0" encoding="&Encoding"?>]]>
</xmlSettings>
<data>
<userParameter name="P_COD_USR" datatype="character" width="40"
defaultWidth="0" defaultHeight="0"/>
<userParameter name="P_ORD" datatype="character" width="40"
defaultWidth="0" defaultHeight="0"/>

<systemParameter name="MODE" initialValue="Default" display="yes"/>
<systemParameter name="ORIENTATION" initialValue="Default" display="yes"/>

<dataSource name="Q_ITEMS">
<select>
<![CDATA[SELECT
Cod_Item AS Q_COD_ITEM,
Des_Item AS Q_DES_ITEM,
Price AS Q_PRICE,
cod_Usr AS Q_COD_USR
FROM
DS_ITEMS
WHERE
COD_USR = :P_COD_USR
ORDER BY
:P_ORD]]>
</select>
....


I wish to call this report passing P_COD_USR=usr&P_ORD=COD_ITEM or P_COD=DES_ITEM, but it seems to have no effect on sorting the query.
any idea on how to do it?
thanks