Hi All,

We have requirement to create a report of both Parent and Child cases created during a period. 

How to display the values at parent case level in child case rows because these values are available only at Parent case. 

For Example : Parent Case A and it has Child Case B

So there will be two records displayed in the report.

There is column say Reference Number (1234567) which is available at parent case and it is blank in child case B.

But we need to display 1234567 as Reference Number for Parent A and Child B in he report.

Is there any way to retrieve reference number for child case using any SQL Function or do we need to do data propagation to child cases for reporting purpose?