Required to know the number of accounts involved in my report

[Dinu1]

Hi,

I have created a report based on member types. However, my aim is to know how many accounts have associated with each member type. Also, member type is a dropdown.

I have tried many ways, but I found a way by adding a parameter to select the member type in the dropdown and get the count of the member type.

Is there any other ways I can filter out my member type count

[BrozTechnologies]

There is a free module created by @mvnrsa

Powerful Reports (Using any SQL)

I disabled error reporting on my PHP configuration file ans was able to install and test your module. Now Don’t know what else is missing because when I try to display information on HTML I get this error: Warning: file_put_contents(/tmp/f477e065601fdc3f3e671bcb2c91d44d.html): failed to open stream: No such file or directory in …\modules\adrep_report\adrep_report.php on line 613 Warning: require(/tmp/f477e065601fdc3f3e671bcb2c91d44d.html): failed to open stream: No such file or directory in …

You can create your custom query and get your custom reports in SuiteCRM

[Dinu1]

Hi @BrozTechnologies,

Thank you so much for your prompt response.

[mvnrsa]

It seems you are using my module on a Windoze instance, which is something I never test. (Windoze does not have a /tmp/ folder.)

You will have to edit \modules\adrep_report\adrep_report.php and change the location of the temporary files (all occurances of /tmp).