How to add calculations to the report

  • Profile Image
    Les
    Asked on July 16, 2012 at 09:22 AM

    1. Is there a way to create subtotals and totals and fields?

    2. Is there a way to use a parameter like from date and to date?

    Example:

    Form contains week ending date, total hours for week.

    When report is pressed - a from date and to date are presented

    Let's say the from date is 1/1/12 and the to date is 4/1/12

    The report will subtotal by month for total hours and also a total for total hours

     

  • Profile Image
    Mike_T
    Answered on July 16, 2012 at 06:46 PM

    Thank you for contacting us.

    1. Is there a way to create subtotals and totals and fields?

    This is not currently possible to do this using built in features. We have plans to add the calculations to our forms, but unfortunately, there is no ETA on this.

    2. Is there a way to use a parameter like from date and to date? 

    It is possible to generate Excel/CSV report based on some time frame.

    Would you like to see this calculation feature implemented for Excel/CSV reports or Visual Reports?