Export to Excel - New problem -- need help if you know abt it
Hello,
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..
Thanks,
Mit
Last edited by mitkush; 02-23-2009 at 05:09 PM.
Reason: forget to attached file
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)