Record type variable inside process report

Hi Sarathkumar R ,

Did you use below configurations:

I followed the same. Not working as expected

Please follow this process:

Create a process report by above picture:

1. Go to Edit Tab - Create new data as shown below:




2. Create an Expression Rule by using a!queryProcessAnalytics you can query whole data of process reports.




3. Use the rule to get data into read only grid.



4. Index the data and store it into rows as your wish.

Note: If your records are of 23.4 version you only get primary key of that record, if that is before of 23.4 or after 24.1, you'll get whole data.

You can create as many as process variables in the data section of process reports.

Reference of 23.4 :



I hope you got the answer! :)

Please follow this process:

Create a process report by above picture:

1. Go to Edit Tab - Create new data as shown below:




2. Create an Expression Rule by using a!queryProcessAnalytics you can query whole data of process reports.




3. Use the rule to get data into read only grid.



4. Index the data and store it into rows as your wish.

Note: If your records are of 23.4 version you only get primary key of that record, if that is before of 23.4 or after 24.1, you'll get whole data.

You can create as many as process variables in the data section of process reports.

Reference of 23.4 :



I hope you got the answer! :)

We are using 23.4 version. I tried the same. I am not getting the value. Only null values Im getting

If you are getting null values then id is not passing into the PV, if its an array, can you check the all Ids, are they null?

If not null, you can call a rule into the grid to get whole data of that particular Id.



Still not solved, then post your data configuration in process reports.

All Ids are empty. 
This is the configuration Im using

this issue is also faced by me in this process instances are having value but it is not coming in the report

With a  script task convert them to CDT so that we can get data easily, but not a best practice

it says in documentation you can't index individual record column . Report Column Configuration

Thanks for the clarification

And one more thing to add If you referenced a record type variable as a column in the report, it will not display in the report designer but you can still query this data using analytics. Go through the above link for more details

I tried the same. Its not working as expected. Better to go with CDTs