LabLynx KB:adding order by in AR6

From LIMSWiki
Jump to navigationJump to search

This is an article specific to the Category:LabLynx knowledge base. Its context outside of LabLynx, Inc may not be apparent, thus why it appears inside the LabLynx KB namespace.

Problem

There has been a problem with adding the "Order By" field to the report engine.

Resolution

The "datasource" being set by the AR6 ReportEngine is a DataSet. So, to add "Order By", you need to create/manipulate the default view as shown below and then reset the report DataSource with that new modified view. Code is as follows: 


public void ActiveReport_ReportStart()

{

                System.Data.DataSet ds = (System.Data.DataSet) rpt.DataSource;

                System.Data.DataView dv = ds.Tables[0].DefaultView;

                dv.Sort = "basetestid,paramorder,reportorder";

                rpt.DataSource = dv;

}
Retrieved from "https://test.limswiki.org/index.php?title=LabLynx_KB:Adding_order_by_in_AR6&oldid=6095"