Port usage report on a FAZ

Hi all

I've been asked to create a report on a customers FAZ that will show port usage per firewall (we are trying to identify a set of ports that are being used so we can create rules to allow them on their Fortigates).

I can create the dataset/sql query (that returns the correct info when I click test in the dataset config) then incorporate that into a report but when I run the report, it has no data to display.

Is there a guide to creating custom reports? Can anyone give me any ideas where I am going wrong?

Cheers