Hi, I am trying to group data in my report on different fields based on a calculated value called "pvchCensusSort"(<?xdoxslt:get_variable($_XDOCTX, 'pvchCensusSort'))?>). When pvchCensusSort = 1 then i should group by field ROW.Location, when pvchCensusSort = 2 then "Location" concatenated with “RoomBed” else “PatientLastName” field. I have attached the xml export of the data model, my report is based on. I did a couple of ties trying to group on a xsl function but they look not to be supported in BIP. Then I tried to write something like below: (note the sequence i need is actually nested into an outer static group on EntityName field). Whatever I try to put into square brakets do not help me in any way, either errors out, or do not work as expected.
<?for-each-group:current-group();.[some code here that is based on pvchCensusSort param ]?>
…..
…..
<?end for-each-group?>
Allergy Report_xml.log