report

[ahmedt]

Hi all , wish you have good day 
- the problem is :

1. I have 2 table 
   1. forum table contain the forum and the parent of each forum 
   2. content table have content of each forum
2. I want to make a report to see the count of each forum and the number of each sub forum and number of content
   be like 

main forum name

number of sub forum

number of videos

number of images

1. I can get only one of the number (sub forum , content) because there is two different table
   
   

what I try out :
- datasets : it is not working on the multi pivot tables

- function filed : there is no operation can count the sub filed row in the table

 what is the goal :
try to get the number of content and subforum in same quiz

[Juhi Poddar]

Hello @ahmedt 

• Since you are working with two separate tables (forum and content), use Database Views for creating report.
• Database Views allow you to combine data from multiple tables into a single view, which can then be used for reporting.
• It creates a virtual table by combining multiple tables based on condition and later can be used for creating reports.

Please refer this document to learn more about database view:  Database view for reporting 

Hope this helps!

"If you found my answer helpful, please like and mark it as an "accepted solution". It helps future readers to locate the solution easily and supports the community!"

Thank You
Juhi Poddar

[ahmedt]

hi @Juhi Poddar  thanks for your reply 
but unfortunately it does not work to because it will contait the the content of  forum but not the the relation between the forums 
thanks for you answer 
have a good day