Search code examples
rtfbi-publisher

BIP > Sorting is not working on BIP RTF template

I am trying to sort data in my BIP rtf template but it is not working. The report is being generated fine but the group 'Primary Focus' is not being sorted.

This is how report is being generated: https://www.dropbox.com/s/6zratu55hgf9o77/481539039485767out.pdf?dl=0

And this is how 'Primary Focus' needs to be sorted: https://www.dropbox.com/s/7pu2yb86iuccjuv/03.pdf?dl=0

Please find sample xml and rtf.

Rest everything is fine just 'Primary Focus' group is not being sorted.

Solution

  • Just move the sort code

    <?sort:ssFocusTypePrimary;'ascending';data-type='text'?>

    before the grouping code.

    <?sort:ssFocusTypePrimary;'ascending';data-type='text'?><?for-each-group:current-group()[xdoxslt:format_date(ssReportedDate, 'yyyy-mm-dd','mm/dd/yyyy', $_XDOLOCALE, $_XDOTIMEZONE)>= (xdoxslt:format_date($StartDate, 'yyyy-mm-dd','mm/dd/yyyy', $_XDOLOCALE, $_XDOTIMEZONE)) and (xdoxslt:format_date(ssReportedDate, 'yyyy-mm-dd','mm/dd/yyyy', $_XDOLOCALE, $_XDOTIMEZONE))<= (xdoxslt:format_date($EndDate, 'yyyy-mm-dd','mm/dd/yyyy', $_XDOLOCALE, $_XDOTIMEZONE)) and starts-with(ssRohClinicFacilityName,$Clinic) and ssVisitType=$VisitType];./ssFocusTypePrimary?>[![enter image description here][1]][1]

    enter image description here