Who's On?

	Membership:
	Latest: Alanna
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5294

	People Online:
	Visitors: 428
	Members: 0
	Total: 428

Name	Points
Greg Moeller	4184
David Williams	3349
JonA	3291
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1377
Roger French	1315
mark.cook	1244

Max export to excel ?

3 Replies

0 Subscribed to this topic

22 Subscribed to this forum

Sort:

Author

Messages

jeff-lbi

Basic Member Send Private Message

Posts: 21

2/6/2012 2:18 PM

I recently ran a report where the result set was close to 200,000. I know this would require excel to have 4 sheets.

Instead of finishing it prompted for a login information and asked for a refreshed data set

Does LBI start to have a problem exporting to excel after so many records?

Matthew Nye

Veteran Member Send Private Message

Posts: 514

2/7/2012 8:02 PM

im not sure but Excel 2007 supports over 1 million rows. No sure what method LBI uses to generate the excel file. try putting in a where clause to limit your records to under 63,000 and that should at least answer your question as to if the record count is the issue.

You could export to data only (unless this is scheduled).

jeff-lbi

Basic Member Send Private Message

Posts: 21

2/8/2012 7:43 PM

Good point about the record count.

I actually ran the report twice with a date range that would give me 150,000 for the first, and about 60,000 for the second run, and both went to excel fine, but the complete result set (a little over 210,000) won't finish.

Matthew Nye

Veteran Member Send Private Message

Posts: 514

2/8/2012 8:10 PM

hmmm, i wonder if its a data issue. have you looked in your log files to see if there are any exceptions when the report doesnt export?