WORKTERRAProject Type: software

WORKTERRA

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

          Ascending order - Click to sort in descending order
          ramya.tantry Ramya Tantry (Inactive) created issue -
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Field Original Value New Value
          Status New Request [ 10029 ] Pending for Approval [ 10002 ]
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Status Pending for Approval [ 10002 ] Approved for Development [ 10003 ]
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Status Approved for Development [ 10003 ] In Development [ 10007 ]
          ramya.tantry Ramya Tantry (Inactive) made changes -
          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.           		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],[~kumar.chhajed],[~smita.pawar]
          kumar.chhajed Kumar Chhajed (Inactive) made changes -
          Remaining Estimate 16h [ 57600 ] 15.5h [ 55800 ]
          Time Spent 0.5h [ 1800 ]
          Worklog Id 86038 [ 86038 ]
          Permalink
          kumar.chhajed Kumar Chhajed (Inactive) logged work - 24/Oct/17 01:51 PM
          • Time Spent:
            0.5h
             

            Internal Discussion

          Permalink
          ramya.tantry Ramya Tantry (Inactive) logged work - 24/Oct/17 03:56 PM
          • Time Spent:
            5h
             

            Discussion
            coding
            testing

          ramya.tantry Ramya Tantry (Inactive) made changes -
          Remaining Estimate 15.5h [ 55800 ] 10.5h [ 37800 ]
          Time Spent 0.5h [ 1800 ] 5.5h [ 19800 ]
          Worklog Id 86168 [ 86168 ]
          Permalink
          ramya.tantry Ramya Tantry (Inactive) logged work - 25/Oct/17 12:38 PM
          • Time Spent:
            6h
             

            Coding
            testing
            analysis and R&D on loader issue

          ramya.tantry Ramya Tantry (Inactive) made changes -
          Remaining Estimate 10.5h [ 37800 ] 4.5h [ 16200 ]
          Time Spent 5.5h [ 19800 ] 11.5h [ 41400 ]
          Worklog Id 86347 [ 86347 ]
          kumar.chhajed Kumar Chhajed (Inactive) made changes -
          Remaining Estimate 4.5h [ 16200 ] 4h [ 14400 ]
          Time Spent 11.5h [ 41400 ] 12h [ 43200 ]
          Worklog Id 86353 [ 86353 ]
          Permalink
          kumar.chhajed Kumar Chhajed (Inactive) logged work - 25/Oct/17 01:43 PM
          • Time Spent:
            0.5h
             

            Internal Discussion with Ramya

          ramya.tantry Ramya Tantry (Inactive) made changes -
          Item State Parent values: Development(10200)Level 1 values: In Progress(10206) Parent values: Development(10200)Level 1 values: On Hold(10207)
          Permalink
          kumar.chhajed Kumar Chhajed (Inactive) logged work - 30/Oct/17 01:16 PM
          • Time Spent:
            1h
             

            Analysis
            Internal Discussion

          kumar.chhajed Kumar Chhajed (Inactive) made changes -
          Remaining Estimate 4h [ 14400 ] 3h [ 10800 ]
          Time Spent 12h [ 43200 ] 13h [ 46800 ]
          Worklog Id 87830 [ 87830 ]
          Permalink
          ramya.tantry Ramya Tantry (Inactive) logged work - 30/Oct/17 04:29 PM
          • Time Spent:
            6.5h
             

            Analysis report chrome issue analysis
            SSRS report viewer workaround analysis

          ramya.tantry Ramya Tantry (Inactive) made changes -
          Remaining Estimate 3h [ 10800 ] 0h [ 0 ]
          Time Spent 13h [ 46800 ] 19.5h [ 70200 ]
          Worklog Id 88018 [ 88018 ]
          kumar.chhajed Kumar Chhajed (Inactive) made changes -
          Time Spent 19.5h [ 70200 ] 20.5h [ 73800 ]
          Worklog Id 88314 [ 88314 ]
          Permalink
          kumar.chhajed Kumar Chhajed (Inactive) logged work - 31/Oct/17 01:58 PM
          • Time Spent:
            1h
             

            Internal Discussion with team

          Permalink
          ramya.tantry Ramya Tantry (Inactive) logged work - 31/Oct/17 04:01 PM - edited
          • Time Spent:
            5h
             

            Internal discussion and analysis
            Coding changes and testing

          ramya.tantry Ramya Tantry (Inactive) made changes -
          Time Spent 20.5h [ 73800 ] 23.5h [ 84600 ]
          Worklog Id 88452 [ 88452 ]
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Time Spent 23.5h [ 84600 ] 25.5h [ 91800 ]
          Worklog Id 88452 [ 88452 ]
          Hide
          Permalink
          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
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Status In Development [ 10007 ] Local Testing [ 10200 ]
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Status Local Testing [ 10200 ] Reopen in Local [ 10018 ]
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Status Reopen in Local [ 10018 ] In Development [ 10007 ]
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Status In Development [ 10007 ] Local Testing [ 10200 ]
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Status Local Testing [ 10200 ] Pending for Stage Approval [ 10300 ]
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Status Pending for Stage Approval [ 10300 ] Approved for Stage [ 10030 ]
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Status Approved for Stage [ 10030 ] Stage Testing [ 10201 ]
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Status Stage Testing [ 10201 ] Pending for Production Approval [ 10301 ]
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Status Pending for Production Approval [ 10301 ] Approved for production [ 10034 ]
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Status Approved for production [ 10034 ] Production Testing [ 10202 ]
          Hide
          Permalink
          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.
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Resolution Cancelled [ 10300 ]
          Status Production Testing [ 10202 ] Production Complete [ 10028 ]
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Resolution Cancelled [ 10300 ] Fixed [ 1 ]
          Status Production Complete [ 10028 ] Closed [ 6 ]
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Item State Parent values: Development(10200)Level 1 values: On Hold(10207) Parent values: Development(10200)Level 1 values: Development Backlog(10205)
          Transition Time In Source Status Execution Times
          Ramya Tantry (Inactive) made transition -
          New Request Pending for Approval
          		15s 1
          Ramya Tantry (Inactive) made transition -
          Pending for Approval Approved for Development
          		3s 1
          Ramya Tantry (Inactive) made transition -
          Approved for Development In Development
          		3s 1
          Ramya Tantry (Inactive) made transition -
          In LB Testing Reopen in Local
          		41s 1
          Ramya Tantry (Inactive) made transition -
          Reopen in Local In Development
          		4s 1
          Ramya Tantry (Inactive) made transition -
          In Development In LB Testing
          		50d 1h 4m 2
          Ramya Tantry (Inactive) made transition -
          In LB Testing Pending for Stage Approval
          		3s 1
          Ramya Tantry (Inactive) made transition -
          Pending for Stage Approval Approved for Stage
          		2s 1
          Ramya Tantry (Inactive) made transition -
          Approved for Stage Stage Testing
          		2s 1
          Ramya Tantry (Inactive) made transition -
          Stage Testing Pending for Production Approval
          		3s 1
          Ramya Tantry (Inactive) made transition -
          Pending for Production Approval Approved for production
          		2s 1
          Ramya Tantry (Inactive) made transition -
          Approved for production In Production Testing
          		3s 1
          Ramya Tantry (Inactive) made transition -
          In Production Testing Production Complete
          		2m 43s 1
          Ramya Tantry (Inactive) made transition -
          Production Complete Closed
          		3s 1

            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