I am trying to create a report that shows the accounts and the number of their meetings (that the meetings start time is greater than a certain date) for each account.
I did this:
but it returns no result.
Any suggestions?
I am trying to create a report that shows the accounts and the number of their meetings (that the meetings start time is greater than a certain date) for each account.
I did this:
Any suggestions?
Hello Omid,
as Harshad suggested - that looks good.
If you’d like to see more about reporting in SuiteCRM, check out this video:
and the written version if you’re interested, including some more reporting topics:
Thank you Harshad for your point, it works now but when I add condition there is no result again.
Can u please help me how to find number of meetings that held after specific date?
The condition I set is:
Thank you
Please don’t set any value to your condition parameter (keep it blank) and select the date value on detail page.
Unfortunately it doesnt work, I tried with status in condition and it works but when I use start date in condition, it returns no result:
Have you tried setting a date on your detail page of report. Also set greater or less than operator as equal to operator might check exact date time value. Hope this works.
I found that the report does not work on my account (Administrator), but works on some of other users (not administrator users)
Anothe problem is that when report is ready and shows first page, when I go to the next page results will be zero
First page result:
SuiteCRm Log:
Query Failed: SELECT `accounts`.name AS 'Name0', `accounts`.industry AS 'Proficiency1',>
AND `accounts:meetings`.parent_type = 'Accounts'
LEFT JOIN `accounts_cstm` `accounts_cstm` ON `accounts`.id = `accounts_cstm`.id_c WHERE ( `accounts:meetings`.date_start > '08/09/2024 11:00' AND `accounts:meetings`.>