WORKTERRAProject Type: software

WORKTERRA

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

Unable to download excel file for records > 65k from SSRS Report

    Details

    • Type: Bug
    • Status: Closed
    • Priority: High
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: ACA
    • Labels:
      None
    • Environment:
      Others
    • Module:
      ACA - Reports
    • Reported by:
      Harbinger
    • Item State:
      Production Complete - Closed
    • Issue Importance:
      Must Have

      Description

      Unable to download excel file on Analysis report when record count exceeds from 65k on SSRS report

        Attachments

          Activity

          Descending order - Click to sort in ascending order
          Hide
          Permalink
          sachin.hingole Sachin Hingole (Inactive) added a comment -

          Verified on production, working fine.

          Show
          sachin.hingole Sachin Hingole (Inactive) added a comment - Verified on production, working fine.
          Hide
          Permalink
          sachin.hingole Sachin Hingole (Inactive) added a comment -

          Verified on Stage, working fine.

          Show
          sachin.hingole Sachin Hingole (Inactive) added a comment - Verified on Stage, working fine.
          Hide
          Permalink
          sachin.hingole Sachin Hingole (Inactive) added a comment -

          Verified on LB, working fine.

          NOTE - It takes time to download the report, took around 10 Min to download report in excel for wheaton LB copy.

          Show
          sachin.hingole Sachin Hingole (Inactive) added a comment - Verified on LB, working fine. NOTE - It takes time to download the report, took around 10 Min to download report in excel for wheaton LB copy.
          Hide
          Permalink
          kumar.chhajed Kumar Chhajed (Inactive) added a comment -

          3C's
          Concern - Unable to download excel file for records > 65k from SSRS Report
          Cause - this is a limitation of SSRS report through 2008 R2
          Correction - Added groups in RDL of 60k. Now if records exceed more than 60k, it will be added to new sheet.

          Show
          kumar.chhajed Kumar Chhajed (Inactive) added a comment - 3C's Concern - Unable to download excel file for records > 65k from SSRS Report Cause - this is a limitation of SSRS report through 2008 R2 Correction - Added groups in RDL of 60k. Now if records exceed more than 60k, it will be added to new sheet.

            People

            Assignee:
            sachin.hingole Sachin Hingole (Inactive)
            Reporter:
            kumar.chhajed Kumar Chhajed (Inactive)
            Developer:
            Kumar Chhajed (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Time Tracking

                Estimated:
                Original Estimate - 25h
                25h
                Remaining:
                Time Spent - 16.5h Remaining Estimate - 5.5h
                5.5h
                Logged:
                Time Spent - 16.5h Remaining Estimate - 5.5h Time Not Required
                16.5h