Hello,

you can use conditions to hide components in your report.
You can watch a video about disabling components in the reportt:
https://www.youtube.com/watch?v=jo5AMul5Zmk

Thank you.

Hello,

I have attached 2 screenshots that show how the values can be calculated.

Thank you.

Hello,

in that case, you can use grouping for the second band and on the GroupFooterBand use the following expression:
{datasourcename.col2} = {Count(Datadatasourcename2)}

Sample report in the attachment.

Thank you.

Hello,

Try to set property Hyperlink using Bookmark in Iteraction menu for text componet on page1. After that, when you export to PDF, everything will work.

Thank you.