question report in Community Central forum

report

ahmedt — Thu, 23 Jan 2025 19:57:08 GMT

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

I have 2 table
1. forum table contain the forum and the parent of each forum
2. content table have content of each forum
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

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

Re: report

Community Alums — Sat, 25 Jan 2025 12:34:27 GMT

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

Re: report

ahmedt — Sat, 25 Jan 2025 19:12:03 GMT

hi @Community Alums 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