Uploaded image for project: 'WORKTERRA'
  1. WORKTERRA
  2. WT-11766

ACA 2018: Instead of showing a report viewer of analysis report, download the report to excel.

    Details

    • Type: Enhancement
    • Status: Closed
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: ACA
    • Labels:
      None
    • Module:
      ACA
    • Reported by:
      Harbinger
    • Company:
      All Clients/Multiple Clients
    • Item State:
      Development - Development Backlog
    • Severity:
      Simple

      Description

      Analysis report:
      There are some limitations to the report viewer which results in no show of the records when number of records are more.
      However,we have handled it to some extent last year.We have added a page break if the no. of records passes 60000.The rest records come in new page.
      Usually, user exports the records from report viewer to excel.
      If we take an example of a company like Elite Staffing,where in we have furnished almost 67000 employees PDF.The number of records for analysis report is much more (67000*12 months record) and report viewer does not display any records on the screen.
      We are thinking that instead of showing report viewer on click of Analysis report,we will directly export the records in excel format which will be downloaded.
      Advantage: The report will be available to the user in Excel format directly.

      CC: Nandkumar Prabhakar Karlekar,Kumar Chhajed,Smita Pawar

        Attachments

          Activity

          Hide
          ramya.tantry Ramya Tantry (Inactive) added a comment -

          Observations:

          We are using hidden iframe to download.The browsers behave differently to iframe download.
          1. Firefox browser understands when the file is downloaded.So onload event set to the iframe gets fired and we can stop the loader in this case.
          2. Chrome Browser doesn't fire iframe load event on download.So we are not able to stop the loader.
          3. IE browser: Behavior same as chrome but the loader freezes.

          When run on Elite Staffing company on Local, it gave timeout after 10 min and the report did not generate.

          As of now,this Jira is put on hold

          Show
          ramya.tantry Ramya Tantry (Inactive) added a comment - Observations: We are using hidden iframe to download.The browsers behave differently to iframe download. 1. Firefox browser understands when the file is downloaded.So onload event set to the iframe gets fired and we can stop the loader in this case. 2. Chrome Browser doesn't fire iframe load event on download.So we are not able to stop the loader. 3. IE browser: Behavior same as chrome but the loader freezes. When run on Elite Staffing company on Local, it gave timeout after 10 min and the report did not generate. As of now,this Jira is put on hold
          Hide
          ramya.tantry Ramya Tantry (Inactive) added a comment -

          There are some technical challenges using current SSRS functionality and hidden iframe download.So this jira has been rejected for now.

          Show
          ramya.tantry Ramya Tantry (Inactive) added a comment - There are some technical challenges using current SSRS functionality and hidden iframe download.So this jira has been rejected for now.

            People

            Assignee:
            ramya.tantry Ramya Tantry (Inactive)
            Reporter:
            ramya.tantry Ramya Tantry (Inactive)
            Developer:
            Ramya Tantry (Inactive)
            QA:
            Smita Pawar (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Time Tracking

                Estimated:
                Original Estimate - 16h Original Estimate - 16h
                16h
                Remaining:
                Remaining Estimate - 0h
                0h
                Logged:
                Time Spent - 25.5h
                25.5h