Report from Excel Spreadsheet gives 10+ blank pages of details before...

[Former Member]

Hi Everybody.

I must be doing something stupid here but I just can't see it.

I've created a new connection to a simple Excel spreadsheet but when I display the data, I get about 10 pages of blank detail before I get the actual detail that I'm looking to display at the bottom.

Any ideas what I'm doing wrong??

Edit.....It's also telling me there are 2700 records when there are only actually 30? It seems to be picking up blanks from somewhere but I have no idea where as all rows and columns in the spreadsheet are consecutive.

Edited by: Graham W on May 28, 2011 1:54 PM

[Former Member]

See second post. A lesson learned for the future :O(

[Former Member]

Problem solved.......I had highlighted the whole column with a colored background and although there was no data in most of the cells, Crystal seemed to be reading the blank cells that were highlighted as data. Weird !!

Thanks for looking.

Graham