ssossossosso

Forums

Covering OroCRM topics, including community updates and company announcements.  Subscribe

This topic contains 2 replies, has 3 voices, and was last updated by Dima Soroka Dima Soroka 3 years, 2 months ago.

  • Creator
    Topic
  • #4668

    Jowo
    Participant

    I’m trying to figure out the report designer. It seems to work well for basic table data. But falls short on more complex stuff. Are there plans to extend the functionality?

    How can I summarize things? Or summarize on the last row?

    For example using OroCRM sample data and the Magento order data. I want to make a report that tells me the total sales amount divided into each month. This seems to complex?

    Like:

    Jan | 130$
    Feb | 125$
    Mar | 150$
    Total | 405$

    Trying to work around this. I tried to create a report that summarizes all sales within a time period. For example this year or a specific month. And this works with the conditions, but each order will be on its own line. How do I sum the total amount of all these orders, either into 1 row or the last row in the report?

Viewing 2 replies - 1 through 2 (of 2 total)
  • Author
    Replies
  • #4683

    Alexandr Smaga
    Participant

    Hello.

    Yes report engine improvements are in our roadmap.
    Unfortunately grouping on date part is not supported yet. Sum on column data is supported for custom grids, but not available in report management yet.

    #4743
    Dima Soroka
    Dima Soroka
    Oro Core

    Hi Jowo

    We are planning to enable following features in our report builder:

    • Grouping functions (like group per month in your example above)
    • Totals per group and per grid

    This will help with your request later. As for now you should consider creation of custom report which is SQL query based (example: Account Life Time Report). Please take a look into orocrm_report-accounts-life_time_value definition grid.

Viewing 2 replies - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.