I've got a table built using the table wizard that seems to be trying to generate an infinite number of pages.
There's only supposed to be a little over 200 records, but when I hit the preview tab, it works until it hits an out of memory exception. I tried the HTML preview, and it will actually show me the first page of the report, which is all of the right records, but the page count keeps going up, and all of the other pages are exactly the same as the first page. The first time I didn't notice that the page count was going up, and it got up to over 1100 pages.
I've verified that my query is returning the right number of records. It seems to be just this table.
What's going on here?
Thanks
There's only supposed to be a little over 200 records, but when I hit the preview tab, it works until it hits an out of memory exception. I tried the HTML preview, and it will actually show me the first page of the report, which is all of the right records, but the page count keeps going up, and all of the other pages are exactly the same as the first page. The first time I didn't notice that the page count was going up, and it got up to over 1100 pages.
I've verified that my query is returning the right number of records. It seems to be just this table.
What's going on here?
Thanks
1 Answer, 1 is accepted
0
Devin
Top achievements
Rank 1
Rank 1
answered on 09 Nov 2011, 12:33 AM
Ah, I just found something about not having a data source in both the report and the table. I removed the report data source, and it's working fine now.