Uploaded image for project: 'Reporting Module'
  1. Reporting Module
  2. REPORT-348

Allow incremental cell values in repeating sections of excel template

    XMLWordPrintable

    Details

    • Type: New Feature
    • Status: Closed
    • Priority: Could
    • Resolution: Fixed
    • Affects Version/s: Reporting 0.7.1
    • Fix Version/s: Reporting 0.9.2
    • Component/s: Report Renderers
    • Labels:
      None
    • Complexity:
      Medium

      Description

      When using repeating section in an excel template, it should be possible to added cell variables on the template which do the appropriate thing on a row. Here is a use case...Generate a list of patients with name, gender and error checking in an excel formula. On the excel template, use these replacement values: #listOfPatients.name# and #listOfPatients.gender# (no problem). It is not currently possible to add an additional column with an excel formula ( =if(isblank(A10),Error,Good) ), where successive lines to use the appropriate cell. So on the next lines, it should use A11, A12, etc.

        Attachments

        1. results_2012-05-15-020046.xls
          944 kB
        2. template.xls
          7 kB

          Activity

            People

            Assignee:
            mseaton Mike Seaton
            Reporter:
            ball Ellen Ball
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: