Results 1 to 2 of 2

Thread: Export to Excel - New problem -- need help if you know abt it

  1. #1
    Join Date
    Feb 2009

    Unhappy Export to Excel - New problem -- need help if you know abt it


    I am having a problem with export to excel function in SSRS 2005, you must be thinking there are many post available for this topic but believe i am having a new problem ( I believe).

    I created a ad hoc report from the report model. (Report builder(1.0)). Reports shows Total rows is 7311.( attached file) and when i export to Excel then its shows 7019 (just data) and when i export as a CSV file then its shows 7017 rows.

    First, i thought it may be a header count but i am not sure thats true..

    there is a difference of 290 + rows in the report. so, what is this cause.. is any one come across like this.

    Please guys, I need your help..

    Attached Images Attached Images
    Last edited by mitkush; 02-23-2009 at 05:09 PM. Reason: forget to attached file

  2. #2
    Join Date
    Feb 2009
    ensure there are no data filters are active on the Excel spreadhseet. Also check to see if there are data types stored in SQL that may not transfer over to CSV or XLS easily (if at all)

    Hope this helps

    Larry Darrah
    MS Archtiect Evangelist

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts