im new to the Reporting Module and can't really find an answer to following question.
I have a SQL Query as Datasource which returns the amount of assets in a certain department. Lets say department XYZ has 5 assets.
I now have a second Query that returns for every of those 5 assets specific Information.
Now i need to display those query results for each asset on a own page.
Basicaly i want to dynamicly create pages based on the amount of assets i have (each page shows data for one asset) . I could do it manually but that would take ages since the amount of assets per department is a lot more than 5.
Not sure if thats even possible, so i appreciate any tipp that guides me in the right direction.
Thank you in advance,