If there is child show URL in parent report

[Master]

I need to show the link to child report in a report based on my parent table if there is any child

[MayMusic]

add a calculated field to your parent report page to count number of child records:

Calculated Field 1:

SELECT COUNT(Parent_ID) FROM Child WHERE Parent_ID = [@field:ID]

"Parent_ID" is foreign key in child table. "Child" is the name of the child table.

add a HTML Block to your parent report and use the code below to show the conditional link:

 

<div id="link[@field:ID]"></div>
<script>
if ([@calcfield:1] >1){
document.getElementById('link'+[@field:ID]).innerHTML = "URL";
}
</script>

[@field:ID] needs to be selected from picker.