Advanced reports

[ewise]

Hi

I would like several reports but i am not sure if its possible using the reports module.
For example i would like to report the following:
Meetings(amount) in a Month VS Meetings previous month VS Meetings same month but previous year.

Is it possible to make this query using the reports module?
Or is there an add-on/plugin or external reporting module which is able to report queries like these?

thanks,
Vincent

[sanjaykatiyar1]

You can have a look at Jasper reports.

[sugarcane]

Hi Vincent,

out of the box with Pro reporting, it is not possible to display all of these items into one report. You could easily create 3 separate reports which display:

Total Meetings(amount) in a Month
Meetings last month
Meetings last year (based on the date range you specify)

you could then compare all of these.

If you are using Enterprise, you can use the enterprise reporting to create a SQL query that could pull all three of these queries into one report.

[JVWay]

Specifically from Jasper get the iReportNB module. That installs on your desktop and you only need a login to your db. You'll need some knowledge of the underlying db structure to create reports there but that's also true of Sugar's enterprise reporting.

You might be able to do this in the new matrix reporting though.